summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result')
-rw-r--r--storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result143
1 files changed, 0 insertions, 143 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result b/storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result
deleted file mode 100644
index 4f2eaf307ee..00000000000
--- a/storage/tokudb/mysql-test/suite/tokudb.bugs/r/bulk_fetch.result
+++ /dev/null
@@ -1,143 +0,0 @@
-SET DEFAULT_STORAGE_ENGINE = 'tokudb';
-DROP TABLE IF EXISTS foo;
-create table foo (a int, b bigint, c int, primary key (a))engine=TokuDB;
-insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500),(6,60,600);
-select * from foo;
-a b c
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-5 50 500
-6 60 600
-select a from foo;
-a
-1
-2
-3
-4
-5
-6
-select * from foo where a > 2;
-a b c
-3 30 300
-4 40 400
-5 50 500
-6 60 600
-select a from foo where a > 2;
-a
-3
-4
-5
-6
-select count(*) from foo;
-count(*)
-6
-alter table foo add index b(b);
-select b from foo;
-b
-10
-20
-30
-40
-50
-60
-explain select * from foo where b > 30;
-id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE foo range b b 9 NULL 3 Using where
-select * from foo where b > 30;
-a b c
-4 40 400
-5 50 500
-6 60 600
-alter table foo drop index b;
-alter table foo add clustering index c(c);
-select c from foo;
-c
-100
-200
-300
-400
-500
-600
-explain select * from foo where c > 300;
-id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE foo range c c 5 NULL 3 Using where
-select * from foo where c > 300;
-a b c
-4 40 400
-5 50 500
-6 60 600
-drop table foo;
-create table foo (a int, b int);
-insert into foo values (1,10),(2,20),(3,30),(4,40),(5,50),(6,60);
-select * from foo;
-a b
-1 10
-2 20
-3 30
-4 40
-5 50
-6 60
-select a from foo;
-a
-1
-2
-3
-4
-5
-6
-select b from foo;
-b
-10
-20
-30
-40
-50
-60
-select count(*) from foo;
-count(*)
-6
-drop table foo;
-create table foo (a int, b varchar(10), c blob, d bigint, e varchar(10), f mediumblob)engine=TokuDB;
-insert into foo values(1,"bb","ccccc",100,"eee","fffffffffffffffffffff");
-select * from foo;
-a b c d e f
-1 bb ccccc 100 eee fffffffffffffffffffff
-select a,d from foo;
-a d
-1 100
-select b,e from foo;
-b e
-bb eee
-select c,f from foo;
-c f
-ccccc fffffffffffffffffffff
-select d from foo;
-d
-100
-select e from foo;
-e
-eee
-select f from foo;
-f
-fffffffffffffffffffff
-select a from foo;
-a
-1
-select b from foo;
-b
-bb
-select c from foo;
-c
-ccccc
-select b,c,e,f from foo;
-b c e f
-bb ccccc eee fffffffffffffffffffff
-select a,b,d,e from foo;
-a b d e
-1 bb 100 eee
-select a,d,c,f from foo;
-a d c f
-1 100 ccccc fffffffffffffffffffff
-DROP TABLE foo;