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

Partitioned table creation problem when creating from procedure context twice in same session

    XMLWordPrintable

    Details

      Description

      When DROPing and reCREATing a partitioned table using a stored procedure the 2nd attempt from the same session leads to a

      "VALUES LESS THAN value must be strictly increasing for each partition"

      error. When closing the connection, reconnecting, and then re-executing the procedure the CREATE works well again, but another call from the same session makes it fail once more

      Minimalized test case:

      DROP PROCEDURE IF EXISTS p1;
       
      DELIMITER //
       
      CREATE PROCEDURE p1()
      BEGIN
        DROP TABLE IF EXISTS t1 ;
       
        CREATE TABLE t1 (
          id INT PRIMARY KEY
        )
        PARTITION BY RANGE (id) (
          PARTITION P1 VALUES LESS THAN (2),
          PARTITION P2 VALUES LESS THAN (3)
        ); 
      END //
       
      DELIMITER ;
       
      call p1(); -- works
      call p1(); -- fails

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: