[
https://issues.apache.org/jira/browse/FLINK-33490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17801633#comment-17801633
]
xuyang commented on FLINK-33490:
--------------------------------
Hi, [~martijnvisser] . IIRC, the small Flip that we want to introduce is only
used to list the supported sql patterns. Specifically, we will list the SQL
syntax that we currently support and do not support one by one.
However, regarding this JIRA issue itself, we determine the need to fix it
based on two criteria:
# Whether this usage is explicitly prohibited in the SQL standard.
# Whether this usage is explicitly prohibited in commonly used RDBMSs.
If it does not meet the requirements, we deem this syntax to be problematic and
believe it requires alignment.
WDYT？
> 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
> Assignee: xuyang
> Priority: Major
> Labels: pull-request-available
>
> We 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)
