[jira] [Created] (FLINK-16599) Throw Unknown identifier when having nested computed column

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-16599) Throw Unknown identifier when having nested computed column

Shang Yuanchun (Jira)
YufeiLiu created FLINK-16599:
--------------------------------

             Summary: Throw Unknown identifier when having nested computed column
                 Key: FLINK-16599
                 URL: https://issues.apache.org/jira/browse/FLINK-16599
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.10.0
            Reporter: YufeiLiu


{code:sql}
CREATE TABLE source {
  origin STRING,
  col1 AS FUN_1(origin),
  col2 AS FUN_2(col1),
  col3 AS FUN_3(col1)
}
{code}

Throws {{Unknown identifier 'col1' }}.

I konw maybe is not a bug, because of computed column implementation logic. But I think it's a little bit inconvenient case I have to write like this.
{code:sql}
CREATE TABLE source {
  origin STRING,
  col2 AS FUN_2(FUN_1(origin)),
  col3 AS FUN_3(FUN_1(origin))
}
{code}



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