[PHOENIX-3624] Empty array element returned with immutable encoding scheme

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Samarth Jain
• Reporter: Mujtaba Chohan
• Created: 24/Jan/17 20:35
• Updated: 27/Feb/17 23:18
• Resolved: 27/Feb/17 23:18

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)  |
+---------------------+
|                     |
+---------------------+