summaryrefslogtreecommitdiff
path: root/mysql-test/t/backup.test
diff options
context:
space:
mode:
authorunknown <pgalbraith/patg@govinda.patg.net>2006-08-10 15:31:44 -0700
committerunknown <pgalbraith/patg@govinda.patg.net>2006-08-10 15:31:44 -0700
commit2f48a59124c776c36ea6609f31543bf6c5f8ed86 (patch)
tree5987f5e501d310cf789abacf27d2a98227232630 /mysql-test/t/backup.test
parenteef51cd83d952b786def92fccde44b41a007c989 (diff)
parentfab1b2f5be37d043ac21ccb679d527ed0595c4dc (diff)
downloadmariadb-git-2f48a59124c776c36ea6609f31543bf6c5f8ed86.tar.gz
Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime
into govinda.patg.net:/home/patg/mysql-build/mysql-5.1-engines-merge sql/mysql_priv.h: Auto merged sql/sql_base.cc: Auto merged sql/sql_yacc.yy: Auto merged
Diffstat (limited to 'mysql-test/t/backup.test')
-rw-r--r--mysql-test/t/backup.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/backup.test b/mysql-test/t/backup.test
index 917c3f98ebb..61bde0cecb0 100644
--- a/mysql-test/t/backup.test
+++ b/mysql-test/t/backup.test
@@ -58,3 +58,22 @@ drop table t5;
--system rm $MYSQLTEST_VARDIR/tmp/t?.*
# End of 4.1 tests
+# End of 5.0 tests
+
+#
+# Bug#18775 - Temporary table from alter table visible to other threads
+#
+# Backup did not encode table names.
+--disable_warnings
+DROP TABLE IF EXISTS `t+1`;
+--enable_warnings
+CREATE TABLE `t+1` (c1 INT);
+INSERT INTO `t+1` VALUES (1), (2), (3);
+BACKUP TABLE `t+1` TO '../tmp';
+DROP TABLE `t+1`;
+#
+# Same for restore.
+RESTORE TABLE `t+1` FROM '../tmp';
+SELECT * FROM `t+1`;
+DROP TABLE `t+1`;
+