Debian Codegraph @

mysql-test/suite/storage_engine/trx/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 BEGIN;
6 UPDATE t1 SET a=a+100;
7 UPDATE t1 SET a=a-50, b=DEFAULT WHERE a>100;
8 COMMIT;
9 SELECT a,b FROM t1;
10 a b
11 10050 NULL
12 10050 NULL
13 51 NULL
14 51 NULL
15 52 NULL
16 52 NULL
17 53 NULL
18 53 NULL
19 54 NULL
20 54 NULL
21 55 NULL
22 55 NULL
23 BEGIN;
24 UPDATE t1 SET b = 'update' WHERE a <= 4 ORDER BY a DESC, b ASC LIMIT 3;
25 UPDATE t1 SET b = '';
26 ROLLBACK;
27 BEGIN;
28 UPDATE t1 SET b = 'update2' WHERE a <= 100;
29 SAVEPOINT spt1;
30 UPDATE t1 SET b = '';
31 ROLLBACK TO SAVEPOINT spt1;
32 UPDATE t1 SET b = 'upd' WHERE a = 10050;
33 COMMIT;
34 SELECT a,b FROM t1;
35 a b
36 10050 upd
37 10050 upd
38 51 update2
39 51 update2
40 52 update2
41 52 update2
42 53 update2
43 53 update2
44 54 update2
45 54 update2
46 55 update2
47 55 update2
48 DROP TABLE t1;