[CALCITE-1379] When expanding STAR, expand sub-fields in RecordType columns of StructKind.PEEK_FIELDS and StructKind.PEEK_FIELDS_DEFAULT

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Labels: phoenix
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 21/Sep/16 18:43
• Updated: 27/Feb/24 22:23
• Resolved: 26/Sep/16 21:12

Description

This is part of CALCITE-1208 and is a Phoenix-specific requirement.
For example, if table T's type is defined as

VARCHAR K0,
VARCHAR C1,
RecordType(INTEGER C0, INTEGER C1) F0,
RecordType(INTEGER C0, INTEGER C2) F1

, where both F0 and F1 is of StructKind.PEEK_FIELDS or StructKind.PEEK_FIELDS_DEFAULT,
"select * from T" should expand the sub-fields of F0 and F1 and has a return type of

VARCHAR K0,
VARCHAR C1,
INTEGER F0.C0,
INTEGER F0.C1,
INTEGER F1.C0,
INTEGER F1.C2

Issue Links

• is related to: CALCITE-1208 Improve two-level column structure handling