summaryrefslogtreecommitdiff
path: root/mysql-test/t/drop_temp_table.test
diff options
context:
space:
mode:
authorguilhem@mysql.com <>2003-09-28 18:31:49 +0200
committerguilhem@mysql.com <>2003-09-28 18:31:49 +0200
commit9d7014c07be2511194bed4f948aa67200cda40da (patch)
tree7167749cc124337522cef82b8ddb1e57a15fb976 /mysql-test/t/drop_temp_table.test
parent4a7b5b26e2e986cff20299313d4d16d401ab50eb (diff)
downloadmariadb-git-9d7014c07be2511194bed4f948aa67200cda40da.tar.gz
Fix for BUG#1345 "SQL Syntax Error in binarylog with DROP TABLES":
it's just backquoting the db's and table's names when writing DROP TEMPORARY TABLE to the binlog when a connection ends. A testcase for this.
Diffstat (limited to 'mysql-test/t/drop_temp_table.test')
-rw-r--r--mysql-test/t/drop_temp_table.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/drop_temp_table.test b/mysql-test/t/drop_temp_table.test
new file mode 100644
index 00000000000..4849e998bf5
--- /dev/null
+++ b/mysql-test/t/drop_temp_table.test
@@ -0,0 +1,13 @@
+connect (con1,localhost,root,,);
+connect (con2,localhost,root,,);
+connection con1;
+reset master;
+create database `drop-temp+table-test`;
+use `drop-temp+table-test`;
+create temporary table `table:name` (a int);
+disconnect con1;
+connection con2;
+let $VERSION=`select version()`;
+--replace_result $VERSION VERSION
+show binlog events;
+drop database `drop-temp+table-test`;