diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2002-12-30 01:46:48 +0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2002-12-30 01:46:48 +0400 |
| commit | 8dceb7c051526e9ceeedb19d91bd146bc2c32683 (patch) | |
| tree | 7bef28a9b07dff237a8edd34e873831e3919d90c /mysql-test/t | |
| parent | daeed63662488d47389df44ff2d64947127c9257 (diff) | |
| download | mariadb-git-8dceb7c051526e9ceeedb19d91bd146bc2c32683.tar.gz | |
processing thread specific queries
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/rpl_temporary.test | 72 |
1 files changed, 72 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_temporary.test b/mysql-test/t/rpl_temporary.test new file mode 100644 index 00000000000..a924e628fd4 --- /dev/null +++ b/mysql-test/t/rpl_temporary.test @@ -0,0 +1,72 @@ +source include/master-slave.inc; + +connect (con1,localhost,root,,); +connect (con2,localhost,root,,); + +drop table if exists t1; +create table t1(f int); +drop table if exists t2; +create table t2(f int); +insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); + +connection con1; +create temporary table t3(f int); +insert into t3 select * from t1 where f<6; + +connection con2; +create temporary table t3(f int); + +connection con1; +insert into t2 select count(*) from t3; + +connection con2; +insert into t3 select * from t1 where f>=4; + +connection con1; +drop temporary table t3; + +connection con2; +insert into t2 select count(*) from t3; +drop temporary table t3; + +select * from t2; + +show binlog events; + +drop table if exists t1; +drop table if exists t2; + +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;
\ No newline at end of file |