[
https://issues.apache.org/jira/browse/PHOENIX-4728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16487715#comment-16487715
]
ASF GitHub Bot commented on PHOENIX-4728:
-----------------------------------------
GitHub user xjodoin opened a pull request:
https://github.com/apache/phoenix/pull/301
PHOENIX-4728 The upsert select must project tuples
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/xjodoin/phoenix PHOENIX-4728
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/301.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #301
----
commit 0411931b6e25aec2d5825fd6d5b538a145558b6a
Author: Xavier Jodoin <xavier@...>
Date: 2018-05-23T17:29:43Z
PHOENIX-4728 The upsert select must project tuples
----
> 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
> Priority: Major
>
> 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)
