diff options
| author | sergefp@mysql.com <> | 2006-06-04 17:17:37 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2006-06-04 17:17:37 +0400 |
| commit | 9e425092d6e5d48e5b3855450d9f6e61bf0f547a (patch) | |
| tree | c64fda04df90c318137a856076a32be88a19a16f /mysql-test/t/partition_pruning.test | |
| parent | b615e0b6dca974678ea6f9610f42ed4dbeb1bfe5 (diff) | |
| download | mariadb-git-9e425092d6e5d48e5b3855450d9f6e61bf0f547a.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.
Diffstat (limited to 'mysql-test/t/partition_pruning.test')
| -rw-r--r-- | mysql-test/t/partition_pruning.test | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/t/partition_pruning.test b/mysql-test/t/partition_pruning.test index 0c922392d32..3e9a59d1069 100644 --- a/mysql-test/t/partition_pruning.test +++ b/mysql-test/t/partition_pruning.test @@ -556,7 +556,7 @@ drop table t1; # being fixed. # -#BUG 17946 Like searches fail with partitioning +# BUG#17946 Like searches fail with partitioning # create table t1 (a char(32) primary key) partition by key() @@ -566,3 +566,11 @@ select * from t1; select * from t1 where a like 'n%'; drop table t1; + +# BUG#19055 Crashes for varchar_col=NUMBER or varchar_col IS NULL +create table t1 (s1 varchar(15)) partition by key (s1); +select * from t1 where s1 = 0 or s1 is null; +insert into t1 values ('aa'),('bb'),('0'); +explain partitions select * from t1 where s1 = 0 or s1 is null; +drop table t1; + |