rpl_temporary.result 2.99 KB
Newer Older
unknown's avatar
unknown committed
1 2 3 4 5 6
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;
7
reset master;
8 9
SET @@session.pseudo_thread_id=100;
ERROR HY000: Access denied. You need the SUPER privilege for this operation
10 11 12 13 14 15
SET @@session.sql_log_bin=0;
ERROR HY000: Access denied. You need the SUPER privilege for this operation
SET @@session.pseudo_thread_id=100;
SET @@session.pseudo_thread_id=connection_id();
SET @@session.sql_log_bin=0;
SET @@session.sql_log_bin=1;
16
drop table if exists t1,t2;
unknown's avatar
unknown committed
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
create table t1(f int);
create table t2(f int);
insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
create temporary table t3(f int);
insert into t3 select * from t1 where f<6;
create temporary table t3(f int);
insert into t2 select count(*) from t3;
insert into t3 select * from t1 where f>=4;
drop temporary table t3;
insert into t2 select count(*) from t3;
drop temporary table t3;
select * from t2;
f
5
7
show binlog events;
Log_name	Pos	Event_type	Server_id	Orig_log_pos	Info
34
master-bin.000001	4	Start	1	4	Server ver: VERSION, Binlog ver: 3
unknown's avatar
unknown committed
35 36 37 38 39 40 41
master-bin.000001	79	Query	1	79	use `test`; create table t1(f int)
master-bin.000001	136	Query	1	136	use `test`; create table t2(f int)
master-bin.000001	193	Query	1	193	use `test`; insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10)
master-bin.000001	290	Query	1	290	use `test`; create temporary table t3(f int)
master-bin.000001	357	Query	1	357	use `test`; insert into t3 select * from t1 where f<6
master-bin.000001	433	Query	1	433	use `test`; create temporary table t3(f int)
master-bin.000001	500	Query	1	500	use `test`; insert into t2 select count(*) from t3
42 43
master-bin.000001	573	Query	1	573	use `test`; insert into t3 select * from t1 where f>=4
master-bin.000001	650	Query	1	650	use `test`; drop temporary table t3
unknown's avatar
unknown committed
44 45
master-bin.000001	708	Query	1	708	use `test`; insert into t2 select count(*) from t3
master-bin.000001	781	Query	1	781	use `test`; drop temporary table t3
46
drop table t1, t2;
unknown's avatar
unknown committed
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
use test;
SET TIMESTAMP=1040323920;
create table t1(f int);
SET TIMESTAMP=1040323931;
create table t2(f int);
SET TIMESTAMP=1040323938;
insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
SET TIMESTAMP=1040323945;
SET @@session.pseudo_thread_id=1;
create temporary table t3(f int);
SET TIMESTAMP=1040323952;
SET @@session.pseudo_thread_id=1;
insert into t3 select * from t1 where f<6;
SET TIMESTAMP=1040324145;
SET @@session.pseudo_thread_id=2;
create temporary table t3(f int);
SET TIMESTAMP=1040324186;
SET @@session.pseudo_thread_id=1;
insert into t2 select count(*) from t3;
SET TIMESTAMP=1040324200;
SET @@session.pseudo_thread_id=2;
insert into t3 select * from t1 where f>=4;
SET TIMESTAMP=1040324211;
SET @@session.pseudo_thread_id=1;
drop temporary table t3;
SET TIMESTAMP=1040324219;
SET @@session.pseudo_thread_id=2;
insert into t2 select count(*) from t3;
SET TIMESTAMP=1040324224;
SET @@session.pseudo_thread_id=2;
drop temporary table t3;
select * from t2;
f
5
7
82
drop table t1,t2;
83
create temporary table t3 (f int);