Debian Codegraph @

mysql-test/suite/rpl/r/rpl_session_var2.result

raw
1 include/master-slave.inc
2 [connection master]
3 select @@rpl_semi_sync_master_enabled;
4 @@rpl_semi_sync_master_enabled
5 1
6 connection slave;
7 select @@rpl_semi_sync_slave_enabled;
8 @@rpl_semi_sync_slave_enabled
9 1
10 show status like "rpl_semi_sync_slave_status";
11 Variable_name Value
12 Rpl_semi_sync_slave_status ON
13 connection master;
14 drop table if exists t1;
15 Warnings:
16 Note 1051 Unknown table 'test.t1'
17 create table t1(a varchar(100),b int);
18 set @@session.sql_mode=pipes_as_concat;
19 insert into t1 values('My'||'SQL', 1);
20 set @@session.sql_mode=default;
21 insert into t1 values('1'||'2', 2);
22 select * from t1 where b<3 order by a;
23 a b
24 1 2
25 MySQL 1
26 connection slave;
27 select * from t1 where b<3 order by a;
28 a b
29 1 2
30 MySQL 1
31 connection master;
32 set @@session.sql_mode=ignore_space;
33 insert into t1 values(password ('MySQL'), 3);
34 set @@session.sql_mode=ansi_quotes;
35 create table "t2" ("a" int);
36 drop table t1, t2;
37 set @@session.sql_mode=default;
38 create table t1(a int auto_increment primary key);
39 create table t2(b int, a int);
40 set @@session.sql_auto_is_null=1;
41 insert into t1 values(null);
42 insert into t2 select 1,a from t1 where a is null;
43 set @@session.sql_auto_is_null=0;
44 insert into t1 values(null);
45 insert into t2 select 2,a from t1 where a is null;
46 select * from t2 order by b;
47 b a
48 1 1
49 connection slave;
50 select * from t2 order by b;
51 b a
52 1 1
53 connection master;
54 drop table t1,t2;
55 connection slave;
56 connection master;
57 CREATE TABLE t1 (
58 `id` int(11) NOT NULL auto_increment,
59 `data` varchar(100),
60 PRIMARY KEY (`id`)
61 ) ENGINE=MyISAM;
62 INSERT INTO t1(data) VALUES(SESSION_USER());
63 connection slave;
64 SELECT length(data) < 100 FROM t1;
65 length(data) < 100
66 1
67 connection master;
68 drop table t1;
69 include/rpl_end.inc