[CALCITE-2906] Record DOT extension does not distinguish between simple and compound identifiers

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Rong Rong
• Created: 10/Mar/19 23:40
• Updated: 19/Sep/19 19:18

Description

Currently the DOT extensions only supports Simple Identifiers:

For example:

• tbl.foo(0).col.bar is parsed as: ((`TBL`.`FOO`(0).`COL`).`BAR`)

However, this is not the case in regular Expression field, for example:

• tbl.col.bar is parsed as: `TBL`.`COL`.`BAR`

Parser should support both compound identifier, and simple identifier chain after a record type SqlNode.

Similarly, parsing should also be consistent for other types of expression, for example

• tbl.arr[0].foo.bar is currently parsed as: ((`TBL`.`ARR`[0].`FOO`).`BAR`)

Issue Links

• relates to: CALCITE-2542 SqlNode AtomicRowExpression + DOT operation does not work for constructed ROWs