Debian Codegraph @

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

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