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

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

                Dates

                Created:
                Updated:
                Resolved: