phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "junfei liang (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5865) column that has default value can not be correctly indexed
Date Wed, 22 Apr 2020 13:17:00 GMT

     [ 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)

Mime
View raw message