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

ROW TYPE OF t1 and t1%ROWTYPE for routine parameters

    XMLWordPrintable

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

            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.