Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
11.7
-
None
Description
MDEV-34316 has made NOCOPY a reserved word causing syntax errors both in ORACLE mode and in the traditional one in a variety of situations where it was previously allowed, including, but not limited to,
create table nocopy (a int); |
create table t (nocopy int); |
create trigger nocopy after insert on t for each row begin end; |
prepare nocopy from "select 1"; |
execute nocopy; |
create function nocopy() returns int return 0; |
create procedure pr (nocopy int) select nocopy; |
etc.
According to bar, it shouldn't be necessary, and it should be still allowed wherever possible.
Also, looking at this change:
%token <kwd> GOTO_MARIADB_SYM // Oracle-R
|
%token <kwd> NOCOPY_SYM
|
%token <kwd> OTHERS_MARIADB_SYM // SQL-2011-N, PLSQL-R
|
it is missing a comment.
Attachments
Issue Links
- is caused by
-
MDEV-34316 sql_mode=ORACLE: Ignore the NOCOPY keyword in stored routine parameters
- Closed