Debian Codegraph @

mysql-test/suite/sql_sequence/mysqldump.test

raw
1 #
2 # Testing mysqldump of sequences
3 #
4
5 # Embedded server doesn't support external clients
6 --source include/not_embedded.inc
7 --source include/have_aria.inc
8 --source include/have_innodb.inc
9
10 CREATE SEQUENCE a1 engine=aria;
11 CREATE TABLE t1(a INT, KEY (a)) KEY_BLOCK_SIZE=1024;
12 insert into t1 values (1),(2);
13 CREATE SEQUENCE x1 engine=innodb;
14 --echo # dump whole database
15 --exec $MYSQL_DUMP --no-autocommit=0 --compact test
16 --echo # dump by tables order 1
17 --exec $MYSQL_DUMP --no-autocommit=0 --compact --tables test t1 a1 x1
18 --echo # dump by tables order 2
19 --exec $MYSQL_DUMP --no-autocommit=0 --compact --tables test a1 t1 x1
20 --echo # dump by tables only tables
21 --exec $MYSQL_DUMP --no-autocommit=0 --compact --tables test t1
22 --echo # dump by tables only sequences
23 --exec $MYSQL_DUMP --no-autocommit=0 --compact --tables test a1 x1
24 --echo # end of dumps
25
26 DROP TABLE a1,t1,x1;
27
28 #
29 # MDEV-12887 UT_LIST_GET_LEN(trx->lock.trx_locks) == 0 when mysqldump sequence
30 #
31
32 set default_storage_engine=InnoDB;
33 create sequence t1;
34 LOCK TABLES t1 READ;
35 SELECT * FROM t1;
36 unlock tables;
37 drop table t1;
38
39
40 --echo #
41 --echo # MDEV-28152 Features for sequence
42 --echo #
43
44 CREATE DATABASE test1;
45 CREATE DATABASE test2;
46 USE test1;
47 CREATE SEQUENCE s1 as tinyint;
48 CREATE SEQUENCE s2 as smallint;
49 CREATE SEQUENCE s3 as mediumint;
50 CREATE SEQUENCE s4 as int;
51 CREATE SEQUENCE s5 as bigint;
52 CREATE SEQUENCE s6 as tinyint unsigned;
53 CREATE SEQUENCE s7 as smallint unsigned;
54 CREATE SEQUENCE s8 as mediumint unsigned;
55 CREATE SEQUENCE s9 as int unsigned;
56 CREATE SEQUENCE s10 as bigint unsigned;
57
58 --echo # Dump database 1
59 --exec $MYSQL_DUMP test1 > $MYSQLTEST_VARDIR/tmp/dumptest1.sql
60 --echo # Restore from database 1 to database 2
61
62 --exec $MYSQL test2 < $MYSQLTEST_VARDIR/tmp/dumptest1.sql
63 USE test2;
64 SHOW CREATE SEQUENCE s1;
65 SHOW CREATE SEQUENCE s2;
66 SHOW CREATE SEQUENCE s3;
67 SHOW CREATE SEQUENCE s4;
68 SHOW CREATE SEQUENCE s5;
69 SHOW CREATE SEQUENCE s6;
70 SHOW CREATE SEQUENCE s7;
71 SHOW CREATE SEQUENCE s8;
72 SHOW CREATE SEQUENCE s9;
73 SHOW CREATE SEQUENCE s10;
74
75 --remove_file $MYSQLTEST_VARDIR/tmp/dumptest1.sql
76 DROP DATABASE test1;
77 DROP DATABASE test2;
78
79 --echo ## test ORACLE mode
80 set sql_mode=ORACLE;
81
82 CREATE DATABASE test1;
83 CREATE DATABASE test2;
84 USE test1;
85 CREATE SEQUENCE s1 as tinyint;
86 CREATE SEQUENCE s2 as smallint;
87 CREATE SEQUENCE s3 as mediumint;
88 CREATE SEQUENCE s4 as int;
89 CREATE SEQUENCE s5 as bigint;
90 CREATE SEQUENCE s6 as tinyint unsigned;
91 CREATE SEQUENCE s7 as smallint unsigned;
92 CREATE SEQUENCE s8 as mediumint unsigned;
93 CREATE SEQUENCE s9 as int unsigned;
94 CREATE SEQUENCE s10 as bigint unsigned;
95
96 --echo # Dump database 1
97 --exec $MYSQL_DUMP test1 > $MYSQLTEST_VARDIR/tmp/dumptest1.sql
98 --echo # Restore from database 1 to database 2
99
100 --exec $MYSQL test2 < $MYSQLTEST_VARDIR/tmp/dumptest1.sql
101 USE test2;
102 SHOW CREATE SEQUENCE s1;
103 SHOW CREATE SEQUENCE s2;
104 SHOW CREATE SEQUENCE s3;
105 SHOW CREATE SEQUENCE s4;
106 SHOW CREATE SEQUENCE s5;
107 SHOW CREATE SEQUENCE s6;
108 SHOW CREATE SEQUENCE s7;
109 SHOW CREATE SEQUENCE s8;
110 SHOW CREATE SEQUENCE s9;
111 SHOW CREATE SEQUENCE s10;
112
113 --remove_file $MYSQLTEST_VARDIR/tmp/dumptest1.sql
114 DROP DATABASE test1;
115 DROP DATABASE test2;
116
117 set sql_mode=default;
118
119 --echo #
120 --echo # End of 11.5 tests
121 --echo #