Debian Codegraph @

mysql-test/suite/compat/oracle/t/mysqldump_restore.test

raw
1 # See comments in mysql-test/main/mysqldump_restore.test
2 --source include/not_embedded.inc
3
4 SET sql_mode=ORACLE;
5
6 let $mysqldumpfile = $MYSQLTEST_VARDIR/tmp/mysqldumpfile.sql;
7
8 --echo #
9 --echo # Start of 10.3 tests
10 --echo #
11
12 --echo #
13 --echo # MDEV-17363 Compressed columns cannot be restored from dump
14 --echo #
15
16 CREATE TABLE t1 (a VARCHAR(1000) COMPRESSED CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL);
17 INSERT INTO `t1` VALUES (REPEAT('a', 256));
18 --exec $MYSQL_DUMP --skip-extended-insert test --skip-comments t1 > $mysqldumpfile
19 let $table_name = test.t1;
20 --source include/mysqldump.inc
21
22 CREATE TABLE t1 (a LONGTEXT COMPRESSED CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL);
23 INSERT INTO `t1` VALUES (REPEAT('a', 256));
24 --exec $MYSQL_DUMP --skip-extended-insert test --skip-comments t1 > $mysqldumpfile
25 let $table_name = test.t1;
26 --source include/mysqldump.inc
27
28 --echo #
29 --echo # End of 10.3 tests
30 --echo #