Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40812

SELECT INTO arroc_array does not work for ROWTYPE

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      SET sql_mode=ORACLE;
      		 
      CREATE OR REPLACE TABLE t1 (a INT, b VARCHAR(10));
      		 
      INSERT INTO t1 VALUES (10,'b10');
      		 
      DELIMITER $$
      		 
      CREATE OR REPLACE PROCEDURE p1() AS
      		 
        TYPE assoc0_t IS TABLE OF t1%ROWTYPE INDEX BY INT;
      		 
        a0 assoc0_t;
      		 
      BEGIN
      		 
        SELECT * INTO a0(30) FROM t1;
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;
      		 
      CALL p1();


      ERROR 1222 (21000): The used SELECT statements have a different number of columns

      The above output is not expected. It should assign a t1 row value into a0(30).

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34319 Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY in stored routines

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36767 Associative arrays: deferred features

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-39563 Implement UPDATE ... RETURNING ... INTO

          • Major - Major loss of function.
          • In Testing

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40811 Assoc array `TABLE OF cursor%ROWTYPE` does not work

          • Major - Major loss of function.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.