[jira] [Updated] (PHOENIX-63) Can't add null value to a secondary indexed table

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-63?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-63:
--------------------------------

    Fix Version/s:     (was: 4.0.0)
                       (was: 3.0.0)
                   4.1
                   3.1

> Can't add null value to a secondary indexed table
> -------------------------------------------------
>
>                 Key: PHOENIX-63
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-63
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 2.2.3, 3.0.0, 4.0.0, 5.0.0
>            Reporter: job thomas
>            Assignee: Samarth Jain
>             Fix For: 5.0.0, 3.1, 4.1
>
>         Attachments: 3.patch, 3_v2.patch, PHOENIX63_v1.patch
>
>
> I have  created a Phoenix table like this 
> CREATE TABLE DEMO(R VARCHAR PRIMARY KEY,A DOUBLE,C VARCHAR);
> Then created index 
> CREATE INDEX DEMO_idx ON DEMO (A) INCLUDE(C);
> upsert into DEMO  values('cc1',null,'abc');
> select * from DEMO;
> No Data Found !!
>  
> Problem is when adding null value to the second column(A) 
>  
> If a created  index without include key
> CREATE INDEX DEMO_idx ON DEMO (A) ;
>                       (OR)
> CREATE INDEX DEMO_idx ON DEMO (A,C);
>  
> The same will work properly.
>  
> What will be the reason with include and null value insert?



--
This message was sent by Atlassian JIRA
(v6.2#6252)