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

sql_mode=ORACLE: Ignore the NOCOPY keyword in stored routine parameters

Details

    Description

      Let's extend the parser for sql_mode=ORACLE to ignore the NOCOPY keyword in the FUNCTION and PROCEDURE definition grammar:

      argument:= name [ IN | OUT | IN OUT ] [ NOCOPY ] datatype
      		 
       
      		 
      func:= CREATE [OR REPLACE] FUNCTION  [schema.] function  [( argument [, argument]...)]
      		 
       
      		 
      proc:= CREATE [OR REPLACE] PROCEDURE [schema.] procedure [( argument [, argument]...)]

      Note, this task is only to understand and ignore the NOCOPY keyword. The optimization (pass-by-reference instead of pass-by-value) helping to avoid value copying will be done in a separate task when needed.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34323 Oracle compatibility project 3

          • Major - Major loss of function.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35229 NOCOPY has become reserved word bringing wide incompatibility

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10862 Stored procedures: default values for parameters (optional parameters)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28248 Wrong note "function .. has the same name..." on a general keyword

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open Closed
            		137d 3h 52m 1
            Sergei Golubchik made transition -
            Closed Stalled
            		9h 28m 1
            Sergei Golubchik made transition -
            Stalled Open
            		7s 1
            Sergei Golubchik made transition -
            Open In Progress
            		2s 1
            Sergei Golubchik made transition -
            In Progress In Testing
            		3s 1
            Elena Stepanova made transition -
            In Testing Stalled
            		14d 2h 46m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		14h 21m 1

            People

              serg Sergei Golubchik
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.