Debian Codegraph @

mysql-test/suite/gcol/t/gcol_rollback.test

raw
1 --source include/have_debug.inc
2 --source include/have_innodb.inc
3 --source include/have_debug_sync.inc
4 --source include/not_embedded.inc
5
6 # Save the initial number of concurrent sessions.
7 --source include/count_sessions.inc
8
9 # Make sure there are no unexpected open tables from previous tests
10 --disable_query_log
11 FLUSH TABLES;
12 --enable_query_log
13
14 CREATE TABLE t (
15 a INTEGER,
16 b BLOB GENERATED ALWAYS AS (a) VIRTUAL,
17 INDEX (b(57))
18 )ENGINE=INNODB;
19
20 INSERT INTO t (a) VALUES (9);
21 BEGIN;
22 SAVEPOINT a;
23 UPDATE t set a = 12;
24 DELETE FROM t where a = 12;
25 ROLLBACK TO SAVEPOINT a;
26 COMMIT;
27
28 CHECK TABLE t;
29
30 SELECT * FROM t;
31
32 BEGIN;
33 INSERT INTO t (a) VALUES (10);
34 --let $shutdown_timeout= 0
35 --source include/restart_mysqld.inc
36 SELECT * FROM t;
37 DROP TABLE t;
38
39 CREATE TABLE t (
40 a INTEGER,
41 b BLOB GENERATED ALWAYS AS (a) VIRTUAL,
42 c INTEGER
43 )ENGINE=INNODB;
44
45 INSERT INTO t (a,c) VALUES (9, 10);
46 SELECT * FROM t;
47
48 connect (con1,localhost,root,,);
49 connection con1;
50
51 # This DEBUG_SYNC should not kick in yet, because the duplicate key will be
52 # detected before we get a chance to apply the online log.
53
54 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
55 --send
56 ALTER TABLE t ADD KEY(b(57)), ALGORITHM=INPLACE;
57
58 connection default;
59 SET DEBUG_SYNC = 'now WAIT_FOR created';
60 BEGIN;
61 INSERT INTO t (a,c) VALUES (10, 12);
62 SELECT * FROM t;
63 ROLLBACK;
64 SET DEBUG_SYNC = 'now SIGNAL dml_done';
65
66 connection con1;
67 reap;
68 disconnect con1;
69 connection default;
70
71 SELECT * FROM t;
72 DROP TABLE t;
73
74 # drop virtual column and alter index
75 CREATE TABLE t (
76 a INT,
77 b INT,
78 c INT GENERATED ALWAYS AS(a+b),
79 d INT GENERATED ALWAYS AS(a+b+b),
80 KEY(c, d)
81 )ENGINE=INNODB;
82
83 INSERT INTO t (a,b) VALUES (9, 10);
84 SELECT * FROM t;
85
86 connect (con1,localhost,root,,);
87 connection con1;
88
89 # This DEBUG_SYNC should not kick in yet, because the duplicate key will be
90 # detected before we get a chance to apply the online log.
91
92 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL created WAIT_FOR dml_done';
93 --send
94 ALTER TABLE t DROP COLUMN c, ALGORITHM=INPLACE;
95
96 connection default;
97 SET DEBUG_SYNC = 'now WAIT_FOR created';
98 BEGIN;
99 INSERT INTO t (a,b) VALUES (10, 12);
100 SELECT * FROM t;
101 ROLLBACK;
102 SET DEBUG_SYNC = 'now SIGNAL dml_done';
103
104 connection con1;
105 reap;
106 connection default;
107
108 SELECT * FROM t;
109
110 DROP TABLE t;
111 SET DEBUG_SYNC = 'RESET';
112
113 --echo #
114 --echo # MDEV-30597 Assertion `flag == 1' failed in
115 --echo # row_build_index_entry_low
116 --echo #
117 CREATE TABLE t1 (
118 col1 INT PRIMARY KEY, col_text TEXT,
119 col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499))
120 ) ENGINE = InnoDB ROW_FORMAT = Compact;
121 connection con1;
122 START TRANSACTION WITH CONSISTENT SNAPSHOT;
123 connection default;
124 INSERT INTO t1 (col1) VALUES (1) ;
125 DELETE FROM t1 WHERE col1 = 1;
126 ALTER TABLE t1 ADD UNIQUE INDEX (col_text_g(9));
127 BEGIN;
128 INSERT INTO t1 (col1) VALUES (1);
129 ROLLBACK;
130 disconnect con1;
131 DROP TABLE t1;
132
133 # Wait till all disconnects are completed
134 --source include/wait_until_count_sessions.inc
135
136 --echo # End of 10.4 tests