Debian Codegraph @

mysql-test/suite/binlog/r/binlog_transaction_write_set_savepoint_basic.result

raw
1 CREATE TABLE t1(a int primary key);
2 CREATE TABLE t2(a int primary key);
3 BEGIN;
4 #
5 # Insert values on table and savepoints
6 #
7 SAVEPOINT S1;
8 INSERT INTO t1 values(3);
9 INSERT INTO t1 values(4);
10 SAVEPOINT S2;
11 INSERT INTO t1 values(5);
12 INSERT INTO t1 values(6);
13 SAVEPOINT S3;
14 SAVEPOINT S4;
15 #
16 # RELEASE S4
17 #
18 RELEASE SAVEPOINT S4;
19 INSERT INTO t1 values(7);
20 SELECT * FROM t1;
21 a
22 3
23 4
24 5
25 6
26 7
27 #
28 # ROLLBACK TO S2
29 #
30 ROLLBACK TO S2;
31 #
32 # Confirm S3 was removed when rollbacking to S2
33 #
34 ROLLBACK TO S3;
35 ERROR 42000: SAVEPOINT S3 does not exist
36 SELECT * FROM t1;
37 a
38 3
39 4
40 INSERT INTO t1 values(7);
41 SELECT * FROM t1;
42 a
43 3
44 4
45 7
46 #
47 # Confirm S2 exists after ROLLBACK TO S2
48 #
49 ROLLBACK TO S2;
50 SELECT * FROM t1;
51 a
52 3
53 4
54 COMMIT;
55 #
56 # Check the multitable update on 'rollback to savepoint'
57 #
58 BEGIN;
59 INSERT INTO t1 values (5);
60 SAVEPOINT S1;
61 DELETE FROM t1;
62 INSERT INTO t1 values (1);
63 INSERT INTO t2 SELECT * FROM t1;
64 UPDATE t1,t2 SET t1.a=3, t2.a=3;
65 SELECT * FROM t1;
66 a
67 3
68 SELECT * FROM t2;
69 a
70 3
71 ROLLBACK TO SAVEPOINT S1;
72 INSERT INTO t2 SELECT * FROM t1;
73 COMMIT;
74 SELECT * FROM t1;
75 a
76 3
77 4
78 5
79 SELECT * FROM t2;
80 a
81 3
82 4
83 5
84 DROP TABLE t1;
85 DROP TABLE t2;