[
https://issues.apache.org/jira/browse/PHOENIX-63?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13929976#comment-13929976
]
James Taylor commented on PHOENIX-63:
-------------------------------------
Mutable indexes are "normal" indexes - that's the kind of index that gets
created by default. We're in the final testing stages for 3.0, so if you could
confirm that this bug is fixed in the latests on the 3.0 branch, that would be
helpful.
> 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.2#6252)
