You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Fu Kai (Jira)" <ji...@apache.org> on 2021/06/10 02:09:00 UTC

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

Fu Kai created FLINK-22951:
------------------------------

             Summary: First parameter of ROW() function must be constant
                 Key: FLINK-22951
                 URL: https://issues.apache.org/jira/browse/FLINK-22951
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Client
    Affects Versions: 1.13.1
            Reporter: Fu Kai
             Fix For: 1.14.0


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.
{code:java}
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:
    ")" ...
    "," ...
{code}
If we change the query to be following, it works fine.
{code:java}
select ROW(0, now()){code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)