Debian Codegraph @

mysql-test/suite/storage_engine/delete_ignore.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (10000,'foobar'),(1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
4 INSERT INTO t1 (a,b) SELECT a, b FROM t1;
5 CREATE TABLE t2 (c <CHAR_COLUMN>, d <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 INSERT INTO t2 (c,d) SELECT b, a FROM t1;
7 SELECT a,b FROM t1;
8 a b
9 1 a
10 1 a
11 10000 foobar
12 10000 foobar
13 2 b
14 2 b
15 3 c
16 3 c
17 4 d
18 4 d
19 5 e
20 5 e
21 SELECT c,d FROM t2;
22 c d
23 a 1
24 a 1
25 b 2
26 b 2
27 c 3
28 c 3
29 d 4
30 d 4
31 e 5
32 e 5
33 foobar 10000
34 foobar 10000
35 DELETE IGNORE FROM t1 WHERE b IS NOT NULL ORDER BY a LIMIT 1;
36 SELECT a,b FROM t1;
37 a b
38 1 a
39 10000 foobar
40 10000 foobar
41 2 b
42 2 b
43 3 c
44 3 c
45 4 d
46 4 d
47 5 e
48 5 e
49 DELETE IGNORE t1.*, t2.* FROM t1, t2 WHERE c < b OR a != ( SELECT 1 UNION SELECT 2 );
50 Warnings:
51 Warning 1242 Subquery returns more than 1 row
52 SELECT a,b FROM t1;
53 a b
54 1 a
55 SELECT c,d FROM t2;
56 c d
57 foobar 10000
58 foobar 10000
59 DROP TABLE t1, t2;