[
https://issues.apache.org/jira/browse/PHOENIX-4728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491325#comment-16491325
]
Hudson commented on PHOENIX-4728:
---------------------------------
ABORTED: Integrated in Jenkins build PreCommit-PHOENIX-Build #1887 (See
[https://builds.apache.org/job/PreCommit-PHOENIX-Build/1887/])
PHOENIX-4728 ARRAY_APPEND and ARRAY_REMOVE should work with null column
(jtaylor: rev 9335972fb1d231f9ff1cce8b55ca5753149cba2c)
* (edit)
phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* (edit)
phoenix-core/src/it/java/org/apache/phoenix/end2end/ArrayAppendFunctionIT.java
> ARRAY_APPEND and ARRAY_REMOVE should work with null column value
> ----------------------------------------------------------------
>
> Key: PHOENIX-4728
> URL: https://issues.apache.org/jira/browse/PHOENIX-4728
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.14.0
> Reporter: Xavier Jodoin
> Assignee: Xavier Jodoin
> Priority: Major
> Fix For: 5.0.0, 4.15.0
>
>
> ARRAY_APPEND and ARRAY_REMOVE should create the array value when it's null
> Test case:
> create table test_array (
> ID VARCHAR NOT NULL,
> MYARRAY VARCHAR ARRAY
> CONSTRAINT testpk PRIMARY KEY (ID)
> );
> upsert into test_array (id) values ('test');
> upsert into test_array select id,array_append(myarray,'testValue') from
> test_array;
> select ID,ARRAY_TO_STRING(MYARRAY, ',') from test_array;
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
