diff options
Diffstat (limited to 'mysql-test/r/bdb_cache.result')
-rw-r--r-- | mysql-test/r/bdb_cache.result | 99 |
1 files changed, 0 insertions, 99 deletions
diff --git a/mysql-test/r/bdb_cache.result b/mysql-test/r/bdb_cache.result deleted file mode 100644 index 6506ce0412a..00000000000 --- a/mysql-test/r/bdb_cache.result +++ /dev/null @@ -1,99 +0,0 @@ -drop table if exists t1, t2, t3; -flush status; -set autocommit=0; -create table t1 (a int not null) engine=bdb; -insert into t1 values (1),(2),(3); -select * from t1; -a -1 -2 -3 -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 0 -drop table t1; -set autocommit=1; -create table t1 (a int not null) engine=bdb; -begin; -insert into t1 values (1),(2),(3); -select * from t1; -a -1 -2 -3 -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 0 -drop table t1; -create table t1 (a int not null) engine=bdb; -create table t2 (a int not null) engine=bdb; -create table t3 (a int not null) engine=bdb; -insert into t1 values (1),(2); -insert into t2 values (1),(2); -insert into t3 values (1),(2); -select * from t1; -a -1 -2 -select * from t2; -a -1 -2 -select * from t3; -a -1 -2 -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 3 -show status like "Qcache_hits"; -Variable_name Value -Qcache_hits 0 -begin; -select * from t1; -a -1 -2 -select * from t2; -a -1 -2 -select * from t3; -a -1 -2 -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 3 -show status like "Qcache_hits"; -Variable_name Value -Qcache_hits 0 -insert into t1 values (3); -insert into t2 values (3); -insert into t1 values (4); -select * from t1; -a -1 -2 -3 -4 -select * from t2; -a -1 -2 -3 -select * from t3; -a -1 -2 -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 3 -show status like "Qcache_hits"; -Variable_name Value -Qcache_hits 0 -commit; -show status like "Qcache_queries_in_cache"; -Variable_name Value -Qcache_queries_in_cache 1 -drop table if exists t1, t2, t3; |