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

              svoj Sergey Vojtovich
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.