Shengkai Fang created FLINK-33490:
-------------------------------------
Summary: Validate the name conflicts when creating view
Key: FLINK-33490
URL: https://issues.apache.org/jira/browse/FLINK-33490
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Affects Versions: 1.19.0
Reporter: Shengkai Fang
When should forbid
```
CREATE VIEW id_view AS
SELECT id, uid AS id FROM id_table
```
As the SQL standards states,
If <regular view specification> is specified, then:
i) If any two columns in the table specified by the <query expression> have
equivalent <column name>s, or if any column of that table has an
implementation-dependent name, then a <view column list> shall be specified.
ii) Equivalent <column name>s shall not be specified more than once in the
<view column list>.
Many databases also throw exception when view name conflicts, e.g. mysql,
postgres.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
