Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
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
- is part of
-
MDEV-13342 Testing for MDEV-11371 (Big column compressed)
- Closed