summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysqldump.test
diff options
context:
space:
mode:
authorJim Winstead <jimw@mysql.com>2009-05-19 15:26:57 -0700
committerJim Winstead <jimw@mysql.com>2009-05-19 15:26:57 -0700
commit1c9e45c3c4904e1e81132f7c87e3abbf7d50c506 (patch)
tree46c72146dc02874535a5528e4fa92ed780b07912 /mysql-test/t/mysqldump.test
parent86dc69e04591127f2ca2cbae24d57dc1615037de (diff)
downloadmariadb-git-1c9e45c3c4904e1e81132f7c87e3abbf7d50c506.tar.gz
Table identifiers and file names were not quoted and escaped correctly by
mysqlimport. (Bug #28071)
Diffstat (limited to 'mysql-test/t/mysqldump.test')
-rw-r--r--mysql-test/t/mysqldump.test23
1 files changed, 21 insertions, 2 deletions
diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test
index 6fc8d7bdfea..2ac22fd72ce 100644
--- a/mysql-test/t/mysqldump.test
+++ b/mysql-test/t/mysqldump.test
@@ -1971,8 +1971,27 @@ drop table t1;
--remove_file $MYSQLTEST_VARDIR/tmp/v1.sql
-# 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#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;