Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-14139

Anchored data types for variables

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

    Description

      Previously we added anchored data type declarations for table columns, tables, cursors:

      DECLARE a TYPE OF t1.a;   -- table column
      		 
      DECLARE b ROW TYPE OF t1; -- table row
      		 
      DECLARE c ROW TYPE OF c1; -- cursor row

      Under terms of this tasks we'll add anchor references to other variables:

      DECLARE var1 INT;
      		 
      DECLARE var2 TYPE OF var1;

      The following features will be supported:

      • Nested anchor declarations (anchors to anchors)
      • Anchors to implicit ROW variables
      • Anchors to table and cursor ROW variables
      • Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
      • Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

      Example: Scalar declarations

      DECLARE var1 INT;
      		 
      DECLARE var2 TYPE OF var1;
      		 
      DECLARE var3 TYPE OF var2;

      Example: Scalar declarations for sql_mode=ORACLE

      DECLARE
      		 
        var1 INT;
      		 
        var2 var1%TYPE;
      		 
        var3 var2%TYPE;

      Example: Implicit ROW variables

      DECLARE row1 ROW (a INT, b TEXT);
      		 
      DECLARE row2 TYPE OF row1;

      Example: Implicit ROW variables for sql_mode=ORACLE

      DECLARE
      		 
        row1 ROW (a INT, b TEXT);
      		 
        row2 row1%TYPE;

      Example: Table ROW variables

      DECLARE row1 ROW TYPE OF table1;
      		 
      DECLARE row2 TYPE OF row1;

      Example: Table ROW variables for sql_mode=ORACLE

      DECLARE
      		 
        row1 ROW TYPE OF table1;
      		 
        row2 row1%TYPE;

      Example: Cursor ROW variables

      DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
      		 
      DECLARE row1 ROW TYPE OF cur1;
      		 
      DECLARE row2 TYPE OF row1;

      Example: Cursor ROW variables for sql_mode=ORACLE

      DECLARE
      		 
        CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
      		 
        row1 cur1%ROWTYPE;
      		 
        row2 row1%TYPE;

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-13418 Compatibility: The order of evaluation of SELECT..INTO assignments

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

          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

          Technical task - A technical task. MDEV-10577 sql_mode=ORACLE: %TYPE in variable declarations

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-14212 Add Field_row for SP ROW variables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Both local SP variables and SP parameters will be supported
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}

            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}

            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}

            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}

            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}

            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}

            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}


            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Table ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW TYPE OF table1;
              row2 row1%TYPE;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}


            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Table ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW TYPE OF table1;
              row2 row1%TYPE;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}


            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}


            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Table ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW TYPE OF table1;
              row2 row1%TYPE;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Cursor ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
              row1 cur1%ROWTYPE;
              row2 row1%TYPE;
            {code}
            bar Alexander Barkov made changes -
            Description Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF var2;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 var2%TYPE;
            {code}


            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Table ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW TYPE OF table1;
              row2 row1%TYPE;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Cursor ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
              row1 cur1%ROWTYPE;
              row2 row1%TYPE;
            {code}
            		Previously we added anchored data type declarations for table columns, tables, cursors:
            {code:sql}
            DECLARE a TYPE OF t1.a; -- table column
            DECLARE b ROW TYPE OF t1; -- table row
            DECLARE c ROW TYPE OF c1; -- cursor row
            {code}

            Under terms of this tasks we'll add anchor references to other variables:
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            {code}

            The following features will be supported:
            - Nested anchor declarations (anchors to anchors)
            - Anchors to implicit ROW variables
            - Anchors to table and cursor ROW variables
            - Only local SP variables will be supported (SP parameters and SP return values are out of scope of this task)
            - Both TYPE OF (for sql_mode=default) and %TYPE (for sql_mode=ORACLE) will be supported

            Example: Scalar declarations
            {code:sql}
            DECLARE var1 INT;
            DECLARE var2 TYPE OF var1;
            DECLARE var3 TYPE OF var2;
            {code}
            Example: Scalar declarations for sql_mode=ORACLE
            {code:sql}
            DECLARE
              var1 INT;
              var2 var1%TYPE;
              var3 var2%TYPE;
            {code}


            Example: Implicit ROW variables
            {code:sql}
            DECLARE row1 ROW (a INT, b TEXT);
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Implicit ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW (a INT, b TEXT);
              row2 row1%TYPE;
            {code}


            Example: Table ROW variables
            {code:sql}
            DECLARE row1 ROW TYPE OF table1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Table ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              row1 ROW TYPE OF table1;
              row2 row1%TYPE;
            {code}


            Example: Cursor ROW variables
            {code:sql}
            DECLARE CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
            DECLARE row1 ROW TYPE OF cur1;
            DECLARE row2 TYPE OF row1;
            {code}
            Example: Cursor ROW variables for sql_mode=ORACLE
            {code:sql}
            DECLARE
              CURSOR cur1 AS SELECT 10 AS a, 'b' AS b;
              row1 cur1%ROWTYPE;
              row2 row1%TYPE;
            {code}
            bar Alexander Barkov made changes -
            Parent MDEV-10764 [ 57940 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2017-10-27 16:50:54.0 2017-10-27 16:50:54.805
            bar Alexander Barkov made changes -
            Fix Version/s 10.3.3 [ 22644 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            alvinr Alvin Richards (Inactive) made changes -
            Parent MDEV-10764 [ 57940 ] MDEV-10142 [ 56873 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 83157 ] MariaDB v4 [ 153033 ]
            bar Alexander Barkov made changes -

            People

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