Debian Codegraph @

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

raw
1
2 --source include/have_innodb_max_16k.inc
3 --source include/have_debug.inc
4
5 --echo #
6 --echo # Bug #21950756 INNODB: FAILING ASSERTION: !(&DICT_SYS->MUTEX)
7 --echo # ->IS_OWNED() IN DICT0STATS.CC 3049
8 --echo #
9
10 SET @saved_innodb_strict_mode=@@SESSION.innodb_strict_mode;
11 SET SESSION innodb_strict_mode=OFF;
12
13 --disable_warnings
14 CREATE TABLE t1(
15 c0 INT(1),
16 c1 INT(1),
17 c2 INT(4),
18 c3 DATE,
19 c4 TIME,
20 c5 SET('test1','test2','test3'),
21 c6 TIME,
22 c7 TEXT,
23 c8 DECIMAL(0,0),
24 c9 SET('test1','test2','test3'),
25 c10 FLOAT,
26 c11 DOUBLE,
27 c12 ENUM('test1','test2','test3'),
28 c13 BLOB,
29 c14 YEAR,
30 c15 SET('test1','test2','test3'),
31 c16 DECIMAL(0,0),
32 c17 DECIMAL(0,0),
33 c18 BLOB,
34 c19 DATE,
35 c20 DOUBLE,
36 c21 DECIMAL(0,0),
37 c22 DATE,
38 c23 DECIMAL(0,0),
39 c24 DECIMAL(0,0),
40 c25 TEXT,
41 c26 BLOB,
42 c27 TIME,
43 c28 BLOB,
44 c29 ENUM('test1','test2','test3'),
45 c30 INT(6),
46 c31 DOUBLE,
47 c32 FLOAT,
48 c33 char(175),
49 c34 TEXT,
50 c35 TEXT,
51 c36 BLOB,
52 c37 BLOB,
53 c38 TEXT,
54 c39 BLOB,
55 c40 TIMESTAMP,
56 c41 DOUBLE,
57 c42 INT(6),
58 c43 BLOB,
59 c44 VARCHAR(80),
60 c45 TEXT,
61 c46 DECIMAL(0,0),
62 c47 INT(20),
63 c48 DATE,
64 c49 BLOB,
65 c50 DATE,
66 c51 INT(1),
67 c52 INT(9),
68 c53 FLOAT,
69 c54 BLOB,
70 c55 TEXT,
71 c56 INT(6),
72 c57 ENUM('test1','test2','test3'),
73 c58 DATE,
74 c59 TEXT,
75 c60 VARCHAR(232),
76 c61 DECIMAL(0,0),
77 c62 YEAR,
78 c63 INT(6),
79 c64 TIMESTAMP DEFAULT '0000-00-00 00:00:00',
80 c65 BLOB,
81 c66 BLOB,
82 c67 INT(11),
83 c68 TEXT,
84 c69 ENUM('test1','test2','test3'),
85 c70 INT(11),
86 c71 TIME,
87 c72 TIMESTAMP DEFAULT '0000-00-00 00:00:00',
88 c73 TIMESTAMP DEFAULT '0000-00-00 00:00:00',
89 c74 VARCHAR(170),
90 c75 SET('test1','test2','test3'),
91 c76 BLOB,
92 c77 INT(20),
93 c78 DECIMAL(0,0),
94 c79 DATE,
95 c80 YEAR,
96 c81 DECIMAL(0,0),
97 c82 BLOB,
98 c83 TEXT,
99 c84 char(83),
100 c85 DECIMAL(0,0),
101 c86 FLOAT,
102 c87 INT(11),
103 c88 VARCHAR(145),
104 c89 DATE,
105 c90 DECIMAL(0,0),
106 c91 DECIMAL(0,0),
107 c92 BLOB,
108 c93 TIME,
109 KEY idx0 (c69,c90,c8),
110 KEY idx1 (c60),
111 KEY idx2 (c60,c70,c74),
112 KEY idx3 (c22,c32,c72,c30),
113 KEY idx4 (c29),
114 KEY idx5 (c19,c45(143)),
115 KEY idx6 (c46,c48,c5,c39(118)),
116 KEY idx7 (c48,c61),
117 KEY idx8 (c93),
118 KEY idx9 (c31),
119 KEY idx10 (c30,c21),
120 KEY idx11 (c67),
121 KEY idx12 (c44,c6,c8,c38(226)),
122 KEY idx13 (c71,c41,c15,c49(88)),
123 KEY idx14 (c78),
124 KEY idx15 (c63,c67,c64),
125 KEY idx16 (c17,c86),
126 KEY idx17 (c77,c56,c10,c55(24)),
127 KEY idx18 (c62),
128 KEY idx19 (c31,c57,c56,c53),
129 KEY idx20 (c46),
130 KEY idx21 (c83(54)),
131 KEY idx22 (c51,c7(120)),
132 KEY idx23 (c7(163),c31,c71,c14))
133 ENGINE=InnoDB DEFAULT CHARSET=latin1
134 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2;
135 --enable_warnings
136
137 SET @@session.max_heap_table_size=16384;
138 SELECT @@session.max_heap_table_size;
139
140 SELECT database_name,table_name,index_name,compress_ops,compress_ops_ok,
141 uncompress_ops FROM information_schema.innodb_cmp_per_index;
142
143 DROP TABLE t1;
144
145 SET SESSION innodb_strict_mode=@saved_innodb_strict_mode;