[
https://issues.apache.org/jira/browse/PHOENIX-63?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13985847#comment-13985847
]
Hudson commented on PHOENIX-63:
-------------------------------
SUCCESS: Integrated in Phoenix-3.0 #76 (See
[https://builds.apache.org/job/Phoenix-3.0/76/])
PHOENIX-63 Can't add null value to a secondary indexed table (SamarthJain)
(jtaylor: rev 48f564de0daf23da7a28056f8c457be12511c5be)
* phoenix-core/src/main/java/org/apache/phoenix/index/IndexMaintainer.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/MutableIndexIT.java
> 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: 3.0.0, 4.0.0, 5.0.0
>
> 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)
