Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2 --source include/have_innodb_max_16k.inc
3 --source include/have_debug_sync.inc
4
5 --echo # Different partitions can have different row format
6 --echo # Case one: between dynamic and redundant
7 --echo #
8
9 # Have to set the default row format to a non-default one.
10 SET GLOBAL innodb_default_row_format = REDUNDANT;
11
12 CREATE TABLE t1 (a INT NOT NULL, d INT NOT NULL, index(a, d)) ENGINE=InnoDB PARTITION BY LIST COLUMNS (a,d) (PARTITION p36_1 VALUES IN ((10,5),(10,6)), PARTITION p36_2 VALUES IN ((11,5),(11,6)));
13
14 SET SESSION debug= '+d,skip_dd_table_access_check';
15 SELECT name, se_private_data FROM mysql.table_partitions;
16
17 --source include/restart_mysqld.inc
18
19 ALTER TABLE t1 ADD PARTITION (PARTITION p_r13 VALUES IN ((741,377), (21,728)), PARTITION p_r23 VALUES IN ((102,337), (453,337), (-9,179)));
20
21 SET SESSION debug= '+d,skip_dd_table_access_check';
22 SELECT name, se_private_data FROM mysql.table_partitions;
23
24 CHECK TABLE t1;
25
26 SHOW CREATE TABLE t1;
27
28 --source include/restart_mysqld.inc
29
30 SET SESSION debug= '+d,skip_dd_table_access_check';
31 SELECT name, se_private_data FROM mysql.table_partitions;
32
33 CHECK TABLE t1;
34
35 DROP TABLE t1;
36
37 SET GLOBAL innodb_default_row_format = Default;
38
39
40 --echo #
41 --echo # Different partitions can have different row format
42 --echo # Case two: between dynamic and compressed
43 --echo #
44
45 CREATE TABLE t1 (a INT, b INT, key(a)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 PARTITION BY RANGE (a % 7) (PARTITION p1 VALUES LESS THAN(1), PARTITION p2 VALUES LESS THAN (2), PARTITION p3 VALUES LESS THAN (5), PARTITION p4 VALUES LESS THAN(MAXVALUE));
46
47 SHOW CREATE TABLE t1;
48
49 SET @orig_innodb_file_per_table= @@innodb_file_per_table;
50 SET GLOBAL innodb_file_per_table = 0;
51 SET @save_innodb_strict_mode=@@session.innodb_strict_mode;
52 SET SESSION innodb_strict_mode = 0;
53
54 SET SESSION debug= '+d,skip_dd_table_access_check';
55 SELECT name, se_private_data FROM mysql.table_partitions;
56
57 ALTER TABLE t1 REORGANIZE PARTITION p1, p2 INTO (PARTITION p1 VALUES LESS THAN(2));
58
59 SELECT name, se_private_data FROM mysql.table_partitions;
60
61 SHOW CREATE TABLE t1;
62
63 SET GLOBAL innodb_file_per_table = @orig_innodb_file_per_table;
64 SET SESSION innodb_strict_mode=@save_innodb_strict_mode;
65
66 --source include/restart_mysqld.inc
67
68 SET SESSION debug= '+d,skip_dd_table_access_check';
69 SELECT name, se_private_data FROM mysql.table_partitions;
70
71 CHECK TABLE t1;
72
73 SHOW CREATE TABLE t1;
74
75 DROP TABLE t1;