diff options
| author | unknown <sergefp@mysql.com> | 2006-06-04 17:17:37 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2006-06-04 17:17:37 +0400 |
| commit | 6ccab8d4deabce37b7a975f56dd1232a2ecb99e6 (patch) | |
| tree | c64fda04df90c318137a856076a32be88a19a16f /mysql-test/r/partition_pruning.result | |
| parent | 14e1d69aeaa09075fe3ec609d5ccdcf899508d7d (diff) | |
| download | mariadb-git-6ccab8d4deabce37b7a975f56dd1232a2ecb99e6.tar.gz | |
BUG#19055: There may exist a SEL_TREE objects with type==KEY and keys[i]==NULL for any i.
(for example, such objects can be returned from get_mm_parts() for "string_field = int_val).
Make find_used_partitions_imerge() to handle such SEL_TREE objects.
mysql-test/r/partition_pruning.result:
BUG#19055: testcase
mysql-test/t/partition_pruning.test:
BUG#19055: testcase
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
| -rw-r--r-- | mysql-test/r/partition_pruning.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index 405cc3e6e25..62c7a962ba1 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -670,3 +670,11 @@ select * from t1 where a like 'n%'; a na drop table t1; +create table t1 (s1 varchar(15)) partition by key (s1); +select * from t1 where s1 = 0 or s1 is null; +s1 +insert into t1 values ('aa'),('bb'),('0'); +explain partitions select * from t1 where s1 = 0 or s1 is null; +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 p0 ALL NULL NULL NULL NULL 3 Using where +drop table t1; |