diff options
| author | unknown <thek@kpdesk.mysql.com> | 2006-12-01 17:36:51 +0100 |
|---|---|---|
| committer | unknown <thek@kpdesk.mysql.com> | 2006-12-01 17:36:51 +0100 |
| commit | 108107f1f2da113017dc303dff38443d25a62dab (patch) | |
| tree | 7408ef0844a61578d9cd7d76b66df6dd0f344ade /mysql-test/r/rpl_sp.result | |
| parent | a3774e00dc905f68e749c53831e9a0bd3897604e (diff) | |
| download | mariadb-git-108107f1f2da113017dc303dff38443d25a62dab.tar.gz | |
Bug#22043 MySQL don't add "USE <DATABASE>" before "DROP PROCEDURE IF EXISTS"
- Merged; updated test case.
mysql-test/r/rpl_sp.result:
- Merged; updated test case for 5.1
mysql-test/t/rpl_sp.test:
- Merged; updated result set for 5.1
Diffstat (limited to 'mysql-test/r/rpl_sp.result')
| -rw-r--r-- | mysql-test/r/rpl_sp.result | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/mysql-test/r/rpl_sp.result b/mysql-test/r/rpl_sp.result index f3754f650fb..fe54b1cbeb4 100644 --- a/mysql-test/r/rpl_sp.result +++ b/mysql-test/r/rpl_sp.result @@ -468,6 +468,7 @@ drop table t1; set global log_bin_trust_function_creators=0; set global log_bin_trust_function_creators=0; End of 5.0 tests +reset master; drop database if exists mysqltest; drop database if exists mysqltest2; create database mysqltest; @@ -476,14 +477,15 @@ use mysqltest2; create table t ( t integer ); create procedure mysqltest.test() begin end; insert into t values ( 1 ); -show binlog events in 'master-bin.000001' from 8657; +show binlog events in 'master-bin.000001' from 102; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 8657 Query 1 8760 drop database if exists mysqltest2 -master-bin.000001 8760 Query 1 8853 create database mysqltest -master-bin.000001 8853 Query 1 8948 create database mysqltest2 -master-bin.000001 8948 Query 1 9045 use `mysqltest2`; create table t ( t integer ) -master-bin.000001 9045 Query 1 9184 use `mysqltest2`; CREATE DEFINER=`root`@`localhost` procedure mysqltest.test() begin end -master-bin.000001 9184 Query 1 9279 use `mysqltest2`; insert into t values ( 1 ) +master-bin.000001 102 Query 1 203 drop database if exists mysqltest +master-bin.000001 203 Query 1 306 drop database if exists mysqltest2 +master-bin.000001 306 Query 1 399 create database mysqltest +master-bin.000001 399 Query 1 494 create database mysqltest2 +master-bin.000001 494 Query 1 591 use `mysqltest2`; create table t ( t integer ) +master-bin.000001 591 Query 1 730 use `mysqltest2`; CREATE DEFINER=`root`@`localhost` procedure mysqltest.test() begin end +master-bin.000001 730 Query 1 825 use `mysqltest2`; insert into t values ( 1 ) create procedure `\\`.test() begin end; ERROR 42000: Unknown database '\\' drop database mysqltest; |