diff options
| author | unknown <guilhem@mysql.com> | 2003-09-28 18:31:49 +0200 |
|---|---|---|
| committer | unknown <guilhem@mysql.com> | 2003-09-28 18:31:49 +0200 |
| commit | 3106e3119a2b3ee9155360279e48093d0e3b7d45 (patch) | |
| tree | 7167749cc124337522cef82b8ddb1e57a15fb976 /mysql-test/r/drop_temp_table.result | |
| parent | d84ae0fde9622676171089a950e2b7db1415d9ea (diff) | |
| download | mariadb-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/r/drop_temp_table.result')
| -rw-r--r-- | mysql-test/r/drop_temp_table.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/drop_temp_table.result b/mysql-test/r/drop_temp_table.result new file mode 100644 index 00000000000..40e363dbf00 --- /dev/null +++ b/mysql-test/r/drop_temp_table.result @@ -0,0 +1,11 @@ +reset master; +create database `drop-temp+table-test`; +use `drop-temp+table-test`; +create temporary table `table:name` (a int); +show binlog events; +Log_name Pos Event_type Server_id Orig_log_pos Info +master-bin.001 4 Start 1 4 Server ver: VERSION, Binlog ver: 3 +master-bin.001 79 Query 1 79 use test; create database `drop-temp+table-test` +master-bin.001 152 Query 1 152 use drop-temp+table-test; create temporary table `table:name` (a int) +master-bin.001 246 Query 1 246 use drop-temp+table-test; DROP /*!40005 TEMPORARY */ TABLE `drop-temp+table-test`.`table:name` +drop database `drop-temp+table-test`; |