diff options
| author | unknown <gshchepa@devsrv-b.mysql.com> | 2007-09-26 12:45:08 +0200 |
|---|---|---|
| committer | unknown <gshchepa@devsrv-b.mysql.com> | 2007-09-26 12:45:08 +0200 |
| commit | 2dc837e6127c8b89346972ebeead122734edeef4 (patch) | |
| tree | 07f29c17bb0428e889c8e86ff5f7b29834c4a839 /mysql-test/r/func_in.result | |
| parent | bd8e7fee1f260b6f5b9b39c67bb6e701eace3cae (diff) | |
| download | mariadb-git-2dc837e6127c8b89346972ebeead122734edeef4.tar.gz | |
Fixed bug #31075.
The `SELECT col FROM t WHERE col NOT IN (col, ...) GROUP BY col'
crashed in the range optimizer.
The get_func_mm_tree function has been modified to check the
Item_func_in::array field for the NULL value before using of that
value.
sql/opt_range.cc:
Fixed bug #31075.
The get_func_mm_tree function has been modified to check the
Item_func_in::array field for the NULL value before using of that
value.
mysql-test/t/func_in.test:
Added test case for bug #31075.
mysql-test/r/func_in.result:
Added test case for bug #31075.
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 4f64d39ccc0..80fa8f17a2a 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -564,4 +564,9 @@ explain select f2 from t2 where f2 in (1,'b'); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 index t2f2 t2f2 5 NULL 3 Using where; Using index drop table t1, t2; +create table t1 (a time, key(a)); +insert into t1 values (),(),(),(),(),(),(),(),(),(); +select a from t1 where a not in (a,a,a) group by a; +a +drop table t1; End of 5.1 tests |