1
set storage_engine=maria;
3
set global maria_log_file_size=4294967295;
5
drop table if exists t1, t2;
7
create table t1(a char(3));
9
insert into t1 values("abc");
11
insert into t1 select "def" from t1;
13
info: Records: 1 Duplicates: 0 Warnings: 0
14
insert into t1 select "ghi" from t1;
16
info: Records: 2 Duplicates: 0 Warnings: 0
17
insert into t1 select "jkl" from t1;
19
info: Records: 4 Duplicates: 0 Warnings: 0
20
insert into t1 select "mno" from t1;
22
info: Records: 8 Duplicates: 0 Warnings: 0
23
insert into t1 select "pqr" from t1;
25
info: Records: 16 Duplicates: 0 Warnings: 0
26
insert into t1 select "stu" from t1;
28
info: Records: 32 Duplicates: 0 Warnings: 0
29
insert into t1 select "vwx" from t1;
31
info: Records: 64 Duplicates: 0 Warnings: 0
32
insert into t1 select "yza" from t1;
34
info: Records: 128 Duplicates: 0 Warnings: 0
35
insert into t1 select "ceg" from t1;
37
info: Records: 256 Duplicates: 0 Warnings: 0
38
insert into t1 select "ikm" from t1;
40
info: Records: 512 Duplicates: 0 Warnings: 0
41
insert into t1 select "oqs" from t1;
43
info: Records: 1024 Duplicates: 0 Warnings: 0
44
select count(*) from t1;
48
insert into t1 select "uwy" from t1;
50
info: Records: 2048 Duplicates: 0 Warnings: 0
51
create table t2 select * from t1;
53
info: Records: 4096 Duplicates: 0 Warnings: 0
54
select count(*) from t1;
58
select count(*) from t2;
64
set @@max_allowed_packet=400000000;
66
create table t1 (a int, b longtext);
68
insert into t1 values (1,"123456789012345678901234567890"),(2,"09876543210987654321");
70
info: Records: 2 Duplicates: 0 Warnings: 0
71
update t1 set b=CONCAT(b,b);
73
info: Rows matched: 2 Changed: 2 Warnings: 0
74
update t1 set b=CONCAT(b,b);
76
info: Rows matched: 2 Changed: 2 Warnings: 0
77
update t1 set b=CONCAT(b,b);
79
info: Rows matched: 2 Changed: 2 Warnings: 0
80
update t1 set b=CONCAT(b,b);
82
info: Rows matched: 2 Changed: 2 Warnings: 0
83
update t1 set b=CONCAT(b,b);
85
info: Rows matched: 2 Changed: 2 Warnings: 0
86
update t1 set b=CONCAT(b,b);
88
info: Rows matched: 2 Changed: 2 Warnings: 0
89
update t1 set b=CONCAT(b,b);
91
info: Rows matched: 2 Changed: 2 Warnings: 0
92
update t1 set b=CONCAT(b,b);
94
info: Rows matched: 2 Changed: 2 Warnings: 0
95
update t1 set b=CONCAT(b,b);
97
info: Rows matched: 2 Changed: 2 Warnings: 0
98
update t1 set b=CONCAT(b,b);
100
info: Rows matched: 2 Changed: 2 Warnings: 0
101
update t1 set b=CONCAT(b,b);
103
info: Rows matched: 2 Changed: 2 Warnings: 0
104
update t1 set b=CONCAT(b,b);
106
info: Rows matched: 2 Changed: 2 Warnings: 0
107
update t1 set b=CONCAT(b,b);
109
info: Rows matched: 2 Changed: 2 Warnings: 0
110
update t1 set b=CONCAT(b,b);
112
info: Rows matched: 2 Changed: 2 Warnings: 0
113
update t1 set b=CONCAT(b,b);
115
info: Rows matched: 2 Changed: 2 Warnings: 0
116
update t1 set b=CONCAT(b,b);
118
info: Rows matched: 2 Changed: 2 Warnings: 0
119
update t1 set b=CONCAT(b,b);
121
info: Rows matched: 2 Changed: 2 Warnings: 0
122
update t1 set b=CONCAT(b,b);
124
info: Rows matched: 2 Changed: 2 Warnings: 0
125
update t1 set b=CONCAT(b,b);
127
info: Rows matched: 2 Changed: 2 Warnings: 0
128
update t1 set b=CONCAT(b,b);
130
info: Rows matched: 2 Changed: 2 Warnings: 0
131
update t1 set b=CONCAT(b,b);
133
info: Rows matched: 2 Changed: 2 Warnings: 0
134
update t1 set b=CONCAT(b,b);
136
info: Rows matched: 2 Changed: 2 Warnings: 0
137
update t1 set b=CONCAT(b,b);
139
info: Rows matched: 2 Changed: 2 Warnings: 0
140
select a,length(b) from t1;
146
Table Op Msg_type Msg_text
147
test.t1 check status OK
149
update t1 set b=mid(b,1,length(b)/2);
151
info: Rows matched: 2 Changed: 2 Warnings: 0
152
update t1 set b=mid(b,1,length(b)/2);
154
info: Rows matched: 2 Changed: 2 Warnings: 0
155
update t1 set b=mid(b,1,length(b)/2);
157
info: Rows matched: 2 Changed: 2 Warnings: 0
158
update t1 set b=mid(b,1,length(b)/2);
160
info: Rows matched: 2 Changed: 2 Warnings: 0
161
update t1 set b=mid(b,1,length(b)/2);
163
info: Rows matched: 2 Changed: 2 Warnings: 0
164
update t1 set b=mid(b,1,length(b)/2);
166
info: Rows matched: 2 Changed: 2 Warnings: 0
167
update t1 set b=mid(b,1,length(b)/2);
169
info: Rows matched: 2 Changed: 2 Warnings: 0
170
update t1 set b=mid(b,1,length(b)/2);
172
info: Rows matched: 2 Changed: 2 Warnings: 0
173
update t1 set b=mid(b,1,length(b)/2);
175
info: Rows matched: 2 Changed: 2 Warnings: 0
176
update t1 set b=mid(b,1,length(b)/2);
178
info: Rows matched: 2 Changed: 2 Warnings: 0
179
update t1 set b=mid(b,1,length(b)/2);
181
info: Rows matched: 2 Changed: 2 Warnings: 0
182
update t1 set b=mid(b,1,length(b)/2);
184
info: Rows matched: 2 Changed: 2 Warnings: 0
185
update t1 set b=mid(b,1,length(b)/2);
187
info: Rows matched: 2 Changed: 2 Warnings: 0
188
update t1 set b=mid(b,1,length(b)/2);
190
info: Rows matched: 2 Changed: 2 Warnings: 0
191
update t1 set b=mid(b,1,length(b)/2);
193
info: Rows matched: 2 Changed: 2 Warnings: 0
194
update t1 set b=mid(b,1,length(b)/2);
196
info: Rows matched: 2 Changed: 2 Warnings: 0
197
update t1 set b=mid(b,1,length(b)/2);
199
info: Rows matched: 2 Changed: 2 Warnings: 0
200
update t1 set b=mid(b,1,length(b)/2);
202
info: Rows matched: 2 Changed: 2 Warnings: 0
203
update t1 set b=mid(b,1,length(b)/2);
205
info: Rows matched: 2 Changed: 2 Warnings: 0
206
update t1 set b=mid(b,1,length(b)/2);
208
info: Rows matched: 2 Changed: 2 Warnings: 0
209
update t1 set b=mid(b,1,length(b)/2);
211
info: Rows matched: 2 Changed: 2 Warnings: 0
212
update t1 set b=mid(b,1,length(b)/2);
214
info: Rows matched: 2 Changed: 2 Warnings: 0
215
select a,length(b) from t1;
221
Table Op Msg_type Msg_text
222
test.t1 check status OK