Debian Codegraph @

mysql-test/suite/innodb/r/instant_alter,8k.rdiff

raw
1 @@ -244,7 +244,7 @@
2 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
3 WHERE name = 'test/t2';
4 clust_index_size
5 -1
6 +5
7 connection default;
8 ROLLBACK;
9 connection analyze;
10 @@ -255,7 +255,7 @@
11 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
12 WHERE name = 'test/t2';
13 clust_index_size
14 -1
15 +3
16 connection default;
17 BEGIN;
18 UPDATE t2 SET d1 = repeat(id, 200);
19 @@ -267,7 +267,7 @@
20 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
21 WHERE name = 'test/t2';
22 clust_index_size
23 -1
24 +3
25 connection default;
26 ROLLBACK;
27 connection analyze;
28 @@ -278,7 +278,7 @@
29 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
30 WHERE name = 'test/t2';
31 clust_index_size
32 -1
33 +3
34 connection default;
35 ALTER TABLE t2 DROP p;
36 affected rows: 0
37 @@ -404,7 +404,7 @@
38 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
39 WHERE name = 'test/big';
40 clust_index_size
41 -3
42 +5
43 connection default;
44 ALTER TABLE big ADD COLUMN
45 (d1 INT DEFAULT 0, d2 VARCHAR(20) DEFAULT 'abcde',
46 @@ -428,7 +428,7 @@
47 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
48 WHERE name = 'test/big';
49 clust_index_size
50 -7
51 +13
52 connection default;
53 ROLLBACK;
54 CHECKSUM TABLE big;
55 @@ -442,7 +442,7 @@
56 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
57 WHERE name = 'test/big';
58 clust_index_size
59 -3
60 +5
61 connection default;
62 InnoDB 0 transactions not purged
63 DROP TABLE t1,t2,t3,t4,big;
64 @@ -1166,7 +1166,7 @@
65 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
66 WHERE name = 'test/t2';
67 clust_index_size
68 -1
69 +5
70 connection default;
71 ROLLBACK;
72 connection analyze;
73 @@ -1177,7 +1177,7 @@
74 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
75 WHERE name = 'test/t2';
76 clust_index_size
77 -1
78 +3
79 connection default;
80 BEGIN;
81 UPDATE t2 SET d1 = repeat(id, 200);
82 @@ -1189,7 +1189,7 @@
83 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
84 WHERE name = 'test/t2';
85 clust_index_size
86 -1
87 +3
88 connection default;
89 ROLLBACK;
90 connection analyze;
91 @@ -1200,7 +1200,7 @@
92 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
93 WHERE name = 'test/t2';
94 clust_index_size
95 -1
96 +3
97 connection default;
98 ALTER TABLE t2 DROP p;
99 affected rows: 0
100 @@ -1326,7 +1326,7 @@
101 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
102 WHERE name = 'test/big';
103 clust_index_size
104 -3
105 +5
106 connection default;
107 ALTER TABLE big ADD COLUMN
108 (d1 INT DEFAULT 0, d2 VARCHAR(20) DEFAULT 'abcde',
109 @@ -1350,7 +1350,7 @@
110 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
111 WHERE name = 'test/big';
112 clust_index_size
113 -7
114 +13
115 connection default;
116 ROLLBACK;
117 CHECKSUM TABLE big;
118 @@ -1364,7 +1364,7 @@
119 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
120 WHERE name = 'test/big';
121 clust_index_size
122 -3
123 +5
124 connection default;
125 InnoDB 0 transactions not purged
126 DROP TABLE t1,t2,t3,t4,big;
127 @@ -2088,7 +2088,7 @@
128 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
129 WHERE name = 'test/t2';
130 clust_index_size
131 -1
132 +5
133 connection default;
134 ROLLBACK;
135 connection analyze;
136 @@ -2099,7 +2099,7 @@
137 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
138 WHERE name = 'test/t2';
139 clust_index_size
140 -1
141 +3
142 connection default;
143 BEGIN;
144 UPDATE t2 SET d1 = repeat(id, 200);
145 @@ -2111,7 +2111,7 @@
146 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
147 WHERE name = 'test/t2';
148 clust_index_size
149 -1
150 +3
151 connection default;
152 ROLLBACK;
153 connection analyze;
154 @@ -2122,7 +2122,7 @@
155 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
156 WHERE name = 'test/t2';
157 clust_index_size
158 -1
159 +3
160 connection default;
161 ALTER TABLE t2 DROP p;
162 affected rows: 0
163 @@ -2248,7 +2248,7 @@
164 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
165 WHERE name = 'test/big';
166 clust_index_size
167 -3
168 +5
169 connection default;
170 ALTER TABLE big ADD COLUMN
171 (d1 INT DEFAULT 0, d2 VARCHAR(20) DEFAULT 'abcde',
172 @@ -2272,7 +2272,7 @@
173 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
174 WHERE name = 'test/big';
175 clust_index_size
176 -7
177 +13
178 connection default;
179 ROLLBACK;
180 CHECKSUM TABLE big;
181 @@ -2286,7 +2286,7 @@
182 SELECT clust_index_size FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
183 WHERE name = 'test/big';
184 clust_index_size
185 -3
186 +5
187 connection default;
188 InnoDB 0 transactions not purged
189 DROP TABLE t1,t2,t3,t4,big;