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
