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

EXCHANGE PARTITION does not work with compressed columns

    XMLWordPrintable

    Details

      Description

      bb-10.3-MDEV-11371 commit 5626786b055a5990a8913e92e41550f5fea974ec
      exchange partition returns ERROR 1736 (HY000): Tables have different definitions
      if a column is just varchar(), then query is executed without errors.

      CREATE TABLE t1 (i int, a VARCHAR(1000) COMPRESSED)
      	PARTITION BY RANGE COLUMNS (a)(
          PARTITION p0 VALUES LESS THAN ('g'),
          PARTITION p1 VALUES LESS THAN ('m'),
          PARTITION p2 VALUES LESS THAN ('t'),
          PARTITION p3 VALUES LESS THAN ('w'));
       
       CREATE TABLE t2 like t1;
       ALTER TABLE t2  REMOVE PARTITIONING;
       ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: