EVOLUTION-MANAGER

Edit File: bf_create_select_range_part.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`) ) PARTITION BY RANGE (num) (PARTITION p0 VALUES LESS THAN (100000), PARTITION p1 VALUES LESS THAN (200000), PARTITION p2 VALUES LESS THAN (300000), PARTITION p3 VALUES LESS THAN (400000), PARTITION p4 VALUES LESS THAN (500000), PARTITION p5 VALUES LESS THAN (600000), PARTITION p6 VALUES LESS THAN (700000), PARTITION p7 VALUES LESS THAN MAXVALUE); 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 TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; set tokudb_bulk_fetch=OFF; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1; DROP TABLE t2; 1 set tokudb_bulk_fetch=ON; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; set tokudb_bulk_fetch=OFF; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; 1 drop table t1;