[ https://issues.apache.org/jira/browse/PHOENIX-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal resolved PHOENIX-5865. ------------------------------------ Fix Version/s: 5.2.0 5.1.3 Resolution: Fixed > 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 > Assignee: Richárd Antal > Priority: Major > Fix For: 5.2.0, 5.1.3 > > 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.20.1#820001)