| 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; |