Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.7
Description
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 |
Attachments
Issue Links
- is blocked by
-
MDEV-25654 Unexpected ER_CRASHED_ON_USAGE and Assertion `limit >= trx_id' failed in purge_node_t::skip
- In Review
- relates to
-
MDEV-34033 Exchange partition with virtual columns fails
- In Progress