|
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;
|
|