Debian Codegraph @

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

raw
1 CREATE DATABASE dump_generated;
2 USE dump_generated;
3 CREATE TABLE t1 (pk INTEGER, a INTEGER, b INTEGER, c VARCHAR(16),
4 sum INTEGER GENERATED ALWAYS AS (a+b),
5 sub VARCHAR(4) GENERATED ALWAYS AS (SUBSTRING(c, 1, 4)),
6 key k1(sum),
7 key k2(sub)
8 ) engine=innodb;
9 INSERT INTO t1(pk, a, b, c) VALUES (1, 11, 12, 'oneone'), (2, 21, 22, 'twotwo');
10 SELECT * FROM t1;
11 pk a b c sum sub
12 1 11 12 oneone 23 oneo
13 2 21 22 twotwo 43 twot
14 DELETE FROM t1;
15 SELECT * FROM t1;
16 pk a b c sum sub
17 1 11 12 oneone 23 oneo
18 2 21 22 twotwo 43 twot
19 DELETE FROM t1;
20 LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t1.txt' INTO TABLE t1;
21 SELECT * FROM t1;
22 pk a b c sum sub
23 1 11 12 oneone 23 oneo
24 2 21 22 twotwo 43 twot
25 DROP TABLE t1;
26 # A table with regular columns after generated
27 CREATE TABLE t2 (pk INTEGER, a INTEGER, b INTEGER,
28 sum INTEGER GENERATED ALWAYS AS (a+b),
29 c VARCHAR(16),
30 key k1(sum)
31 ) engine=innodb;
32 INSERT INTO t2(pk, a, b, c) VALUES (1, 11, 12, 'oneone'), (2, 21, 22, 'twotwo');
33 SELECT * FROM t2;
34 pk a b sum c
35 1 11 12 23 oneone
36 2 21 22 43 twotwo
37 DELETE FROM t2;
38 SELECT * FROM t2;
39 pk a b sum c
40 1 11 12 23 oneone
41 2 21 22 43 twotwo
42 DELETE FROM t2;
43 LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t2.txt' INTO TABLE t2;
44 SELECT * FROM t2;
45 pk a b sum c
46 1 11 12 23 oneone
47 2 21 22 43 twotwo
48 DROP TABLE t2;
49 DROP DATABASE dump_generated;