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

              lstartseva Lena Startseva
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.