Debian Codegraph @

mysql-test/suite/storage_engine/update_multi.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 t1, t2 SET t1.a = t2.d+100, t2.c = 'multi' WHERE c < b AND a + d != 1;
8 SELECT a,b FROM t1;
9 a b
10 1 a
11 1 a
12 101 b
13 101 b
14 101 c
15 101 c
16 101 d
17 101 d
18 101 e
19 101 e
20 101 foobar
21 101 foobar
22 SELECT c,d FROM t2;
23 c d
24 foobar 10000
25 foobar 10000
26 multi 1
27 multi 1
28 multi 2
29 multi 2
30 multi 3
31 multi 3
32 multi 4
33 multi 4
34 multi 5
35 multi 5
36 UPDATE t2, t1 SET t2.d = DEFAULT WHERE c = 'foobar' and b = c;
37 SELECT a,b FROM t1;
38 a b
39 1 a
40 1 a
41 101 b
42 101 b
43 101 c
44 101 c
45 101 d
46 101 d
47 101 e
48 101 e
49 101 foobar
50 101 foobar
51 SELECT c,d FROM t2;
52 c d
53 foobar NULL
54 foobar NULL
55 multi 1
56 multi 1
57 multi 2
58 multi 2
59 multi 3
60 multi 3
61 multi 4
62 multi 4
63 multi 5
64 multi 5
65 DROP TABLE t1, t2;