diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result | 406 |
1 files changed, 181 insertions, 225 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result b/storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result index 6eddfaa9e82..543bd795e2e 100644 --- a/storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result +++ b/storage/tokudb/mysql-test/tokudb/r/bf_create_temp_select.result @@ -1,242 +1,198 @@ set default_storage_engine='tokudb'; -drop table if exists t,t1,t2; -CREATE TABLE `t` ( +drop table if exists t1,t2; +CREATE TABLE `t1` ( `num` int(10) unsigned auto_increment NOT NULL, `val` varchar(32) DEFAULT NULL, PRIMARY KEY (`num`) ); -INSERT INTO t values (null,null); -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -INSERT INTO t SELECT null,val FROM t; -SELECT count(*) FROM t; -count(*) -8388608 -CREATE TABLE `t1` ( -`num` int(10) unsigned NOT NULL, -`val` varchar(32) DEFAULT NULL, -PRIMARY KEY (`num`) -) as select * from t; -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 -SELECT count(*) from t1; -count(*) -8388608 +INSERT INTO t1 values (null,null); +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +INSERT INTO t1 SELECT null,val FROM t1; +SELECT count(*) FROM t1; +count(*) +1048576 +set tokudb_bulk_fetch=ON; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; +set tokudb_bulk_fetch=OFF; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; -DROP TEMPORARY TABLE t2; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1; +DROP TABLE t2; 1 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -SELECT count(*) from t1 where num > 7000000; -count(*) -1847274 -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; -CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 7000000; -DROP TEMPORARY TABLE t2; +set tokudb_bulk_fetch=ON; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +set tokudb_bulk_fetch=OFF; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; +CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000; +DROP TABLE t2; 1 -drop table t,t1; +drop table t1; |