Debian Codegraph @

mysql-test/suite/storage_engine/update.result

raw
1 DROP TABLE IF EXISTS t1;
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 UPDATE t1 SET a=a+100;
6 SELECT a,b FROM t1;
7 a b
8 101 a
9 101 a
10 10100 foobar
11 10100 foobar
12 102 b
13 102 b
14 103 c
15 103 c
16 104 d
17 104 d
18 105 e
19 105 e
20 UPDATE t1 SET a=a-100, b=DEFAULT WHERE a>100;
21 SELECT a,b FROM t1;
22 a b
23 1 NULL
24 1 NULL
25 10000 NULL
26 10000 NULL
27 2 NULL
28 2 NULL
29 3 NULL
30 3 NULL
31 4 NULL
32 4 NULL
33 5 NULL
34 5 NULL
35 UPDATE t1 SET b = 'update' WHERE a <= 4 ORDER BY b DESC, a ASC LIMIT 1;
36 SELECT a,b FROM t1;
37 a b
38 1 NULL
39 1 update
40 10000 NULL
41 10000 NULL
42 2 NULL
43 2 NULL
44 3 NULL
45 3 NULL
46 4 NULL
47 4 NULL
48 5 NULL
49 5 NULL
50 DROP TABLE t1;