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

          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.