Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      CREATE TABLE regions (region_name VARCHAR PRIMARY KEY,zip VARCHAR ARRAY[10]) IMMUTABLE_ROWS=true;
      UPSERT INTO regions(region_name,zip) VALUES('SF Bay Area',ARRAY['94115','94030','94125']);
      

      Selecting any element of zip array doesn't work for immutable encoded table (works fine with mutable encoding)

      SELECT zip[2] FROM regions;
      +---------------------+
      | ARRAY_ELEM(ZIP, 2)  |
      +---------------------+
      |                     |
      +---------------------+
      

        Attachments

        1. PHOENIX-3624_v2.patch
          10 kB
          Samarth Jain
        2. PHOENIX-3624.patch
          8 kB
          Samarth Jain

          Activity

            People

            • Assignee:
              samarthjain Samarth Jain
              Reporter:
              mujtabachohan Mujtaba Chohan
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: