diff options
author | Jim Winstead <jimw@mysql.com> | 2009-07-14 10:08:38 -0700 |
---|---|---|
committer | Jim Winstead <jimw@mysql.com> | 2009-07-14 10:08:38 -0700 |
commit | bd0a44fba279633bbbe19c904103ea06644061bb (patch) | |
tree | 621df211e8838b5cbacf88d7e41019a2401d4f4f /mysql-test/t/mysqldump.test | |
parent | 5b178e9a2af23226828f9c71fa6b1b82db319a9e (diff) | |
parent | f8e24020847fe98660c15b03258d3a4f6453d819 (diff) | |
download | mariadb-git-bd0a44fba279633bbbe19c904103ea06644061bb.tar.gz |
Merge in bug fixes for client tools
Diffstat (limited to 'mysql-test/t/mysqldump.test')
-rw-r--r-- | mysql-test/t/mysqldump.test | 46 |
1 files changed, 44 insertions, 2 deletions
diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index ec96124e14b..f941cf21c19 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -1947,8 +1947,50 @@ DROP DATABASE mysqldump_test_db; --echo # -- End of test case for Bug#32538. --echo -# We reset concurrent_inserts value to whatever it was at the start of the test -# This line must be executed _after_ all test cases. +--echo # +--echo # Bug#37377 Incorrect DROP TABLE statement in dump of a VIEW using --tab +--echo # + +create table t1 (a int); +create view v1 as select a from t1; + +--exec $MYSQL_DUMP --skip-comments --tab=$MYSQLTEST_VARDIR/tmp/ test t1 v1 + +drop view v1; +drop table t1; + +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/t1.sql +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/v1.sql + +drop view v1; +drop table t1; + +--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql +--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt +--remove_file $MYSQLTEST_VARDIR/tmp/v1.sql + + +--echo # +--echo # Bug#28071 mysqlimport does not quote or escape table name +--echo # + +--disable_warnings +drop table if exists `load`; +--enable_warnings +create table `load` (a varchar(255)); + +--copy_file std_data/words.dat $MYSQLTEST_VARDIR/tmp/load.txt + +--exec $MYSQL_IMPORT --ignore test $MYSQLTEST_VARDIR/tmp/load.txt + +select count(*) from `load`; + +--remove_file $MYSQLTEST_VARDIR/tmp/load.txt + +drop table `load`; + +# We reset concurrent_inserts value to whatever it was at the start of the +# test This line must be executed _after_ all test cases. SET @@GLOBAL.CONCURRENT_INSERT = @OLD_CONCURRENT_INSERT; |