Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-12252

ROW data type for stored function return values

Details

    Description

      The task MDEV-10914 implements the ROW data type for stored routine local variables and parameters.

      This task will additionally allow to use ROW in stored function return data type.

      DROP FUNCTION IF EXISTS f1;
      		 
      DELIMITER $$
      		 
      CREATE FUNCTION f1(a INT, b VARCHAR(32)) RETURNS ROW(a INT, b VARCHAR(32))
      		 
      BEGIN
      		 
        RETURN ROW(a,b);
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;
      		 
      SELECT f1(1,'b1') = ROW(1,'b1');

      Anchored row data types should also be supported:

      DROP FUNCTION IF EXISTS f1;
      		 
      DELIMITER $$
      		 
      CREATE FUNCTION f1(a INT, b VARCHAR(32)) RETURNS ROW TYPE OF t1
      		 
      BEGIN
      		 
        RETURN ROW(a,b);
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;
      		 
      SELECT f1(1,'b1') = ROW(1,'b1');

      Attachments

        Issue Links

          blocks

          Technical task - A technical task. MDEV-12308 Accessing ROW type function fields

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-32380 Array data type for stored routnes

          • Major - Major loss of function.
          • Stalled
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35003 Server crashes when reading routines table after creating a function with "returns type of"

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36322 Comparison ROW(stored_func(),1)=ROW(1,1) calls the function twice per row

          • Major - Major loss of function.
          • Closed
          is blocked by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-4912 Data type plugin API version 1

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Technical task - A technical task. MDEV-10914 ROW data type for stored routine variables

          • Major - Major loss of function.
          • Closed
          relates to

          Technical task - A technical task. MDEV-11210 TYPE OF and %TYPE in stored function RETURN data type

          • Major - Major loss of function.
          • Open

          Technical task - A technical task. MDEV-12307 ROW data type for built-in function return values

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          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

          Task - A task that needs to be done. MDEV-23353 Qualified data types in SP

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31250 ROW variables do not get assigned from subselects

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-32380 Array data type for stored routnes

          • Major - Major loss of function.
          • Stalled

          Activity

            Transition Time In Source Status Execution Times
            Alexander Barkov made transition -
            Open Needs Feedback
            		2411d 6h 36m 1
            Alexander Barkov made transition -
            Needs Feedback Closed
            		4s 1
            Alexander Barkov made transition -
            Closed Stalled
            		5s 1
            Alexander Barkov made transition -
            Stalled In Progress
            		2s 1
            Alexander Barkov made transition -
            In Progress In Review
            		44d 19h 33m 1
            Alexander Barkov made transition -
            Stalled In Review
            		12d 14h 34m 1
            Sergei Golubchik made transition -
            In Review Stalled
            		264d 22h 25m 2
            Alexander Barkov made transition -
            Stalled In Testing
            		2d 19h 9m 1
            Ramesh Sivaraman made transition -
            In Testing Stalled
            		35d 16h 48m 1
            Alexander Barkov made transition -
            Stalled Closed
            		6d 6h 38m 1

            People

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