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

ROW TYPE OF t1 and t1%ROWTYPE for routine parameters

Details

    Description

      Under terms of this task we'll implement anchored ROW data types for routine parameters, using the same syntax that was previously implemented for routine local variables:

      SET sql_mode=DEFAULT;
      		 
      CREATE TABLE t1 (a INT, b TEXT);
      		 
      DELIMITER $$
      		 
      CREATE PROCEDURE p1 (a ROW TYPE OF t1)
      		 
      BEGIN
      		 
        SET a.a=10;
      		 
        SET a.b='text';
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;


      SET sql_mode=ORACLE;
      		 
      CREATE TABLE t1 (a INT, b TEXT);
      		 
      DELIMITER $$
      		 
      CREATE PROCEDURE p1 (a t1%ROWTYPE) AS
      		 
      BEGIN
      		 
        a.a:=10;
      		 
        a.b:='text';
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;

      Attachments

        Issue Links

          relates to

          Technical task - A technical task. MDEV-12133 sql_mode=ORACLE: table%ROWTYPE in variable declarations

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-12461 TYPE OF and ROW TYPE OF anchored data types for stored routine variables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Description Under terms of this task we'll implement anchored ROW data types for routine parameters, using the same syntax that was previously implemented for routine local variables:

            {code:sql}
            SET sql_mode=DEFAULT;
            CREATE TABLE t1 (a INT, b TEXT);
            DELIMITER $$
            CREATE PROCEDURE p1 (a ROW TYPE OF t1)
            BEGIN
              a.a:=10;
              a.b:='text';
            END;
            $$
            DELIMITER ;
            {code}


            {code:sql}
            SET sql_mode=ORACLE;
            CREATE TABLE t1 (a INT, b TEXT);
            DELIMITER $$
            CREATE PROCEDURE p1 (a t1%ROWTYPE) AS
            BEGIN
              a.a:=10;
              a.b:='text';
            END;
            $$
            DELIMITER ;
            {code}             		Under terms of this task we'll implement anchored ROW data types for routine parameters, using the same syntax that was previously implemented for routine local variables:

            {code:sql}
            SET sql_mode=DEFAULT;
            CREATE TABLE t1 (a INT, b TEXT);
            DELIMITER $$
            CREATE PROCEDURE p1 (a ROW TYPE OF t1)
            BEGIN
              SET a.a=10;
              SET a.b='text';
            END;
            $$
            DELIMITER ;
            {code}


            {code:sql}
            SET sql_mode=ORACLE;
            CREATE TABLE t1 (a INT, b TEXT);
            DELIMITER $$
            CREATE PROCEDURE p1 (a t1%ROWTYPE) AS
            BEGIN
              a.a:=10;
              a.b:='text';
            END;
            $$
            DELIMITER ;
            {code}
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2017-08-18 14:44:27.0 2017-08-18 14:44:27.86
            bar Alexander Barkov made changes -
            Fix Version/s 10.3.1 [ 22532 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            TBoyd Thomas Boyd (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 82167 ] MariaDB v4 [ 133331 ]

            People

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