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 # 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 connect con1,localhost,root,,;
36 connection con1;
37 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
38 ALTER TABLE t ADD KEY(b(57)), ALGORITHM=INPLACE;
39 connection default;
40 SET DEBUG_SYNC = 'now WAIT_FOR created';
41 BEGIN;
42 INSERT INTO t (a,c) VALUES (10, 12);
43 SELECT * FROM t;
44 a b c
45 9 9 10
46 10 10 12
47 ROLLBACK;
48 SET DEBUG_SYNC = 'now SIGNAL dml_done';
49 connection con1;
50 disconnect con1;
51 connection default;
52 SELECT * FROM t;
53 a b c
54 9 9 10
55 DROP TABLE t;
56 CREATE TABLE t (
57 a INT,
58 b INT,
59 c INT GENERATED ALWAYS AS(a+b),
60 d INT GENERATED ALWAYS AS(a+b+b),
61 KEY(c, d)
62 )ENGINE=INNODB;
63 INSERT INTO t (a,b) VALUES (9, 10);
64 SELECT * FROM t;
65 a b c d
66 9 10 19 29
67 connect con1,localhost,root,,;
68 connection con1;
69 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
70 ALTER TABLE t DROP COLUMN c, ALGORITHM=INPLACE;
71 connection default;
72 SET DEBUG_SYNC = 'now WAIT_FOR created';
73 BEGIN;
74 INSERT INTO t (a,b) VALUES (10, 12);
75 SELECT * FROM t;
76 a b c d
77 9 10 19 29
78 10 12 22 34
79 ROLLBACK;
80 SET DEBUG_SYNC = 'now SIGNAL dml_done';
81 connection con1;
82 connection default;
83 SELECT * FROM t;
84 a b d
85 9 10 29
86 DROP TABLE t;
87 SET DEBUG_SYNC = 'RESET';
88 #
89 # MDEV-30597 Assertion `flag == 1' failed in
90 # row_build_index_entry_low
91 #
92 CREATE TABLE t1 (
93 col1 INT PRIMARY KEY, col_text TEXT,
94 col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499))
95 ) ENGINE = InnoDB ROW_FORMAT = Compact;
96 connection con1;
97 START TRANSACTION WITH CONSISTENT SNAPSHOT;
98 connection default;
99 INSERT INTO t1 (col1) VALUES (1) ;
100 DELETE FROM t1 WHERE col1 = 1;
101 ALTER TABLE t1 ADD UNIQUE INDEX (col_text_g(9));
102 BEGIN;
103 INSERT INTO t1 (col1) VALUES (1);
104 ROLLBACK;
105 disconnect con1;
106 DROP TABLE t1;
107 # End of 10.4 tests