diff options
Diffstat (limited to 'mysql-test/t/partition_pruning.test')
| -rw-r--r-- | mysql-test/t/partition_pruning.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/partition_pruning.test b/mysql-test/t/partition_pruning.test index cf310793848..22c15f46af4 100644 --- a/mysql-test/t/partition_pruning.test +++ b/mysql-test/t/partition_pruning.test @@ -459,13 +459,29 @@ explain partitions select * from t2 where a = 833; explain partitions select * from t2 where (a = 100 OR a = 900); explain partitions select * from t2 where (a > 100 AND a < 600); explain partitions select * from t2 where b = 4; + +explain extended select * from t2 where b = 6; explain partitions select * from t2 where b = 6; + +explain extended select * from t2 where b in (1,3,5); explain partitions select * from t2 where b in (1,3,5); + +explain extended select * from t2 where b in (2,4,6); explain partitions select * from t2 where b in (2,4,6); + +explain extended select * from t2 where b in (7,8,9); explain partitions select * from t2 where b in (7,8,9); + +explain extended select * from t2 where b > 5; explain partitions select * from t2 where b > 5; + +explain extended select * from t2 where b > 5 and b < 8; explain partitions select * from t2 where b > 5 and b < 8; + +explain extended select * from t2 where b > 5 and b < 7; explain partitions select * from t2 where b > 5 and b < 7; + +explain extended select * from t2 where b > 0 and b < 5; explain partitions select * from t2 where b > 0 and b < 5; flush status; |