Debian Codegraph @

mysql-test/suite/innodb/r/innodb_update_rollback_gen_col.result

raw
1 CREATE TABLE bug32529561_v (
2 `longstr` blob NOT NULL,
3 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
4 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
5 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
6 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
7 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
8 KEY `key_5` (`gen_5`)
9 );
10 insert into bug32529561_v (longstr) values ('123');
11 select * from bug32529561_v;
12 longstr gen_1 gen_2 gen_3 gen_4 gen_5
13 123 123 123 123 123 123
14 begin;
15 update bug32529561_v set longstr = concat('456', repeat('a', 9000));
16 rollback;
17 select * from bug32529561_v;
18 longstr gen_1 gen_2 gen_3 gen_4 gen_5
19 123 123 123 123 123 123
20 CREATE TABLE bug32529561_s (
21 `longstr` blob NOT NULL,
22 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
23 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
24 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
25 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
26 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
27 KEY `key_5` (`gen_5`)
28 );
29 insert into bug32529561_s (longstr) values ('123');
30 select * from bug32529561_s;
31 longstr gen_1 gen_2 gen_3 gen_4 gen_5
32 123 123 123 123 123 123
33 begin;
34 update bug32529561_s set longstr = concat('456', repeat('a', 9000));
35 rollback;
36 select * from bug32529561_s;
37 longstr gen_1 gen_2 gen_3 gen_4 gen_5
38 123 123 123 123 123 123
39 CREATE TABLE bug32529561_m (
40 `longstr` blob NOT NULL,
41 `gen_1` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
42 `gen_2` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
43 `gen_3` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
44 `gen_4` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)),
45 `gen_5` varchar(3) GENERATED ALWAYS AS (left(`longstr`, 3)) stored,
46 KEY `key_5` (`gen_5`)
47 );
48 insert into bug32529561_m (longstr) values ('123');
49 select * from bug32529561_m;
50 longstr gen_1 gen_2 gen_3 gen_4 gen_5
51 123 123 123 123 123 123
52 begin;
53 update bug32529561_m set longstr = concat('456', repeat('a', 9000));
54 rollback;
55 select * from bug32529561_m;
56 longstr gen_1 gen_2 gen_3 gen_4 gen_5
57 123 123 123 123 123 123
58 DROP TABLE bug32529561_v;
59 DROP TABLE bug32529561_s;
60 DROP TABLE bug32529561_m;