Hi Job, Thanks for reporting this and thanks for all the detail. Please file a JIRA. If you could put together a unit test, that would be helpful. Thanks! James
On Thursday, February 20, 2014, Job Thomas <[email protected]> wrote: > > Hi All > 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? > > > Thanks in advance, > Jom M Thomas > Thanks & Regards, > Job M Thomas| Platform & Technology >
