Debian Codegraph @

mysql-test/suite/innodb/r/alter_partitioned.result

raw
1 #
2 # MDEV-26077 Assertion failure err != DB_DUPLICATE_KEY
3 # or unexpected ER_TABLE_EXISTS_ERROR
4 #
5 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
6 CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=InnoDB;
7 connect con1,localhost,root,,test;
8 START TRANSACTION;
9 INSERT INTO t2 (pk) VALUES (1);
10 SAVEPOINT sp;
11 INSERT INTO t1 (pk) VALUES (1);
12 ROLLBACK TO SAVEPOINT sp;
13 connection default;
14 SET @save_timeout=@@lock_wait_timeout;
15 SET @save_innodb_timeout=@@innodb_lock_wait_timeout;
16 SET lock_wait_timeout=0;
17 SET innodb_lock_wait_timeout=0;
18 ALTER TABLE t1 PARTITION BY HASH(pk);
19 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
20 SET lock_wait_timeout=@save_timeout;
21 SET innodb_lock_wait_timeout=@save_innodb_timeout;
22 SHOW CREATE TABLE t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `pk` int(11) NOT NULL,
26 PRIMARY KEY (`pk`)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
28 connection con1;
29 COMMIT;
30 connection default;
31 SET lock_wait_timeout=@save_timeout;
32 SET innodb_lock_wait_timeout=@save_innodb_timeout;
33 ALTER TABLE t2 PARTITION BY HASH(pk);
34 disconnect con1;
35 connection default;
36 DROP TABLE t1, t2;
37 # End of 10.2 tests
38 CREATE TABLE t1(a INT, b VARCHAR(10), INDEX(a))ENGINE=InnoDB
39 PARTITION BY RANGE(a)
40 (PARTITION pa VALUES LESS THAN (3),
41 PARTITION pb VALUES LESS THAN (5));
42 CREATE TABLE t2(a INT, FOREIGN KEY(a) REFERENCES t1(a))ENGINE=INNODB
43 PARTITION BY RANGE(a)
44 (PARTITION pa VALUES LESS THAN (2),
45 PARTITION pb VALUES LESS THAN (4));
46 ERROR HY000: Partitioned tables do not support FOREIGN KEY
47 DROP TABLE t1;
48 # End of 10.3 tests
49 #
50 # MDEV-24754 Server crash in
51 # ha_partition_inplace_ctx::~ha_partition_inplace_ctx
52 #
53 CREATE TABLE t1 (id INT PRIMARY KEY, a INT, va INT AS (a) VIRTUAL)
54 ENGINE=InnoDB PARTITION BY HASH(id) PARTITIONS 2;
55 ALTER TABLE t1 ADD b INT, ALGORITHM=INSTANT;
56 DROP TABLE t1;
57 # End of 10.5 tests