junfei liang created PHOENIX-5865:
-------------------------------------
Summary: 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
# 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)
