diff options
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb/r/cluster_delete.result')
| -rw-r--r-- | storage/tokudb/mysql-test/suite/tokudb/r/cluster_delete.result | 205 |
1 files changed, 0 insertions, 205 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb/r/cluster_delete.result b/storage/tokudb/mysql-test/suite/tokudb/r/cluster_delete.result deleted file mode 100644 index 348aa2197ca..00000000000 --- a/storage/tokudb/mysql-test/suite/tokudb/r/cluster_delete.result +++ /dev/null @@ -1,205 +0,0 @@ -SET DEFAULT_STORAGE_ENGINE='tokudb'; -DROP TABLE IF EXISTS t1; -create table t1(a int, b int, c int, d int, primary key(a), clustering key(b), key (c))engine=tokudb; -insert into t1 values (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000),(5,50,500,5000),(6,60,600,6000),(7,70,700,7000),(8,80,800,8000),(9,90,900,9000); -explain select * from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where -select * from t1 where a > 5; -a b c d -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select * from t1 where b > 30; -a b c d -4 40 400 4000 -5 50 500 5000 -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select * from t1 where c > 750; -a b c d -8 80 800 8000 -9 90 900 9000 -explain select a from t1 where a > 8; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index -select a from t1 where a > 8; -a -9 -explain select a,b from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where; Using index -select a,b from t1 where b > 30; -a b -4 40 -5 50 -6 60 -7 70 -8 80 -9 90 -explain select a,b from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select a,c from t1 where c > 750; -a c -8 800 -9 900 -delete from t1 where b>30 and b < 60; -select * from t1; -a b c d -1 10 100 1000 -2 20 200 2000 -3 30 300 3000 -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where -select * from t1 where a > 5; -a b c d -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select * from t1 where b > 30; -a b c d -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select * from t1 where c > 750; -a b c d -8 80 800 8000 -9 90 900 9000 -explain select a from t1 where a > 8; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL NULL; Using where; Using index -select a from t1 where a > 8; -a -9 -explain select a,b from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where; Using index -select a,b from t1 where b > 30; -a b -6 60 -7 70 -8 80 -9 90 -explain select a,b from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select a,c from t1 where c > 750; -a c -8 800 -9 900 -alter table t1 drop primary key; -explain select * from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where -select * from t1 where a > 5; -a b c d -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select * from t1 where b > 30; -a b c d -6 60 600 6000 -7 70 700 7000 -8 80 800 8000 -9 90 900 9000 -explain select * from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select * from t1 where c > 750; -a b c d -8 80 800 8000 -9 90 900 9000 -explain select a from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where -select a from t1 where a > 5; -a -6 -7 -8 -9 -explain select a,b from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select a,b from t1 where b > 30; -a b -6 60 -7 70 -8 80 -9 90 -explain select a,b from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select a,c from t1 where c > 750; -a c -8 800 -9 900 -delete from t1 where b > 10 and b < 90; -select * from t1; -a b c d -1 10 100 1000 -9 90 900 9000 -explain select * from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where -select * from t1 where a > 5; -a b c d -9 90 900 9000 -explain select * from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select * from t1 where b > 30; -a b c d -9 90 900 9000 -explain select * from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select * from t1 where c > 750; -a b c d -9 90 900 9000 -explain select a from t1 where a > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL NULL; Using where -select a from t1 where a > 5; -a -9 -explain select a,b from t1 where b > 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 5 NULL NULL; Using where -select a,b from t1 where b > 30; -a b -9 90 -explain select a,b from t1 where c > 750; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c c 5 NULL NULL; Using where -select a,c from t1 where c > 750; -a c -9 900 -drop table t1; |