Debian Codegraph @

mysql-test/suite/vcol/r/vcol_ins_upd_innodb.result

raw
1 SET @@session.default_storage_engine = 'InnoDB';
2 create table t1 (a int,
3 b int as (-a),
4 c int as (-a) persistent);
5 set sql_warnings = 1;
6 set @@optimizer_scan_setup_cost=0;
7 #
8 # *** INSERT ***
9 #
10 # INSERT INTO tbl_name VALUES... DEFAULT is specified against vcols
11 insert into t1 values (1,default,default);
12 select * from t1;
13 a b c
14 1 -1 -1
15 delete from t1;
16 select * from t1;
17 a b c
18 # INSERT INTO tbl_name VALUES... NULL is specified against vcols
19 insert into t1 values (1,null,null);
20 select * from t1;
21 a b c
22 1 -1 -1
23 delete from t1;
24 select * from t1;
25 a b c
26 # INSERT INTO tbl_name VALUES... a non-NULL value is specified against vcols
27 insert ignore into t1 values (1,2,3);
28 Warnings:
29 Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored
30 Warning 1906 The value specified for generated column 'c' in table 't1' has been ignored
31 select * from t1;
32 a b c
33 1 -1 -1
34 delete from t1;
35 select * from t1;
36 a b c
37 # INSERT INTO tbl_name (<non_vcol_list>) VALUES...
38 insert into t1 (a) values (1), (2);
39 select * from t1;
40 a b c
41 1 -1 -1
42 2 -2 -2
43 delete from t1;
44 select * from t1;
45 a b c
46 # INSERT INTO tbl_name (<normal+vcols>) VALUES... DEFAULT is specified
47 # against vcols
48 insert into t1 (a,b) values (1,default), (2,default);
49 select * from t1;
50 a b c
51 1 -1 -1
52 2 -2 -2
53 delete from t1;
54 select * from t1;
55 a b c
56 # INSERT INTO tbl_name (<normal+vcols>) VALUES... NULL is specified against vcols
57 insert into t1 (a,b) values (1,null), (2,null);
58 select * from t1;
59 a b c
60 1 -1 -1
61 2 -2 -2
62 delete from t1;
63 select * from t1;
64 a b c
65 # INSERT INTO tbl_name (<normal+vcols>) VALUES... a non-NULL value is specified
66 # against vcols
67 insert ignore into t1 (a,b) values (1,3), (2,4);
68 Warnings:
69 Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored
70 Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored
71 select * from t1;
72 a b c
73 1 -1 -1
74 2 -2 -2
75 delete from t1;
76 select * from t1;
77 a b c
78 drop table t1;
79 # Table with UNIQUE non-vcol field. INSERT INTO tbl_name VALUES... ON DUPLICATE
80 # KEY UPDATE <non_vcol>=expr, <vcol>=expr
81 create table t1 (a int unique,
82 b int as (-a),
83 c int as (-a) persistent);
84 insert into t1 values (1,default,default);
85 insert into t1 values (1,default,default)
86 on duplicate key update a=2, b=default;
87 select a,b,c from t1;
88 a b c
89 2 -2 -2
90 delete from t1 where b in (1,2);
91 select * from t1;
92 a b c
93 2 -2 -2
94 drop table t1;
95 # Table with UNIQUE vcol field. INSERT INTO tbl_name VALUES... ON DUPLICATE
96 # KEY UPDATE <non_vcol>=expr, <vcol>=expr
97 create table t1 (a int,
98 b int as (-a),
99 c int as (-a) persistent unique);
100 insert into t1 values (1,default,default);
101 insert into t1 values (1,default,default)
102 on duplicate key update a=2, b=default;
103 select a,b,c from t1;
104 a b c
105 2 -2 -2
106 # CREATE new_table ... LIKE old_table
107 # INSERT INTO new_table SELECT * from old_table
108 create table t2 like t1;
109 insert ignore into t2 select * from t1;
110 Warnings:
111 Warning 1906 The value specified for generated column 'b' in table 't2' has been ignored
112 Warning 1906 The value specified for generated column 'c' in table 't2' has been ignored
113 select * from t1;
114 a b c
115 2 -2 -2
116 drop table t2;
117 # CREATE new_table ... LIKE old_table INSERT INTO new_table (<non-vcols>, <vcols>)
118 # SELECT <non-vcols>, <vcols> from old_table
119 insert into t1 values (1,default,default);
120 select * from t1;
121 a b c
122 2 -2 -2
123 1 -1 -1
124 create table t2 like t1;
125 insert ignore into t2 (a,b) select a,b from t1;
126 Warnings:
127 Warning 1906 The value specified for generated column 'b' in table 't2' has been ignored
128 Warning 1906 The value specified for generated column 'b' in table 't2' has been ignored
129 select * from t2;
130 a b c
131 2 -2 -2
132 1 -1 -1
133 drop table t2;
134 drop table t1;
135 #
136 # *** UPDATE ***
137 #
138 # UPDATE tbl_name SET non-vcol=expr WHERE non-vcol=expr
139 create table t1 (a int,
140 b int as (-a),
141 c int as (-a) persistent);
142 insert into t1 (a) values (1), (2);
143 select * from t1;
144 a b c
145 1 -1 -1
146 2 -2 -2
147 update t1 set a=3 where a=2;
148 select * from t1;
149 a b c
150 1 -1 -1
151 3 -3 -3
152 delete from t1;
153 select * from t1;
154 a b c
155 # UPDATE tbl_name SET vcol=expr WHERE non-vcol=expr
156 insert into t1 (a) values (1), (2);
157 select * from t1;
158 a b c
159 1 -1 -1
160 2 -2 -2
161 update ignore t1 set c=3 where a=2;
162 Warnings:
163 Warning 1906 The value specified for generated column 'c' in table 't1' has been ignored
164 select * from t1;
165 a b c
166 1 -1 -1
167 2 -2 -2
168 delete from t1;
169 select * from t1;
170 a b c
171 # UPDATE tbl_name SET non-vcol=expr WHERE vcol=expr
172 insert into t1 (a) values (1), (2);
173 select * from t1;
174 a b c
175 1 -1 -1
176 2 -2 -2
177 update t1 set a=3 where b=-2;
178 select * from t1;
179 a b c
180 1 -1 -1
181 3 -3 -3
182 delete from t1;
183 select * from t1;
184 a b c
185 # UPDATE tbl_name SET vcol=expr WHERE vcol=expr
186 insert into t1 (a) values (1), (2);
187 select * from t1;
188 a b c
189 1 -1 -1
190 2 -2 -2
191 update ignore t1 set c=3 where b=-2;
192 Warnings:
193 Warning 1906 The value specified for generated column 'c' in table 't1' has been ignored
194 select * from t1;
195 a b c
196 1 -1 -1
197 2 -2 -2
198 delete from t1;
199 select * from t1;
200 a b c
201 drop table t1;
202 # INDEX created on vcol
203 # UPDATE tbl_name SET non-vcol=expr WHERE vcol=const
204 create table t1 (a int,
205 b int as (-a),
206 c int as (-a) persistent unique);
207 insert into t1 (a) values (1), (2);
208 select * from t1;
209 a b c
210 1 -1 -1
211 2 -2 -2
212 update t1 set a=3 where c=-2;
213 select * from t1;
214 a b c
215 1 -1 -1
216 3 -3 -3
217 delete from t1;
218 select * from t1;
219 a b c
220 # INDEX created on vcol
221 # UPDATE tbl_name SET non-vcol=expr WHERE vcol=between const1 and const2
222 insert into t1 (a) values (1), (2);
223 select * from t1;
224 a b c
225 1 -1 -1
226 2 -2 -2
227 update t1 set a=3 where c between -3 and -2;
228 select * from t1;
229 a b c
230 1 -1 -1
231 3 -3 -3
232 delete from t1;
233 select * from t1;
234 a b c
235 # No INDEX created on vcol
236 # UPDATE tbl_name SET non-vcol=expr WHERE vcol=between const1 and const2
237 insert into t1 (a) values (1), (2);
238 select * from t1;
239 a b c
240 1 -1 -1
241 2 -2 -2
242 update t1 set a=3 where b between -3 and -2;
243 select * from t1;
244 a b c
245 1 -1 -1
246 3 -3 -3
247 delete from t1;
248 select * from t1;
249 a b c
250 # INDEX created on vcol
251 # UPDATE tbl_name SET non-vcol=expr
252 # WHERE vcol=between const1 and const2 ORDER BY vcol
253 insert into t1 (a) values (1), (2), (3), (4), (5);
254 select * from t1;
255 a b c
256 1 -1 -1
257 2 -2 -2
258 3 -3 -3
259 4 -4 -4
260 5 -5 -5
261 update t1 set a=6 where c between -1 and 0
262 order by c;
263 select * from t1;
264 a b c
265 6 -6 -6
266 2 -2 -2
267 3 -3 -3
268 4 -4 -4
269 5 -5 -5
270 delete from t1 where c between -6 and 0;
271 select * from t1;
272 a b c
273 # INDEX created on vcol
274 # UPDATE tbl_name SET non-vcol=expr
275 # WHERE vcol=between const1 and const2 ORDER BY vcol LIMIT 2
276 insert into t1 (a) values (1), (2), (3), (4), (5);
277 select * from t1;
278 a b c
279 1 -1 -1
280 2 -2 -2
281 3 -3 -3
282 4 -4 -4
283 5 -5 -5
284 update t1 set a=6 where c between -1 and 0
285 order by c limit 2;
286 select * from t1;
287 a b c
288 6 -6 -6
289 2 -2 -2
290 3 -3 -3
291 4 -4 -4
292 5 -5 -5
293 delete from t1 where c between -2 and 0 order by c;
294 select * from t1;
295 a b c
296 6 -6 -6
297 3 -3 -3
298 4 -4 -4
299 5 -5 -5
300 delete from t1;
301 # INDEX created on vcol
302 # UPDATE tbl_name SET non-vcol=expr
303 # WHERE indexed vcol=between const1 and const2 and non-indexed vcol=const3
304 insert into t1 (a) values (1), (2), (3), (4), (5);
305 select * from t1;
306 a b c
307 1 -1 -1
308 2 -2 -2
309 3 -3 -3
310 4 -4 -4
311 5 -5 -5
312 update t1 set a=6 where (c between -2 and 0) and (b=-1);
313 select * from t1;
314 a b c
315 6 -6 -6
316 2 -2 -2
317 3 -3 -3
318 4 -4 -4
319 5 -5 -5
320 delete from t1;
321 # INDEX created on vcol
322 # UPDATE tbl_name SET non-vcol=expr
323 # WHERE indexed vcol=between const1 and const2 and non-indexed vcol=const3
324 # ORDER BY indexed vcol
325 insert into t1 (a) values (1), (2), (3), (4), (5);
326 select * from t1;
327 a b c
328 1 -1 -1
329 2 -2 -2
330 3 -3 -3
331 4 -4 -4
332 5 -5 -5
333 update t1 set a=6 where (c between -2 and 0) and (b=-1) order by c;
334 select * from t1;
335 a b c
336 6 -6 -6
337 2 -2 -2
338 3 -3 -3
339 4 -4 -4
340 5 -5 -5
341 delete from t1;
342 drop table t1;
343 #
344 # Verify ON UPDATE/DELETE actions of FOREIGN KEYs
345 create table t2 (a int primary key, name varchar(10));
346 create table t1 (a int primary key, b int as (a % 10) persistent);
347 insert into t2 values (1, 'value1'), (2,'value2'), (3,'value3');
348 insert into t1 (a) values (1),(2),(3);
349 select * from t1;
350 a b
351 1 1
352 2 2
353 3 3
354 select * from t2;
355 a name
356 1 value1
357 2 value2
358 3 value3
359 select t1.a, t1.b, t2.name from t1,t2 where t1.b=t2.a;
360 a b name
361 1 1 value1
362 2 2 value2
363 3 3 value3
364 # - ON UPDATE RESTRICT
365 alter table t1 add foreign key (b) references t2(a) on update restrict;
366 insert into t1 (a) values (4);
367 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t2` (`a`))
368 update t2 set a=4 where a=3;
369 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t2` (`a`))
370 select t1.a, t1.b, t2.name from t1,t2 where t1.b=t2.a;
371 a b name
372 1 1 value1
373 2 2 value2
374 3 3 value3
375 alter table t1 drop foreign key t1_ibfk_1;
376 # - ON DELETE RESTRICT
377 alter table t1 add foreign key (b) references t2(a) on delete restrict;
378 delete from t2 where a=3;
379 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t2` (`a`))
380 select t1.a, t1.b, t2.name from t1,t2 where t1.b=t2.a;
381 a b name
382 1 1 value1
383 2 2 value2
384 3 3 value3
385 select t1.a, t1.b, t2.name from t1 left outer join t2 on (t1.b=t2.a);
386 a b name
387 1 1 value1
388 2 2 value2
389 3 3 value3
390 alter table t1 drop foreign key t1_ibfk_1;
391 # - ON DELETE CASCADE
392 alter table t1 add foreign key (b) references t2(a) on delete cascade;
393 delete from t2 where a=3;
394 select t1.a, t1.b, t2.name from t1,t2 where t1.b=t2.a;
395 a b name
396 1 1 value1
397 2 2 value2
398 select t1.a, t1.b, t2.name from t1 left outer join t2 on (t1.b=t2.a);
399 a b name
400 1 1 value1
401 2 2 value2
402 alter table t1 drop foreign key t1_ibfk_1;
403 drop table t1;
404 drop table t2;
405 #
406 # *** REPLACE ***
407 #
408 # UNIQUE INDEX on vcol
409 # REPLACE tbl_name (non-vcols) VALUES (non-vcols);
410 create table t1 (a int,
411 b int as (-a),
412 c int as (-a) persistent unique,
413 d varchar(16));
414 insert into t1 (a,d) values (1,'a'), (2,'b');
415 select * from t1;
416 a b c d
417 1 -1 -1 a
418 2 -2 -2 b
419 replace t1 (a,d) values (1,'c');
420 select * from t1;
421 a b c d
422 1 -1 -1 c
423 2 -2 -2 b
424 delete from t1;
425 select * from t1;
426 a b c d
427 set sql_warnings = 0;
428 drop table t1;
429 #
430 # MDEV-9093: Persistent computed column is not updated when
431 # update query contains join
432 #
433 CREATE TABLE `t1` (
434 `id` bigint(20) NOT NULL,
435 `name` varchar(254) DEFAULT NULL,
436 `name_hash` varchar(64) AS (sha1(name)) PERSISTENT,
437 PRIMARY KEY (`id`)
438 );
439 insert into t1(id,name) values (2050, 'name1'),(2051, 'name2'),(2041, 'name3');
440 create table t2 (id bigint);
441 insert into t2 values (2050),(2051),(2041);
442 select * from t1;
443 id name name_hash
444 2041 name3 1aefcd1b0f39da45fa1fd7236f683c907c15ef82
445 2050 name1 9b46b0dd3a8083c070c3b9953bb5f3f95c5ab4da
446 2051 name2 39ea84acf1fef629fef18a9c6f5799bba32ecc25
447 update t1 join t2 using(id) set name = concat(name,
448 '+1') where t1.id in (2051,2041);
449 select * from t1;
450 id name name_hash
451 2041 name3+1 93c9096df48221428de46e146abc9f4f94bf7d2e
452 2050 name1 9b46b0dd3a8083c070c3b9953bb5f3f95c5ab4da
453 2051 name2+1 fd4f236320db3956a5ec073c5ec39707d7f05708
454 drop table t1,t2;
455 #
456 # Test error handling with virtual columns
457 #
458 CREATE TABLE IF NOT EXISTS t1 (
459 f1 DOUBLE,
460 f2 DOUBLE NOT NULL DEFAULT '0',
461 f3 DOUBLE,
462 f4 DOUBLE NOT NULL DEFAULT '0',
463 v1 DOUBLE AS ( ( f1 DIV ( f1 ) ) <= f2 ) VIRTUAL,
464 v2 DOUBLE AS ( ( f2 DIV ( f2 ) ) <= f2 ) VIRTUAL,
465 KEY (v2)
466 );
467 set sql_mode='strict_all_tables,error_for_division_by_zero';
468 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0, 0, 0, 0);
469 ERROR 22012: Division by 0
470 INSERT INTO t1 (f1, f2, f3, f4) VALUES (1, 1, 1, 1);
471 INSERT INTO t1 (f1, f2, f3, f4) VALUES (1, 0, 1, 1);
472 ERROR 22012: Division by 0
473 INSERT IGNORE INTO t1 (f1, f2, f3, f4) VALUES (1, 0, 1, 1);
474 Warnings:
475 Warning 1365 Division by 0
476 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0, 1, 1, 1);
477 select v1 from t1;
478 v1
479 1
480 0
481 NULL
482 Warnings:
483 Warning 1365 Division by 0
484 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0,0,0,0), (2,2,2,2);
485 ERROR 22012: Division by 0
486 INSERT INTO t1 (f1, f2, f3, f4) VALUES (3,3,3,3), (4,4,4,4);
487 INSERT INTO t1 (f1, f2, f3, f4) VALUES (5,5,5,5), (1,0,0,0);
488 ERROR 22012: Division by 0
489 INSERT INTO t1 (f1, f2, f3, f4) VALUES (6,6,0,0);
490 INSERT INTO t1 ( f1, f2, f3, f4 ) SELECT f3, f4, f3, f4 FROM t1;
491 ERROR 22012: Division by 0
492 select count(*) from t1;
493 count(*)
494 6
495 DELETE FROM t1 WHERE v2 != f1 and f1 < 5;
496 Warnings:
497 Warning 1365 Division by 0
498 Warning 1365 Division by 0
499 select count(*) from t1;
500 count(*)
501 3
502 select * from t1;
503 f1 f2 f3 f4 v1 v2
504 1 1 1 1 1 1
505 1 0 1 1 0 NULL
506 6 6 0 0 1 1
507 Warnings:
508 Warning 1365 Division by 0
509 INSERT INTO t1 ( f1, f2, f3, f4 ) SELECT v1, v2, 10,10 FROM t1;
510 ERROR 23000: Column 'f2' cannot be null
511 INSERT INTO t1 ( f1, f2, f3, f4 ) SELECT v1, v2, 10,10 FROM t1 where f2 !=0;
512 Warnings:
513 Warning 1365 Division by 0
514 UPDATE t1 SET f3 = v1 WHERE f2 = 2 AND v2 is null;
515 Warnings:
516 Warning 1365 Division by 0
517 SELECT * FROM t1;
518 f1 f2 f3 f4 v1 v2
519 1 1 1 1 1 1
520 1 0 1 1 0 NULL
521 6 6 0 0 1 1
522 1 1 10 10 1 1
523 1 1 10 10 1 1
524 Warnings:
525 Warning 1365 Division by 0
526 TRUNCATE TABLE t1;
527 set sql_mode='error_for_division_by_zero';
528 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0, 0, 0, 0);
529 Warnings:
530 Warning 1365 Division by 0
531 INSERT INTO t1 (f1, f2, f3, f4) VALUES (1, 1, 1, 1);
532 INSERT INTO t1 (f1, f2, f3, f4) VALUES (1, 0, 1, 1);
533 Warnings:
534 Warning 1365 Division by 0
535 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0, 1, 1, 1);
536 select v1 from t1;
537 v1
538 NULL
539 1
540 0
541 NULL
542 Warnings:
543 Warning 1365 Division by 0
544 Warning 1365 Division by 0
545 INSERT INTO t1 (f1, f2, f3, f4) VALUES (0,0,0,0), (2,2,2,2);
546 Warnings:
547 Warning 1365 Division by 0
548 INSERT INTO t1 (f1, f2, f3, f4) VALUES (3,3,3,3), (4,4,4,4);
549 INSERT INTO t1 (f1, f2, f3, f4) VALUES (5,5,5,5), (1,0,0,0);
550 Warnings:
551 Warning 1365 Division by 0
552 INSERT INTO t1 (f1, f2, f3, f4) VALUES (6,6,0,0);
553 INSERT INTO t1 ( f1, f2, f3, f4 ) SELECT f3, f4, f3, f4 FROM t1;
554 Warnings:
555 Warning 1365 Division by 0
556 Warning 1365 Division by 0
557 Warning 1365 Division by 0
558 Warning 1365 Division by 0
559 select count(*) from t1;
560 count(*)
561 22
562 DELETE FROM t1 WHERE v2 != f1 and f1 < 5;
563 Warnings:
564 Warning 1365 Division by 0
565 Warning 1365 Division by 0
566 Warning 1365 Division by 0
567 Warning 1365 Division by 0
568 Warning 1365 Division by 0
569 Warning 1365 Division by 0
570 Warning 1365 Division by 0
571 Warning 1365 Division by 0
572 Warning 1365 Division by 0
573 Warning 1365 Division by 0
574 Warning 1365 Division by 0
575 Warning 1365 Division by 0
576 Warning 1365 Division by 0
577 Warning 1365 Division by 0
578 Warning 1365 Division by 0
579 Warning 1365 Division by 0
580 select count(*) from t1;
581 count(*)
582 15
583 select * from t1;
584 f1 f2 f3 f4 v1 v2
585 0 0 0 0 NULL NULL
586 1 1 1 1 1 1
587 1 0 1 1 0 NULL
588 0 0 0 0 NULL NULL
589 5 5 5 5 1 1
590 1 0 0 0 0 NULL
591 6 6 0 0 1 1
592 0 0 0 0 NULL NULL
593 1 1 1 1 1 1
594 1 1 1 1 1 1
595 1 1 1 1 1 1
596 0 0 0 0 NULL NULL
597 5 5 5 5 1 1
598 0 0 0 0 NULL NULL
599 0 0 0 0 NULL NULL
600 Warnings:
601 Warning 1365 Division by 0
602 Warning 1365 Division by 0
603 Warning 1365 Division by 0
604 Warning 1365 Division by 0
605 Warning 1365 Division by 0
606 Warning 1365 Division by 0
607 Warning 1365 Division by 0
608 Warning 1365 Division by 0
609 Warning 1365 Division by 0
610 Warning 1365 Division by 0
611 Warning 1365 Division by 0
612 Warning 1365 Division by 0
613 Warning 1365 Division by 0
614 Warning 1365 Division by 0
615 INSERT INTO t1 ( f1, f2, f3, f4 ) SELECT v1, v2, 10,10 FROM t1;
616 Warnings:
617 Warning 1365 Division by 0
618 Warning 1365 Division by 0
619 Warning 1365 Division by 0
620 Warning 1365 Division by 0
621 Warning 1365 Division by 0
622 Warning 1365 Division by 0
623 Warning 1365 Division by 0
624 Warning 1365 Division by 0
625 Warning 1365 Division by 0
626 Warning 1365 Division by 0
627 Warning 1365 Division by 0
628 Warning 1365 Division by 0
629 Warning 1365 Division by 0
630 Warning 1365 Division by 0
631 Warning 1048 Column 'f2' cannot be null
632 Warning 1365 Division by 0
633 Warning 1048 Column 'f2' cannot be null
634 Warning 1365 Division by 0
635 Warning 1048 Column 'f2' cannot be null
636 Warning 1365 Division by 0
637 Warning 1048 Column 'f2' cannot be null
638 Warning 1365 Division by 0
639 Warning 1048 Column 'f2' cannot be null
640 Warning 1365 Division by 0
641 Warning 1048 Column 'f2' cannot be null
642 Warning 1365 Division by 0
643 Warning 1048 Column 'f2' cannot be null
644 Warning 1365 Division by 0
645 Warning 1048 Column 'f2' cannot be null
646 Warning 1365 Division by 0
647 UPDATE t1 SET f3 = v1 WHERE f2 = 2 AND v2 is null;
648 Warnings:
649 Warning 1365 Division by 0
650 Warning 1365 Division by 0
651 Warning 1365 Division by 0
652 Warning 1365 Division by 0
653 Warning 1365 Division by 0
654 Warning 1365 Division by 0
655 Warning 1365 Division by 0
656 Warning 1365 Division by 0
657 Warning 1365 Division by 0
658 Warning 1365 Division by 0
659 Warning 1365 Division by 0
660 Warning 1365 Division by 0
661 Warning 1365 Division by 0
662 Warning 1365 Division by 0
663 Warning 1365 Division by 0
664 Warning 1365 Division by 0
665 Warning 1365 Division by 0
666 Warning 1365 Division by 0
667 Warning 1365 Division by 0
668 Warning 1365 Division by 0
669 Warning 1365 Division by 0
670 Warning 1365 Division by 0
671 Warning 1365 Division by 0
672 Warning 1365 Division by 0
673 drop table t1;
674 set sql_mode=@@global.sql_mode;