Debian Codegraph @

mysql-test/suite/storage_engine/update_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 (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(10000,'foobar');
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 UPDATE IGNORE t1 SET b = 'upd1' WHERE b IS NOT NULL ORDER BY a LIMIT 1;
8 SELECT a,b FROM t1;
9 a b
10 1 a
11 1 upd1
12 10000 foobar
13 10000 foobar
14 2 b
15 2 b
16 3 c
17 3 c
18 4 d
19 4 d
20 5 e
21 5 e
22 UPDATE IGNORE t1, t2 SET b = 'upd2a', c = 'upd2b'
23 WHERE c < b OR a != ( SELECT 1 UNION SELECT 2 );
24 Warnings:
25 Warning 1242 Subquery returns more than 1 row
26 SELECT a,b FROM t1;
27 a b
28 1 a
29 1 upd2a
30 10000 upd2a
31 10000 upd2a
32 2 upd2a
33 2 upd2a
34 3 upd2a
35 3 upd2a
36 4 upd2a
37 4 upd2a
38 5 upd2a
39 5 upd2a
40 SELECT c,d FROM t2;
41 c d
42 upd2b 1
43 upd2b 1
44 upd2b 10000
45 upd2b 10000
46 upd2b 2
47 upd2b 2
48 upd2b 3
49 upd2b 3
50 upd2b 4
51 upd2b 4
52 upd2b 5
53 upd2b 5
54 DROP TABLE t1, t2;