Debian Codegraph @

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

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