summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <guilhem@mysql.com>2003-09-28 18:31:49 +0200
committerunknown <guilhem@mysql.com>2003-09-28 18:31:49 +0200
commit3106e3119a2b3ee9155360279e48093d0e3b7d45 (patch)
tree7167749cc124337522cef82b8ddb1e57a15fb976 /mysql-test/t
parentd84ae0fde9622676171089a950e2b7db1415d9ea (diff)
downloadmariadb-git-3106e3119a2b3ee9155360279e48093d0e3b7d45.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. sql/sql_base.cc: backquote db and table name when writing DROP TEMPORARY TABLE to the binlog when a connection ends.
Diffstat (limited to 'mysql-test/t')
-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`;