Debian Codegraph @

mysql-test/suite/maria/maria-big.result

raw
1 set global max_allowed_packet=400000000;
2 connect root,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK;
3 connection root;
4 set default_storage_engine=aria;
5 affected rows: 0
6 drop table if exists t1, t2;
7 affected rows: 0
8 create table t1(a char(3));
9 affected rows: 0
10 insert into t1 values("abc");
11 affected rows: 1
12 insert into t1 select "def" from t1;
13 affected rows: 1
14 info: Records: 1 Duplicates: 0 Warnings: 0
15 insert into t1 select "ghi" from t1;
16 affected rows: 2
17 info: Records: 2 Duplicates: 0 Warnings: 0
18 insert into t1 select "jkl" from t1;
19 affected rows: 4
20 info: Records: 4 Duplicates: 0 Warnings: 0
21 insert into t1 select "mno" from t1;
22 affected rows: 8
23 info: Records: 8 Duplicates: 0 Warnings: 0
24 insert into t1 select "pqr" from t1;
25 affected rows: 16
26 info: Records: 16 Duplicates: 0 Warnings: 0
27 insert into t1 select "stu" from t1;
28 affected rows: 32
29 info: Records: 32 Duplicates: 0 Warnings: 0
30 insert into t1 select "vwx" from t1;
31 affected rows: 64
32 info: Records: 64 Duplicates: 0 Warnings: 0
33 insert into t1 select "yza" from t1;
34 affected rows: 128
35 info: Records: 128 Duplicates: 0 Warnings: 0
36 insert into t1 select "ceg" from t1;
37 affected rows: 256
38 info: Records: 256 Duplicates: 0 Warnings: 0
39 insert into t1 select "ikm" from t1;
40 affected rows: 512
41 info: Records: 512 Duplicates: 0 Warnings: 0
42 insert into t1 select "oqs" from t1;
43 affected rows: 1024
44 info: Records: 1024 Duplicates: 0 Warnings: 0
45 select count(*) from t1;
46 count(*)
47 2048
48 affected rows: 1
49 insert into t1 select "uwy" from t1;
50 affected rows: 2048
51 info: Records: 2048 Duplicates: 0 Warnings: 0
52 create table t2 select * from t1;
53 affected rows: 4096
54 info: Records: 4096 Duplicates: 0 Warnings: 0
55 select count(*) from t1;
56 count(*)
57 4096
58 affected rows: 1
59 select count(*) from t2;
60 count(*)
61 4096
62 affected rows: 1
63 drop table t1, t2;
64 affected rows: 0
65 create table t1 (a int, b longtext);
66 affected rows: 0
67 insert into t1 values (1,"123456789012345678901234567890"),(2,"09876543210987654321");
68 affected rows: 2
69 info: Records: 2 Duplicates: 0 Warnings: 0
70 update t1 set b=CONCAT(b,b);
71 affected rows: 2
72 info: Rows matched: 2 Changed: 2 Warnings: 0
73 update t1 set b=CONCAT(b,b);
74 affected rows: 2
75 info: Rows matched: 2 Changed: 2 Warnings: 0
76 update t1 set b=CONCAT(b,b);
77 affected rows: 2
78 info: Rows matched: 2 Changed: 2 Warnings: 0
79 update t1 set b=CONCAT(b,b);
80 affected rows: 2
81 info: Rows matched: 2 Changed: 2 Warnings: 0
82 update t1 set b=CONCAT(b,b);
83 affected rows: 2
84 info: Rows matched: 2 Changed: 2 Warnings: 0
85 update t1 set b=CONCAT(b,b);
86 affected rows: 2
87 info: Rows matched: 2 Changed: 2 Warnings: 0
88 update t1 set b=CONCAT(b,b);
89 affected rows: 2
90 info: Rows matched: 2 Changed: 2 Warnings: 0
91 update t1 set b=CONCAT(b,b);
92 affected rows: 2
93 info: Rows matched: 2 Changed: 2 Warnings: 0
94 update t1 set b=CONCAT(b,b);
95 affected rows: 2
96 info: Rows matched: 2 Changed: 2 Warnings: 0
97 update t1 set b=CONCAT(b,b);
98 affected rows: 2
99 info: Rows matched: 2 Changed: 2 Warnings: 0
100 update t1 set b=CONCAT(b,b);
101 affected rows: 2
102 info: Rows matched: 2 Changed: 2 Warnings: 0
103 update t1 set b=CONCAT(b,b);
104 affected rows: 2
105 info: Rows matched: 2 Changed: 2 Warnings: 0
106 update t1 set b=CONCAT(b,b);
107 affected rows: 2
108 info: Rows matched: 2 Changed: 2 Warnings: 0
109 update t1 set b=CONCAT(b,b);
110 affected rows: 2
111 info: Rows matched: 2 Changed: 2 Warnings: 0
112 update t1 set b=CONCAT(b,b);
113 affected rows: 2
114 info: Rows matched: 2 Changed: 2 Warnings: 0
115 update t1 set b=CONCAT(b,b);
116 affected rows: 2
117 info: Rows matched: 2 Changed: 2 Warnings: 0
118 update t1 set b=CONCAT(b,b);
119 affected rows: 2
120 info: Rows matched: 2 Changed: 2 Warnings: 0
121 update t1 set b=CONCAT(b,b);
122 affected rows: 2
123 info: Rows matched: 2 Changed: 2 Warnings: 0
124 update t1 set b=CONCAT(b,b);
125 affected rows: 2
126 info: Rows matched: 2 Changed: 2 Warnings: 0
127 update t1 set b=CONCAT(b,b);
128 affected rows: 2
129 info: Rows matched: 2 Changed: 2 Warnings: 0
130 update t1 set b=CONCAT(b,b);
131 affected rows: 2
132 info: Rows matched: 2 Changed: 2 Warnings: 0
133 update t1 set b=CONCAT(b,b);
134 affected rows: 2
135 info: Rows matched: 2 Changed: 2 Warnings: 0
136 update t1 set b=CONCAT(b,b);
137 affected rows: 2
138 info: Rows matched: 2 Changed: 2 Warnings: 0
139 select a,length(b) from t1;
140 a length(b)
141 1 251658240
142 2 167772160
143 affected rows: 2
144 check table t1;
145 Table Op Msg_type Msg_text
146 test.t1 check status OK
147 affected rows: 1
148 update t1 set b=mid(b,1,length(b)/2);
149 affected rows: 2
150 info: Rows matched: 2 Changed: 2 Warnings: 0
151 update t1 set b=mid(b,1,length(b)/2);
152 affected rows: 2
153 info: Rows matched: 2 Changed: 2 Warnings: 0
154 update t1 set b=mid(b,1,length(b)/2);
155 affected rows: 2
156 info: Rows matched: 2 Changed: 2 Warnings: 0
157 update t1 set b=mid(b,1,length(b)/2);
158 affected rows: 2
159 info: Rows matched: 2 Changed: 2 Warnings: 0
160 update t1 set b=mid(b,1,length(b)/2);
161 affected rows: 2
162 info: Rows matched: 2 Changed: 2 Warnings: 0
163 update t1 set b=mid(b,1,length(b)/2);
164 affected rows: 2
165 info: Rows matched: 2 Changed: 2 Warnings: 0
166 update t1 set b=mid(b,1,length(b)/2);
167 affected rows: 2
168 info: Rows matched: 2 Changed: 2 Warnings: 0
169 update t1 set b=mid(b,1,length(b)/2);
170 affected rows: 2
171 info: Rows matched: 2 Changed: 2 Warnings: 0
172 update t1 set b=mid(b,1,length(b)/2);
173 affected rows: 2
174 info: Rows matched: 2 Changed: 2 Warnings: 0
175 update t1 set b=mid(b,1,length(b)/2);
176 affected rows: 2
177 info: Rows matched: 2 Changed: 2 Warnings: 0
178 update t1 set b=mid(b,1,length(b)/2);
179 affected rows: 2
180 info: Rows matched: 2 Changed: 2 Warnings: 0
181 update t1 set b=mid(b,1,length(b)/2);
182 affected rows: 2
183 info: Rows matched: 2 Changed: 2 Warnings: 0
184 update t1 set b=mid(b,1,length(b)/2);
185 affected rows: 2
186 info: Rows matched: 2 Changed: 2 Warnings: 0
187 update t1 set b=mid(b,1,length(b)/2);
188 affected rows: 2
189 info: Rows matched: 2 Changed: 2 Warnings: 0
190 update t1 set b=mid(b,1,length(b)/2);
191 affected rows: 2
192 info: Rows matched: 2 Changed: 2 Warnings: 0
193 update t1 set b=mid(b,1,length(b)/2);
194 affected rows: 2
195 info: Rows matched: 2 Changed: 2 Warnings: 0
196 update t1 set b=mid(b,1,length(b)/2);
197 affected rows: 2
198 info: Rows matched: 2 Changed: 2 Warnings: 0
199 update t1 set b=mid(b,1,length(b)/2);
200 affected rows: 2
201 info: Rows matched: 2 Changed: 2 Warnings: 0
202 update t1 set b=mid(b,1,length(b)/2);
203 affected rows: 2
204 info: Rows matched: 2 Changed: 2 Warnings: 0
205 update t1 set b=mid(b,1,length(b)/2);
206 affected rows: 2
207 info: Rows matched: 2 Changed: 2 Warnings: 0
208 update t1 set b=mid(b,1,length(b)/2);
209 affected rows: 2
210 info: Rows matched: 2 Changed: 2 Warnings: 0
211 update t1 set b=mid(b,1,length(b)/2);
212 affected rows: 2
213 info: Rows matched: 2 Changed: 2 Warnings: 0
214 select a,length(b) from t1;
215 a length(b)
216 1 60
217 2 40
218 affected rows: 2
219 check table t1;
220 Table Op Msg_type Msg_text
221 test.t1 check status OK
222 affected rows: 1
223 drop table t1;
224 affected rows: 0