diff options
Diffstat (limited to 'mysql-test/t/mysqldump.test')
| -rw-r--r-- | mysql-test/t/mysqldump.test | 65 |
1 files changed, 61 insertions, 4 deletions
diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index 708ed25f89c..87091d549d1 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -1,5 +1,6 @@ call mtr.add_suppression("@003f.frm' \\(errno: 22\\)"); - +#select * from mysql.user; +#checksum table mysql.user; # Embedded server doesn't support external clients --source include/not_embedded.inc @@ -139,7 +140,7 @@ create table t1(a int); set global sql_mode='ANSI_QUOTES'; --exec $MYSQL_DUMP --comments=0 test --exec $MYSQL_DUMP --comments=0 --compatible=ansi test -set global sql_mode=''; +set global sql_mode=default; drop table t1; --echo # @@ -1074,7 +1075,7 @@ drop table t1; drop table if exists t1; --enable_warnings -create table t1 (`d` timestamp, unique (`d`)); +create table t1 (`d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, unique (`d`)); set time_zone='+00:00'; insert into t1 values ('2003-10-25 22:00:00'),('2003-10-25 23:00:00'); # results should show two different time values @@ -2482,6 +2483,7 @@ SELECT * FROM t2; DROP TABLE t1; DROP TABLE t2; DROP DATABASE db_20772273; +USE test; # # MDEV-6091 mysqldump goes in a loop and segfaults if --dump-slave is specified and it cannot connect to the server @@ -2497,7 +2499,6 @@ DROP DATABASE db_20772273; --exec $MYSQL_DUMP --user=foo 2>&1 > $MYSQLTEST_VARDIR/tmp/bug6056.out --exec $MYSQL_DUMP --help > $MYSQLTEST_VARDIR/tmp/bug6056.out - --echo # --echo # MDEV-9001 - [PATCH] Fix DB name quoting in mysqldump --routine --echo # @@ -2514,6 +2515,62 @@ if (`select convert(@@version_compile_os using latin1) IN ("Win32","Win64","Wind DROP DATABASE `a\"'``b`; #" +use test; + +--echo # +--echo # Test mysqldump with --disable-query-logs +--echo # + +create table t1 (a int); +insert into t1 values (1); + +--exec $MYSQL_DUMP --hex-blob --character-sets-dir=$MYSQL_SHAREDIR/charsets --tab=$MYSQLTEST_VARDIR/tmp/ test t1 +--exec $MYSQL_DUMP --disable-log-queries --skip-comments test t1 >$MYSQLTEST_VARDIR/tmp/mysqldump-test.out +drop table t1; + +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/mysqldump-test.out +select * from t1; +drop table t1; +--remove_file $MYSQLTEST_VARDIR/tmp/mysqldump-test.out +#select * from mysql.user; +#checksum table mysql.user; + +--echo # +--echo # MDEV-9124 mysqldump does not dump data if table name is same as view earlier on +--echo # + +CREATE DATABASE db1 CHARSET=utf8; +CREATE DATABASE db2 CHARSET=utf8; +USE db2; +CREATE TABLE nonunique_table_name (i1 serial) ENGINE=MEMORY; +INSERT INTO nonunique_table_name VALUES (1),(2); +CREATE TABLE nonunique_table_view_name (i2 int) ENGINE=InnoDB; +INSERT INTO nonunique_table_view_name VALUES (3),(4); +use db1; +CREATE TABLE basetable (id smallint) ENGINE=MyISAM; +CREATE TABLE nonunique_table_name (i3 smallint) ENGINE=MERGE UNION (basetable) INSERT_METHOD=LAST; +INSERT INTO nonunique_table_name VALUES (5),(6); +CREATE VIEW nonunique_table_view_name AS SELECT 1; + +--echo +--echo ################################################## +--echo # --compact --databases db1 db2 +--exec $MYSQL_DUMP --compact --databases db1 db2 +--echo +--echo ################################################## +--echo # --compact db2 +--echo +--exec $MYSQL_DUMP --compact db2 +--echo +--echo ################################################## +--echo # --compact --delayed-insert --no-data-med=0 --databases db2 db1 +--exec $MYSQL_DUMP --compact --delayed-insert --no-data-med=0 --databases db2 db1 +--echo + +DROP DATABASE db1; +DROP DATABASE db2; + +#" # MDEV-11505 wrong databasename in mysqldump comment # let SEARCH_FILE=$MYSQLTEST_VARDIR/tmp/bug11505.sql; |