summaryrefslogtreecommitdiff
path: root/sql/item_subselect.cc
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2023-02-16 11:41:18 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2023-02-16 11:41:18 +0200
commit1fd00998390a7487e42f5e29472e99354159c8bc (patch)
tree0d8d186d702341695c1ad12236b60b3d0a896354 /sql/item_subselect.cc
parentfa5426ee469a8def705b6653cad4b9d21b4b2741 (diff)
parent345356b868d840554a8572876efc027d3ccd9842 (diff)
downloadmariadb-git-1fd00998390a7487e42f5e29472e99354159c8bc.tar.gz
Merge 10.10 into 10.11
Diffstat (limited to 'sql/item_subselect.cc')
-rw-r--r--sql/item_subselect.cc4
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/item_subselect.cc b/sql/item_subselect.cc
index 9b4e60b4086..67d7d03c0bf 100644
--- a/sql/item_subselect.cc
+++ b/sql/item_subselect.cc
@@ -2906,7 +2906,9 @@ bool Item_exists_subselect::select_prepare_to_be_in()
bool trans_res= FALSE;
DBUG_ENTER("Item_exists_subselect::select_prepare_to_be_in");
if (!optimizer &&
- thd->lex->sql_command == SQLCOM_SELECT &&
+ (thd->lex->sql_command == SQLCOM_SELECT ||
+ thd->lex->sql_command == SQLCOM_UPDATE_MULTI ||
+ thd->lex->sql_command == SQLCOM_DELETE_MULTI) &&
!unit->first_select()->is_part_of_union() &&
optimizer_flag(thd, OPTIMIZER_SWITCH_EXISTS_TO_IN) &&
(is_top_level_item() ||