[CALCITE-3213] Support complex type expressions for SqlDataTypeSpec

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.21.0
• Component/s: core
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 26/Jul/19 01:51
• Updated: 10/Sep/19 21:36
• Resolved: 21/Aug/19 03:29

Description

We should support nested struct type like:

ROW(
foo NUMBER(5, 2) NOT NULL,
rec ROW(b BOOLEAN, i MyUDT NOT NULL))

Sub-Tasks

• Support ARRAY type for SqlDataTypeSpec: Closed
• Add syntax for type in site reference page: Closed
• Support Row type for SqlDataTypeSpec: Closed
• Support Time Zone suffix of DateTime types for SqlDataTypeSpec: Closed
• Support nested collection type for SqlDataTypeSpec: Closed
• Remove method SqlDataTypeSpec#deriveType(RelDataTypefactory): Closed