[
https://issues.apache.org/jira/browse/PHOENIX-4721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16460272#comment-16460272
]
Hudson commented on PHOENIX-4721:
---------------------------------
SUCCESS: Integrated in Jenkins build Phoenix-4.x-HBase-0.98 #1876 (See
[https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/1876/])
PHOENIX-4721 Adding PK column to a table with multiple secondary indexes
(jtaylor: rev 8c9f2f68d91bd11e057fcee6abae9ea60acae124)
* (edit)
phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java
* (edit)
phoenix-core/src/it/java/org/apache/phoenix/end2end/AlterTableWithViewsIT.java
> Adding PK column to a table with multiple secondary indexes fails
> -----------------------------------------------------------------
>
> Key: PHOENIX-4721
> URL: https://issues.apache.org/jira/browse/PHOENIX-4721
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.13.0
> Reporter: Jan Fernando
> Assignee: James Taylor
> Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: AlterTableExtendPk.java, PHOENIX-4721_v1.patch
>
>
> The expected behavior when adding a PK column to table is that the column
> will successfully be added, even if the table has secondary indexes.
> For example:
> {code:java}
> ALTER TABLE TEST.ACTIVITY ADD SOURCE VARCHAR(25) NULL PRIMARY KEY
> {code}
> should execute successfully even if the table has secondary indexes defined.
> However issuing the above ALTER statement on a table with secondary indexes
> throws the following Exception:
> {code:java}
> java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at
> org.apache.phoenix.schema.RowKeyValueAccessor.<init>(RowKeyValueAccessor.java:78)
> at
> org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3452)
> at
> org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3120)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1328)
> at org.apache.phoenix.jdbc.PhoenixStatement$3.call(PhoenixStatement.java:393)
> at org.apache.phoenix.jdbc.PhoenixStatement$3.call(PhoenixStatement.java:1)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:375)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:269)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
> {code}
> See attached file for a detailed repro.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
