Debian Codegraph @

mysql-test/suite/innodb/t/alter_partitioned.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3
4 --echo #
5 --echo # MDEV-26077 Assertion failure err != DB_DUPLICATE_KEY
6 --echo # or unexpected ER_TABLE_EXISTS_ERROR
7 --echo #
8
9 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
10 CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=InnoDB;
11
12 --connect (con1,localhost,root,,test)
13
14 START TRANSACTION;
15 INSERT INTO t2 (pk) VALUES (1);
16 SAVEPOINT sp;
17 INSERT INTO t1 (pk) VALUES (1);
18 ROLLBACK TO SAVEPOINT sp;
19
20 --connection default
21 SET @save_timeout=@@lock_wait_timeout;
22 SET @save_innodb_timeout=@@innodb_lock_wait_timeout;
23 SET lock_wait_timeout=0;
24 SET innodb_lock_wait_timeout=0;
25 --error ER_LOCK_WAIT_TIMEOUT
26 ALTER TABLE t1 PARTITION BY HASH(pk);
27 SET lock_wait_timeout=@save_timeout;
28 SET innodb_lock_wait_timeout=@save_innodb_timeout;
29
30 SHOW CREATE TABLE t1;
31 --connection con1
32 COMMIT;
33 --connection default
34 SET lock_wait_timeout=@save_timeout;
35 SET innodb_lock_wait_timeout=@save_innodb_timeout;
36 ALTER TABLE t2 PARTITION BY HASH(pk);
37 # Cleanup
38 --disconnect con1
39 --connection default
40 DROP TABLE t1, t2;
41
42 --echo # End of 10.2 tests
43
44 CREATE TABLE t1(a INT, b VARCHAR(10), INDEX(a))ENGINE=InnoDB
45 PARTITION BY RANGE(a)
46 (PARTITION pa VALUES LESS THAN (3),
47 PARTITION pb VALUES LESS THAN (5));
48
49 --error ER_FEATURE_NOT_SUPPORTED_WITH_PARTITIONING
50 CREATE TABLE t2(a INT, FOREIGN KEY(a) REFERENCES t1(a))ENGINE=INNODB
51 PARTITION BY RANGE(a)
52 (PARTITION pa VALUES LESS THAN (2),
53 PARTITION pb VALUES LESS THAN (4));
54
55 DROP TABLE t1;
56
57 --echo # End of 10.3 tests
58
59 --echo #
60 --echo # MDEV-24754 Server crash in
61 --echo # ha_partition_inplace_ctx::~ha_partition_inplace_ctx
62 --echo #
63 CREATE TABLE t1 (id INT PRIMARY KEY, a INT, va INT AS (a) VIRTUAL)
64 ENGINE=InnoDB PARTITION BY HASH(id) PARTITIONS 2;
65 ALTER TABLE t1 ADD b INT, ALGORITHM=INSTANT;
66 DROP TABLE t1;
67
68 --echo # End of 10.5 tests