MariaDB

  1. Bug #1013343
  2. Comment #5

Comment 5 for bug 1013343

Revision history for this message
Sergey Petrunia (sergefp) wrote :

This patch seems to fix it:

=== modified file 'sql/item_subselect.cc'
--- sql/item_subselect.cc 2012-06-07 22:19:36 +0000
+++ sql/item_subselect.cc 2012-06-14 22:02:49 +0000
@@ -1804,7 +1804,7 @@ bool Item_allany_subselect::is_maxmin_ap
     WHERE condition.
   */
   return (abort_on_null || (upper_item && upper_item->is_top_level_item())) &&
- !join->select_lex->master_unit()->uncacheable && !func->eqne_op();
+ !(join->select_lex->master_unit()->uncacheable & ~UNCACHEABLE_EXPLAIN) && !func->eqne_op();
 }