| 1 |
ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci; |
| 2 |
SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent; |
| 3 |
SET GLOBAL innodb_stats_persistent = 0; |
| 4 |
# Bug #12429576 - Test an assertion failure on purge. |
| 5 |
CREATE TABLE t1_purge ( |
| 6 |
A int, |
| 7 |
B blob, C blob, D blob, E blob, |
| 8 |
F blob, G blob, H blob, |
| 9 |
PRIMARY KEY (B(767), C(767), D(767), E(767), A), |
| 10 |
INDEX (A) |
| 11 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 12 |
INSERT INTO t1_purge VALUES (1, |
| 13 |
REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766), |
| 14 |
REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766)); |
| 15 |
CREATE TABLE t2_purge ( |
| 16 |
A int PRIMARY KEY, |
| 17 |
B blob, C blob, D blob, E blob, |
| 18 |
F blob, G blob, H blob, I blob, |
| 19 |
J blob, K blob, L blob, |
| 20 |
INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 21 |
INSERT INTO t2_purge VALUES (1, |
| 22 |
REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766), |
| 23 |
REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766), REPEAT('i', 766), |
| 24 |
REPEAT('j', 766), REPEAT('k', 766), REPEAT('l', 766)); |
| 25 |
CREATE TABLE t3_purge ( |
| 26 |
A int, |
| 27 |
B varchar(800), C varchar(800), D varchar(800), E varchar(800), |
| 28 |
F varchar(800), G varchar(800), H varchar(800), |
| 29 |
PRIMARY KEY (B(767), C(767), D(767), E(767), A), |
| 30 |
INDEX (A) |
| 31 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 32 |
INSERT INTO t3_purge SELECT * FROM t1_purge; |
| 33 |
CREATE TABLE t4_purge ( |
| 34 |
A int PRIMARY KEY, |
| 35 |
B varchar(800), C varchar(800), D varchar(800), E varchar(800), |
| 36 |
F varchar(800), G varchar(800), H varchar(800), I varchar(800), |
| 37 |
J varchar(800), K varchar(800), L varchar(800), |
| 38 |
INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 39 |
INSERT INTO t4_purge SELECT * FROM t2_purge; |
| 40 |
DELETE FROM t1_purge; |
| 41 |
DELETE FROM t2_purge; |
| 42 |
DELETE FROM t3_purge; |
| 43 |
DELETE FROM t4_purge; |
| 44 |
SET @r=REPEAT('a',500); |
| 45 |
CREATE TABLE t12637786(a int, |
| 46 |
v1 varchar(500), v2 varchar(500), v3 varchar(500), |
| 47 |
v4 varchar(500), v5 varchar(500), v6 varchar(500), |
| 48 |
v7 varchar(500), v8 varchar(500), v9 varchar(500), |
| 49 |
v10 varchar(500), v11 varchar(500), v12 varchar(500), |
| 50 |
v13 varchar(500), v14 varchar(500), v15 varchar(500), |
| 51 |
v16 varchar(500), v17 varchar(500), v18 varchar(500) |
| 52 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 53 |
CREATE INDEX idx1 ON t12637786(a,v1); |
| 54 |
INSERT INTO t12637786 VALUES(9,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r); |
| 55 |
UPDATE t12637786 SET a=1000; |
| 56 |
DELETE FROM t12637786; |
| 57 |
# Bug#12963823 - Test that the purge thread does not crash when |
| 58 |
CREATE TABLE t12963823(a blob,b blob,c blob,d blob,e blob,f blob,g blob,h blob, |
| 59 |
i blob,j blob,k blob,l blob,m blob,n blob,o blob,p blob) |
| 60 |
ENGINE=innodb ROW_FORMAT=dynamic; |
| 61 |
SET @r = REPEAT('a', 767); |
| 62 |
INSERT INTO t12963823 VALUES (@r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r); |
| 63 |
CREATE INDEX ndx_a ON t12963823 (a(500)); |
| 64 |
CREATE INDEX ndx_b ON t12963823 (b(500)); |
| 65 |
CREATE INDEX ndx_c ON t12963823 (c(500)); |
| 66 |
CREATE INDEX ndx_d ON t12963823 (d(500)); |
| 67 |
CREATE INDEX ndx_e ON t12963823 (e(500)); |
| 68 |
CREATE INDEX ndx_f ON t12963823 (f(500)); |
| 69 |
CREATE INDEX ndx_k ON t12963823 (k(500)); |
| 70 |
CREATE INDEX ndx_l ON t12963823 (l(500)); |
| 71 |
SET @r = REPEAT('b', 500); |
| 72 |
UPDATE t12963823 set a=@r,b=@r,c=@r,d=@r; |
| 73 |
UPDATE t12963823 set e=@r,f=@r,g=@r,h=@r; |
| 74 |
UPDATE t12963823 set i=@r,j=@r,k=@r,l=@r; |
| 75 |
UPDATE t12963823 set m=@r,n=@r,o=@r,p=@r; |
| 76 |
ALTER TABLE t12963823 DROP INDEX ndx_a; |
| 77 |
ALTER TABLE t12963823 DROP INDEX ndx_b; |
| 78 |
CREATE INDEX ndx_g ON t12963823 (g(500)); |
| 79 |
CREATE INDEX ndx_h ON t12963823 (h(500)); |
| 80 |
CREATE INDEX ndx_i ON t12963823 (i(500)); |
| 81 |
CREATE INDEX ndx_j ON t12963823 (j(500)); |
| 82 |
CREATE INDEX ndx_m ON t12963823 (m(500)); |
| 83 |
CREATE INDEX ndx_n ON t12963823 (n(500)); |
| 84 |
CREATE INDEX ndx_o ON t12963823 (o(500)); |
| 85 |
CREATE INDEX ndx_p ON t12963823 (p(500)); |
| 86 |
SHOW CREATE TABLE t12963823; |
| 87 |
Table Create Table |
| 88 |
t12963823 CREATE TABLE `t12963823` ( |
| 89 |
`a` blob DEFAULT NULL, |
| 90 |
`b` blob DEFAULT NULL, |
| 91 |
`c` blob DEFAULT NULL, |
| 92 |
`d` blob DEFAULT NULL, |
| 93 |
`e` blob DEFAULT NULL, |
| 94 |
`f` blob DEFAULT NULL, |
| 95 |
`g` blob DEFAULT NULL, |
| 96 |
`h` blob DEFAULT NULL, |
| 97 |
`i` blob DEFAULT NULL, |
| 98 |
`j` blob DEFAULT NULL, |
| 99 |
`k` blob DEFAULT NULL, |
| 100 |
`l` blob DEFAULT NULL, |
| 101 |
`m` blob DEFAULT NULL, |
| 102 |
`n` blob DEFAULT NULL, |
| 103 |
`o` blob DEFAULT NULL, |
| 104 |
`p` blob DEFAULT NULL, |
| 105 |
KEY `ndx_c` (`c`(500)), |
| 106 |
KEY `ndx_d` (`d`(500)), |
| 107 |
KEY `ndx_e` (`e`(500)), |
| 108 |
KEY `ndx_f` (`f`(500)), |
| 109 |
KEY `ndx_k` (`k`(500)), |
| 110 |
KEY `ndx_l` (`l`(500)), |
| 111 |
KEY `ndx_g` (`g`(500)), |
| 112 |
KEY `ndx_h` (`h`(500)), |
| 113 |
KEY `ndx_i` (`i`(500)), |
| 114 |
KEY `ndx_j` (`j`(500)), |
| 115 |
KEY `ndx_m` (`m`(500)), |
| 116 |
KEY `ndx_n` (`n`(500)), |
| 117 |
KEY `ndx_o` (`o`(500)), |
| 118 |
KEY `ndx_p` (`p`(500)) |
| 119 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC |
| 120 |
BEGIN NOT ATOMIC |
| 121 |
DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(c', |
| 122 |
GROUP_CONCAT(seq SEPARATOR |
| 123 |
' INT DEFAULT 0, c'), |
| 124 |
' INT DEFAULT 0, PRIMARY KEY(c', |
| 125 |
GROUP_CONCAT(seq SEPARATOR ', c'), |
| 126 |
')) ENGINE=InnoDB;') FROM seq_1_to_33); |
| 127 |
EXECUTE IMMEDIATE c; |
| 128 |
END; |
| 129 |
$$ |
| 130 |
ERROR 42000: Too many key parts specified; max 32 parts allowed |
| 131 |
BEGIN NOT ATOMIC |
| 132 |
DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(c', |
| 133 |
GROUP_CONCAT(seq SEPARATOR |
| 134 |
' INT DEFAULT 0, c'), |
| 135 |
' INT DEFAULT 0, PRIMARY KEY(c', |
| 136 |
GROUP_CONCAT(seq SEPARATOR ', c'), |
| 137 |
')) ENGINE=InnoDB;') FROM seq_1_to_32); |
| 138 |
EXECUTE IMMEDIATE c; |
| 139 |
END; |
| 140 |
$$ |
| 141 |
INSERT INTO t1() VALUES(); |
| 142 |
InnoDB 0 transactions not purged |
| 143 |
SET GLOBAL innodb_stats_persistent = @save_stats_persistent; |
| 144 |
DROP TABLE t1; |
| 145 |
DROP TABLE t1_purge, t2_purge, t3_purge, t4_purge, t12637786, t12963823; |
| 146 |
ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci; |