You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Richárd Antal (Jira)" <ji...@apache.org> on 2022/01/11 15:23:00 UTC

[jira] [Resolved] (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 ]

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)