diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/rpl_session_var.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/rpl_session_var.result | 29 |
1 files changed, 22 insertions, 7 deletions
diff --git a/mysql-test/suite/engines/funcs/r/rpl_session_var.result b/mysql-test/suite/engines/funcs/r/rpl_session_var.result index b5b4b815ade..67863583f8d 100644 --- a/mysql-test/suite/engines/funcs/r/rpl_session_var.result +++ b/mysql-test/suite/engines/funcs/r/rpl_session_var.result @@ -1,12 +1,8 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; +include/master-slave.inc +[connection master] drop table if exists t1; Warnings: -Note 1051 Unknown table 't1' +Note 1051 Unknown table 'test.t1' create table t1(a varchar(100),b int); set @@session.sql_mode=pipes_as_concat; insert into t1 values('My'||'SQL', 1); @@ -16,10 +12,12 @@ select * from t1 where b<3 order by a; a b 1 2 MySQL 1 +connection slave; select * from t1 where b<3 order by a; a b 1 2 MySQL 1 +connection master; set @@session.sql_mode=ignore_space; insert into t1 values(password ('MySQL'), 3); set @@session.sql_mode=ansi_quotes; @@ -37,7 +35,24 @@ insert into t2 select 2,a from t1 where a is null; select * from t2 order by b; b a 1 1 +connection slave; select * from t2 order by b; b a 1 1 +connection master; drop table t1,t2; +connection slave; +connection master; +CREATE TABLE t1 ( +`id` int(11) NOT NULL auto_increment, +`data` varchar(100), +PRIMARY KEY (`id`) +) ENGINE=MyISAM; +INSERT INTO t1(data) VALUES(SESSION_USER()); +connection slave; +SELECT length(data) < 100 FROM t1; +length(data) < 100 +1 +connection master; +drop table t1; +include/rpl_end.inc |