diff options
| author | gshchepa@devsrv-b.mysql.com <> | 2007-09-26 12:45:08 +0200 |
|---|---|---|
| committer | gshchepa@devsrv-b.mysql.com <> | 2007-09-26 12:45:08 +0200 |
| commit | 7f0e9065f822300b2ef5a392497f85614c1f5373 (patch) | |
| tree | 07f29c17bb0428e889c8e86ff5f7b29834c4a839 /mysql-test/t | |
| parent | ed7e4b82c1e5156bef05b4a800e8fa8ebb8223fc (diff) | |
| download | mariadb-git-7f0e9065f822300b2ef5a392497f85614c1f5373.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.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_in.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 2c5ed6a22d3..d8b0c89532e 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -408,5 +408,13 @@ select f2 from t2 where f2 in (1,'b'); explain select f2 from t2 where f2 in (1,'b'); drop table t1, t2; +# +# Bug #31075: crash in get_func_mm_tree +# + +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; +drop table t1; --echo End of 5.1 tests |