fixed optimized SOME subquery

1 files changed, 4 insertions, 4 deletions

diff --git a/sql/item_cmpfunc.cc b/sql/item_cmpfunc.cc
index 51212418b09..88083878053 100644
--- a/sql/item_cmpfunc.cc
+++ b/sql/item_cmpfunc.cc
@@ -120,7 +120,7 @@ longlong Item_func_not_all::val_int()
 
   /*
     return TRUE if there was records in underlaying select in max/min
-    optimisation
+    optimisation (ALL subquery)
   */
   if (empty_underlying_subquery())
     return 1;
@@ -157,11 +157,11 @@ longlong Item_func_nop_all::val_int()
   double value= args[0]->val();
 
   /*
-    return TRUE if there was records in underlaying select in max/min
-    optimisation
+    return FALSE if there was records in underlaying select in max/min
+    optimisation (SAME/ANY subquery)
   */
   if (empty_underlying_subquery())
-    return 1;
+    return 0;
 
   null_value= args[0]->null_value;
   return (null_value || value == 0) ? 0 : 1;