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

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: