[jira] [Created] (PHOENIX-4728) ARRAY_APPEND and ARRAY_REMOVE should work with null column value

[Xavier Jodoin (JIRA)]

Xavier Jodoin created PHOENIX-4728:
--------------------------------------

             Summary: 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


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)