Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35229

NOCOPY has become reserved word bringing wide incompatibility

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 11.7(EOL)
    • 11.7.1
    • Parser
    • 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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34316 sql_mode=ORACLE: Ignore the NOCOPY keyword in stored routine parameters

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Alexander Barkov made transition -
            Open In Progress
            		2d 4h 1m 1
            Alexander Barkov made transition -
            In Progress In Review
            		46s 1
            Alexander Barkov made transition -
            Stalled In Review
            		15h 16m 1
            Sergei Golubchik made transition -
            In Review Stalled
            		4d 5h 41m 2
            Alexander Barkov made transition -
            Stalled In Progress
            		1d 59m 1
            Alexander Barkov made transition -
            In Progress Closed
            		9s 1

            People

              bar Alexander Barkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.