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

EXCHANGE PARTITION does not work for tables with unique blobs

Details

    Description

      Filing as minor, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.

      --source include/have_partition.inc
      		 
       
      		 
      CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
      		 
      CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
      		 
      ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t, tp;

      10.5 bf7cfa2535618bfe9962c725555680e799fdcd18

      		 
      CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
      		 
      CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
      		 
      ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
      		 
      bug.t                                    [ fail ]
      		 
              Test ended at 2024-12-10 13:34:50
      		 
       
      		 
      CURRENT_TEST: bug.t
      		 
      mysqltest: At line 5: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25654 Unexpected ER_CRASHED_ON_USAGE and Assertion `limit >= trx_id' failed in purge_node_t::skip

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34033 Exchange partition with virtual columns fails

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ]
            elenst Elena Stepanova made changes -
            Description Filing as minor and leaving unassigned, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.

            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc

            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;

            # Cleanup
            DROP TABLE t, tp;
            {code}

            {code:sql|title=10.5 2ab10fbec2dc086f3486c356064fed4d4c74ca7d}
            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
            bug.r6 [ fail ]
                    Test ended at 2024-12-10 01:40:27

            CURRENT_TEST: bug.r6
            mysqltest: At line 6: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions
            {code}             		Filing as minor, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.

            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc

            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;

            # Cleanup
            DROP TABLE t, tp;
            {code}

            {code:sql|title=10.5 2ab10fbec2dc086f3486c356064fed4d4c74ca7d}
            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
            bug.r6 [ fail ]
                    Test ended at 2024-12-10 01:40:27

            CURRENT_TEST: bug.r6
            mysqltest: At line 6: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions
            {code}
            elenst Elena Stepanova made changes -
            Description Filing as minor, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.

            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc

            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;

            # Cleanup
            DROP TABLE t, tp;
            {code}

            {code:sql|title=10.5 2ab10fbec2dc086f3486c356064fed4d4c74ca7d}
            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b)) ENGINE = InnoDB;
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
            bug.r6 [ fail ]
                    Test ended at 2024-12-10 01:40:27

            CURRENT_TEST: bug.r6
            mysqltest: At line 6: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions
            {code}             		Filing as minor, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.

            {code:sql}
            --source include/have_partition.inc

            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;

            # Cleanup
            DROP TABLE t, tp;
            {code}

            {code:sql|title=10.5 bf7cfa2535618bfe9962c725555680e799fdcd18}
            CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
            CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
            ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
            bug.t [ fail ]
                    Test ended at 2024-12-10 13:34:50

            CURRENT_TEST: bug.t
            mysqltest: At line 5: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions
            {code}
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenkov [ midenok ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Labels hash-index
            midenok Aleksey Midenkov made changes -
            Component/s Virtual Columns [ 10803 ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Nikita Malyavin [ nikitamalyavin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenkov [ midenok ]
            midenok Aleksey Midenkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Labels hash-index hash-index pushing
            midenok Aleksey Midenkov made changes -
            Fix Version/s 10.5.28 [ 29952 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.7 [ 29815 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.21 [ 29953 ]
            Fix Version/s 10.11.11 [ 29954 ]
            Fix Version/s 11.4.5 [ 29956 ]
            Fix Version/s 11.7.2 [ 29914 ]

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              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.