From 7f0e9065f822300b2ef5a392497f85614c1f5373 Mon Sep 17 00:00:00 2001
From: "gshchepa@devsrv-b.mysql.com" <>
Date: Wed, 26 Sep 2007 12:45:08 +0200
Subject: 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.
---
 mysql-test/t/func_in.test | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'mysql-test/t')

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
-- 
cgit v1.2.1