Debian Codegraph @

mysql-test/suite/innodb/t/innodb_update_rollback_gen_col.test

raw
1 #
2 # Bug 32529561 - CRASH IF ROLLBACK A TRANSACTION THAT MODIFIES GENERATED AND INDEXED COLUMN
3 #
4
5 # We are only interested in validating that the following commands do not crash the server
6
7 # Test with virtual generated columns
8
9 CREATE TABLE bug32529561_v (
10 `longstr` blob NOT NULL,
11 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
12 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
13 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
14 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
15 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
16 KEY `key_5` (`gen_5`)
17 );
18
19 insert into bug32529561_v (longstr) values ('123');
20
21 select * from bug32529561_v;
22 begin;
23 update bug32529561_v set longstr = concat('456', repeat('a', 9000));
24 rollback;
25 select * from bug32529561_v;
26
27 # Test with stored generated columns
28
29 CREATE TABLE bug32529561_s (
30 `longstr` blob NOT NULL,
31 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
32 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
33 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
34 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
35 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
36 KEY `key_5` (`gen_5`)
37 );
38
39 insert into bug32529561_s (longstr) values ('123');
40 select * from bug32529561_s;
41 begin;
42 update bug32529561_s set longstr = concat('456', repeat('a', 9000));
43 rollback;
44 select * from bug32529561_s;
45
46 # Test with mixed generated columns
47
48 CREATE TABLE bug32529561_m (
49 `longstr` blob NOT NULL,
50 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
51 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
52 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
53 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
54 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
55 KEY `key_5` (`gen_5`)
56 );
57
58 insert into bug32529561_m (longstr) values ('123');
59 select * from bug32529561_m;
60 begin;
61 update bug32529561_m set longstr = concat('456', repeat('a', 9000));
62 rollback;
63 select * from bug32529561_m;
64
65 # Cleanup
66 DROP TABLE bug32529561_v;
67 DROP TABLE bug32529561_s;
68 DROP TABLE bug32529561_m;