From 90aa05d276b85367c297cc9f7580529aa782d205 Mon Sep 17 00:00:00 2001
From: "igor@olga.mysql.com" <>
Date: Tue, 3 Apr 2007 14:32:16 -0700
Subject: Fixed bug #27532: wrong results with ORDER/GROUP BY queries
 containing IN/BETWEEN predicates in sorting expressions. Wrong results may
 occur when the select list contains an expression with IN/BETWEEN predicate
 that differs from a sorting expression by an additional NOT only.

Added the method Item_func_opt_neg::eq to compare correctly expressions
containing [NOT] IN/BETWEEN.
The eq method inherited from the Item_func returns TRUE when comparing
'a IN (1,2)' with 'a NOT IN (1,2)' that is not, of course, correct.
---
 sql/item_cmpfunc.h | 1 +
 1 file changed, 1 insertion(+)

(limited to 'sql/item_cmpfunc.h')

diff --git a/sql/item_cmpfunc.h b/sql/item_cmpfunc.h
index a13be83e093..132e019b4a3 100644
--- a/sql/item_cmpfunc.h
+++ b/sql/item_cmpfunc.h
@@ -405,6 +405,7 @@ public:
     negated= !negated;
     return this;
   }
+  bool eq(const Item *item, bool binary_cmp) const;
 };
 
 
-- 
cgit v1.2.1