diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/alter_partitioned.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/alter_partitioned.test | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/alter_partitioned.test b/mysql-test/suite/innodb/t/alter_partitioned.test index e443f92bc8c..4990c265b5e 100644 --- a/mysql-test/suite/innodb/t/alter_partitioned.test +++ b/mysql-test/suite/innodb/t/alter_partitioned.test @@ -1,6 +1,40 @@ --source include/have_innodb.inc --source include/have_partition.inc +--echo # +--echo # MDEV-26077 Assertion failure err != DB_DUPLICATE_KEY +--echo # or unexpected ER_TABLE_EXISTS_ERROR +--echo # + +CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB; +CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=InnoDB; + +--connect (con1,localhost,root,,test) + +START TRANSACTION; +INSERT INTO t2 (pk) VALUES (1); +SAVEPOINT sp; +INSERT INTO t1 (pk) VALUES (1); +ROLLBACK TO SAVEPOINT sp; + +--connection default +SET lock_wait_timeout=0; +SET innodb_lock_wait_timeout=0; +--error ER_LOCK_WAIT_TIMEOUT +ALTER TABLE t1 PARTITION BY HASH(pk); + +SHOW CREATE TABLE t1; +--connection con1 +COMMIT; +--connection default +ALTER TABLE t2 PARTITION BY HASH(pk); +# Cleanup +--disconnect con1 +--connection default +DROP TABLE t1, t2; + +--echo # End of 10.2 tests + CREATE TABLE t1(a INT, b VARCHAR(10), INDEX(a))ENGINE=InnoDB PARTITION BY RANGE(a) (PARTITION pa VALUES LESS THAN (3), @@ -14,6 +48,8 @@ PARTITION pb VALUES LESS THAN (4)); DROP TABLE t1; +--echo # End of 10.3 tests + --echo # --echo # MDEV-24754 Server crash in --echo # ha_partition_inplace_ctx::~ha_partition_inplace_ctx @@ -22,3 +58,5 @@ CREATE TABLE t1 (id INT PRIMARY KEY, a INT, va INT AS (a) VIRTUAL) ENGINE=InnoDB PARTITION BY HASH(id) PARTITIONS 2; ALTER TABLE t1 ADD b INT, ALGORITHM=INSTANT; DROP TABLE t1; + +--echo # End of 10.5 tests |