Maksim Zhuravkov created IGNITE-26929:
-----------------------------------------

             Summary: Sql. CREATE OR REPLACE is accepted by the parser but not 
rejected by the validator
                 Key: IGNITE-26929
                 URL: https://issues.apache.org/jira/browse/IGNITE-26929
             Project: Ignite
          Issue Type: Improvement
          Components: sql ai3
            Reporter: Maksim Zhuravkov


The SQL parser accepts `CREARE OR REPLACE` statements but the validator does 
not reject them since they are not supported by ignite SQL.

Example:
{noformat}
sql-cli> create or replace table my_table (id int, val int, primary key(id));
Updated 0 rows.

sql-cli> create or replace table my_table (id int, val int, primary key(id));
SQL query execution error
Table with name ‘PUBLIC.MY_TABLE’ already exists.
sql-cli>

DDL statement validation logic should be updated to reject CREATE OR REPLACE 
statements. 





--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to