Debian Codegraph @

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

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