diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/bf_create_select.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/bf_create_select.result | 326 |
1 files changed, 141 insertions, 185 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/bf_create_select.result b/storage/tokudb/mysql-test/tokudb/r/bf_create_select.result index adacf1ed6aa..c98bf2a4b78 100644 --- a/storage/tokudb/mysql-test/tokudb/r/bf_create_select.result +++ b/storage/tokudb/mysql-test/tokudb/r/bf_create_select.result @@ -1,72 +1,56 @@ 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 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; @@ -88,155 +72,127 @@ DROP TABLE t2; CREATE 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 TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +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; +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 > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; -CREATE TABLE t2 AS SELECT count(*) from t1 where num > 7000000; +CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; DROP TABLE t2; 1 -drop table t,t1; +drop table t1; |