[CALCITE-4456] Allow all value expressions in ROW

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.26.0
• Fix Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 05/Jan/21 12:05
• Updated: 31/Aug/22 12:53
• Resolved: 07/Jan/21 02:03

Description

In SQL standard 2011 part 7 value expression, it defines the SQL syntax for explicit ROW value constructor to allows all the valid value expreesion:

<row value constructor> ::=
    <common value expression>
  | <boolean value expression>
  | <explicit row value constructor>

<common value expression> ::=
    <numeric value expression>
  | <string value expression>
  | <datetime value expression>
  | <interval value expression>
  | <user-defined type value expression>
  | <reference value expression>
  | <collection value expression>


<explicit row value constructor> ::=
    <left paren> <row value constructor element> <comma>
        <row value constructor element list> <right paren>
  | ROW <left paren> <row value constructor element list> <right paren>
  | <row subquery>

<row value constructor element> ::=
  <value expression>    

I also tried the PostgreSQL 9.6 for the query:

create table t1(
  f0 int,
  f1 varchar(20)
);

insert into t1 values(1, 'abc');

-- select row(t1.f0 + 1, t1.f1) from t1; -- outputs (2, abc)

Issue Links

• fixes: FLINK-22274 SQL parser fails to parse group by statements with brackets in views
• is duplicated by: CALCITE-5242 SQL query of row function call with nested map cannot be parsed
• links to: GitHub Pull Request #2315