[jira] [Created] (PHOENIX-5865) column that has default value can not be correctly indexed

["junfei liang (Jira)" <ji...@apache.org>]

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)