Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
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) | +---------------------+ | | +---------------------+