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

[job thomas (JIRA)]

job thomas created PHOENIX-63:
---------------------------------

             Summary: 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
            Reporter: job thomas


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.1.5#6160)