You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "junfei liang (Jira)" <ji...@apache.org> on 2020/04/22 13:17:00 UTC
[jira] [Updated] (PHOENIX-5865) column that has default value can
not be correctly indexed
[ https://issues.apache.org/jira/browse/PHOENIX-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
junfei liang updated PHOENIX-5865:
----------------------------------
Attachment: IndexWithDefaultIT.patch
> column that has default value can not be correctly indexed
> ----------------------------------------------------------
>
> Key: PHOENIX-5865
> URL: https://issues.apache.org/jira/browse/PHOENIX-5865
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.0.0
> Reporter: junfei liang
> Priority: Major
> Attachments: IndexWithDefaultIT.patch
>
>
> # create a table with a column has default value
> create table data_table(
> pk VARCHAR, +
> c VARCHAR default '0',
> CONSTRAINT my_pk PRIMARY KEY (pk)
> 2. insert data into it
> upsert into data_table values('1','1')
> 3. create an index on the column
> CREATE INDEX idx_data_table ON data_table(pk, c)
> 4. check index table ,found data is wrong
> select * from idx_data_table
> found 0:c column value is '0' , but it should be 1.
> see attachment for details.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)