EVOLUTION-MANAGER

Edit File: bf_create_temp_select.result

set default_storage_engine='tokudb'; 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 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 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; set tokudb_bulk_fetch=OFF; 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 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 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 t1;