Filing as minor, because given MDEV-25654 other problems, it's probably for the better that at least EXCHANGE PARTITION refuses to work on tables with unique blobs; but still, I suppose it should be filed for the brighter future when unique blobs become viable.
--source include/have_partition.inc
|
|
CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
|
CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
|
ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
|
|
# Cleanup
|
DROP TABLE t, tp;
|
|
10.5 bf7cfa2535618bfe9962c725555680e799fdcd18
|
CREATE TABLE t (a INT, b TEXT, UNIQUE (b)) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,2), PARTITION pdef DEFAULT);
|
CREATE TABLE tp (a INT, b TEXT, UNIQUE (b));
|
ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp;
|
bug.t [ fail ]
|
Test ended at 2024-12-10 13:34:50
|
|
CURRENT_TEST: bug.t
|
mysqltest: At line 5: query 'ALTER TABLE t EXCHANGE PARTITION p0 WITH TABLE tp' failed: 1736: Tables have different definitions
|
Bug
Major
