Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-4728

ARRAY_APPEND and ARRAY_REMOVE should work with null column value

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.14.0
    • Fix Version/s: 5.0.0, 4.15.0
    • Labels:
      None

      Description

      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;

       

       

        Attachments

          Activity

            People

            • Assignee:
              xjodoin Xavier Jodoin
              Reporter:
              xjodoin Xavier Jodoin
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10m
                10m