MDEV-25576: The statement EXPLAIN running as regular statement and as prepared statement produces different results for UPDATE with subquery

10.6 cleanup

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/sql_lex.h b/sql/sql_lex.h
index 6df1996409c..0d8251968e8 100644
--- a/sql/sql_lex.h
+++ b/sql/sql_lex.h
@@ -4773,6 +4773,19 @@ public:
   bool resolve_references_to_cte(TABLE_LIST *tables,
                                  TABLE_LIST **tables_last);
 
+  /**
+    Turn on the SELECT_DESCRIBE flag for every SELECT_LEX involved into
+    the statement being processed in case the statement is EXPLAIN UPDATE/DELETE.
+
+    @param lex  current LEX
+  */
+
+  void promote_select_describe_flag_if_needed()
+  {
+    if (describe)
+      builtin_select.options |= SELECT_DESCRIBE;
+  }
+
 };