Debian Codegraph @

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

raw
1 #
2 # Bug#31365127 DROP A PARTITION RESULT IN OOM
3 #
4 set global innodb_file_per_table = off;
5 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
6 PARTITION BY HASH(a) PARTITIONS 1024;
7 DROP TABLE t1;
8 set global innodb_file_per_table = off;
9 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
10 PARTITION BY HASH(a) PARTITIONS 1024;
11 RENAME TABLE t1 TO t2;
12 DROP TABLE t2;
13 set global innodb_file_per_table = off;
14 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
15 PARTITION BY HASH(a) PARTITIONS 1024;
16 TRUNCATE TABLE t1;
17 DROP TABLE t1;
18 set global innodb_file_per_table = on;
19 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
20 PARTITION BY HASH(a) PARTITIONS 1024;
21 DROP TABLE t1;
22 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
23 PARTITION BY HASH(a) PARTITIONS 1024;
24 RENAME TABLE t1 TO t2;
25 DROP TABLE t2;
26 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
27 PARTITION BY HASH(a) PARTITIONS 1024;
28 TRUNCATE TABLE t1;
29 DROP TABLE t1;