You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Sergey Soldatov (Jira)" <ji...@apache.org> on 2022/01/05 16:26:00 UTC
[jira] [Resolved] (PHOENIX-6619) Secondary indexes on the columns with a default value works incorrectly
[ https://issues.apache.org/jira/browse/PHOENIX-6619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Soldatov resolved PHOENIX-6619.
--------------------------------------
Resolution: Duplicate
> Secondary indexes on the columns with a default value works incorrectly
> -----------------------------------------------------------------------
>
> Key: PHOENIX-6619
> URL: https://issues.apache.org/jira/browse/PHOENIX-6619
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.1.2
> Reporter: Sergey Soldatov
> Assignee: Sergey Soldatov
> Priority: Major
>
> When we create an index on the column that has a default value, this value is always used in the index table.
> {noformat}
> 0: jdbc:phoenix:> CREATE TABLE T5(I1 INTEGER NOT NULL, S1 VARCHAR NOT NULL, D1 DATE DEFAULT DATE'1900-01-01', CONSTRAINT PK PRIMARY KEY(I1,S1));
> No rows affected (1.165 seconds)
> 0: jdbc:phoenix:> upsert into T5 values (1, 'test', '1900-02-02');
> 1 row affected (0.086 seconds)
> 0: jdbc:phoenix:> create index I5 on T5 (d1);
> select * from t5;
> 1 row affected (6.115 seconds)
> 0: jdbc:phoenix:> select * from t5;
> +----+------+------------+
> | I1 | S1 | D1 |
> +----+------+------------+
> | 1 | test | 1900-01-01 |
> +----+------+------------+
> 1 row selected (0.261 seconds)
> 0: jdbc:phoenix:> drop table t5;
> No rows affected (1.552 seconds)
> 0: jdbc:phoenix:> CREATE TABLE T5(I1 INTEGER NOT NULL, S1 VARCHAR NOT NULL, D1 DATE DEFAULT DATE'1900-01-01', CONSTRAINT PK PRIMARY KEY(I1,S1));
> No rows affected (1.162 seconds)
> 0: jdbc:phoenix:> upsert into T5 values (1, 'test', '1900-02-02');
> 1 row affected (0.082 seconds)
> 0: jdbc:phoenix:> select * from t5;
> +----+------+------------+
> | I1 | S1 | D1 |
> +----+------+------------+
> | 1 | test | 1900-02-02 |
> +----+------+------------+
> 1 row selected (0.141 seconds)
> 0: jdbc:phoenix:> create index I5 on T5 (d1);
> 1 row affected (6.065 seconds)
> 0: jdbc:phoenix:> select * from t5;
> +----+------+------------+
> | I1 | S1 | D1 |
> +----+------+------------+
> | 1 | test | 1900-01-01 |
> +----+------+------------+
> 1 row selected (0.268 seconds)
> 0: jdbc:phoenix:> upsert into T5 values (2, 'test2', '1900-03-03');
> 1 row affected (0.088 seconds)
> 0: jdbc:phoenix:> select * from t5;
> +----+-------+------------+
> | I1 | S1 | D1 |
> +----+-------+------------+
> | 1 | test | 1900-01-01 |
> | 2 | test2 | 1900-01-01 |
> +----+-------+------------+
> 2 rows selected (0.278 seconds)
> {noformat}
> This also may lead to an exception during the index creation:
> {noformat}
> 0: jdbc:phoenix:> CREATE TABLE T6 (C1 CHAR(10) NOT NULL default ' ' , I1 CHAR(14) DEFAULT ' ',CONSTRAINT PK PRIMARY KEY(C1));
> No rows affected (1.163 seconds)
> 0: jdbc:phoenix:> create index i6 on t6 (I1, C1);
> java.lang.ArrayIndexOutOfBoundsException: 127
> at org.apache.phoenix.index.IndexMaintainer.initCachedState(IndexMaintainer.java:1763)
> at org.apache.phoenix.index.IndexMaintainer.<init>(IndexMaintainer.java:629)
> at org.apache.phoenix.index.IndexMaintainer.create(IndexMaintainer.java:146)
> at org.apache.phoenix.schema.PTableImpl.getIndexMaintainer(PTableImpl.java:1660)
> at org.apache.phoenix.compile.ServerBuildIndexCompiler.compile(ServerBuildIndexCompiler.java:103)
> at org.apache.phoenix.schema.MetaDataClient.getMutationPlanForBuildingIndex(MetaDataClient.java:1391)
> at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1400)
> at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1811)
> at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:547)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:513)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:512)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:500)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2162)
> at sqlline.Commands.executeSingleQuery(Commands.java:1054)
> at sqlline.Commands.execute(Commands.java:1003)
> at sqlline.Commands.sql(Commands.java:967)
> at sqlline.SqlLine.dispatch(SqlLine.java:734)
> at sqlline.SqlLine.begin(SqlLine.java:541)
> at sqlline.SqlLine.start(SqlLine.java:267)
> at sqlline.SqlLine.main(SqlLine.java:206)
> 0: jdbc:phoenix:>
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)