Debian Codegraph @

mysql-test/suite/gcol/r/gcol_rollback.result

raw
1 CREATE TABLE t (
2 a INTEGER,
3 b BLOB GENERATED ALWAYS AS (a) VIRTUAL,
4 INDEX (b(57))
5 )ENGINE=INNODB;
6 INSERT INTO t (a) VALUES (9);
7 BEGIN;
8 SAVEPOINT a;
9 UPDATE t set a = 12;
10 DELETE FROM t where a = 12;
11 ROLLBACK TO SAVEPOINT a;
12 COMMIT;
13 CHECK TABLE t;
14 Table Op Msg_type Msg_text
15 test.t check status OK
16 SELECT * FROM t;
17 a b
18 9 9
19 BEGIN;
20 INSERT INTO t (a) VALUES (10);
21 # Kill and restart
22 SELECT * FROM t;
23 a b
24 9 9
25 DROP TABLE t;
26 CREATE TABLE t (
27 a INTEGER,
28 b BLOB GENERATED ALWAYS AS (a) VIRTUAL,
29 c INTEGER
30 )ENGINE=INNODB;
31 INSERT INTO t (a,c) VALUES (9, 10);
32 SELECT * FROM t;
33 a b c
34 9 9 10
35 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
36 ALTER TABLE t ADD KEY(b(57)), ALGORITHM=INPLACE;
37 SET DEBUG_SYNC = 'now WAIT_FOR created';
38 BEGIN;
39 INSERT INTO t (a,c) VALUES (10, 12);
40 SELECT * FROM t;
41 a b c
42 9 9 10
43 10 10 12
44 ROLLBACK;
45 SET DEBUG_SYNC = 'now SIGNAL dml_done';
46 SELECT * FROM t;
47 a b c
48 9 9 10
49 DROP TABLE t;
50 CREATE TABLE t (
51 a INT,
52 b INT,
53 c INT GENERATED ALWAYS AS(a+b),
54 d INT GENERATED ALWAYS AS(a+b+b),
55 KEY(c, d)
56 )ENGINE=INNODB;
57 INSERT INTO t (a,b) VALUES (9, 10);
58 SELECT * FROM t;
59 a b c d
60 9 10 19 29
61 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
62 ALTER TABLE t DROP COLUMN c, ALGORITHM=INPLACE;
63 SET DEBUG_SYNC = 'now WAIT_FOR created';
64 BEGIN;
65 INSERT INTO t (a,b) VALUES (10, 12);
66 SELECT * FROM t;
67 a b c d
68 9 10 19 29
69 10 12 22 34
70 ROLLBACK;
71 SET DEBUG_SYNC = 'now SIGNAL dml_done';
72 SELECT * FROM t;
73 a b d
74 9 10 29
75 DROP TABLE t;