mariadb/mysql-test/include/keyword_non_reserved.inc
Alexander Barkov 556a40dce0 MDEV-35229 NOCOPY has become reserved word bringing wide incompatibility
This patch was suggested by Sergei Golubchik.

It reverts the second patch from the PR:

  commit fa5eeb4931
    Fixed ALTER TABLE NOCOPY keyword failure

and adds NOCOPY_SYM into keyword_func_sp_var_and_label.

The price is one extra shift/recuce conflict in yy_oracle.yy.
This should to tolerable.
2024-10-30 13:58:20 +04:00

16 lines
448 B
SQL

eval CREATE TABLE $keyword (a INT);
eval DROP TABLE $keyword;
eval CREATE TABLE t1 ($keyword int);
eval SELECT $keyword AS $keyword FROM t1 AS $keyword;
eval DROP TABLE t1;
eval CREATE TABLE $keyword ($keyword INT);
eval CREATE TRIGGER $keyword AFTER INSERT ON $keyword FOR EACH ROW BEGIN END;
eval DROP TRIGGER $keyword;
eval DROP TABLE $keyword;
eval PREPARE $keyword FROM 'select 1';
eval EXECUTE $keyword;
eval DEALLOCATE PREPARE $keyword;