[FLINK-22951] First parameter of ROW() function must be constant

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.13.1
• Component/s: Table SQL / Client
• Assignee: Unassigned
• Reporter: Fu Kai
• Created: 10/Jun/21 02:08
• Updated: 10/Jun/21 02:19
• Resolved: 10/Jun/21 02:18

Description

We found the first parameter passed of ROW() function must be constant, it cannot be a variable or a function and reports error otherwise. The example is as below.

Flink SQL> select ROW(now(), 0));
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.sql.parser.impl.ParseException: Encountered "(" at line 1, column 15.
Was expecting one of:
    ")" ...
    "," ...

If we change the query to be following, it works fine.

select ROW(0, now())

Issue Links

• is duplicated by: FLINK-18027 ROW value constructor cannot deal with complex expressions