-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: N/A
-
Component/s: Data Definition - Alter Table, Partitioning
-
Labels:None
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;
|
- is part of
-
MDEV-13342 Testing for MDEV-11371 (Big column compressed)
-
- Closed
-