From 9739c26fec71b1118ccbf09a9b673a8d28b2110c Mon Sep 17 00:00:00 2001 From: Rex Date: Mon, 23 Jan 2023 14:35:14 +1200 Subject: MDEV-28620, MDEV-28621, MDEV-28622 Server crash in /sql/item_subselect.cc * Optimizer has eliminated subquery for various reasons. Attempting to walk or access Item_subselect (and descendents) values causes issues for these removed Items. Fixed by setting either fixed_const, null_value or checking eliminated. --- sql/sql_select.cc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/sql_select.cc') diff --git a/sql/sql_select.cc b/sql/sql_select.cc index 58d9b232722..7eb90fc789e 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -1198,7 +1198,7 @@ JOIN::prepare(TABLE_LIST *tables_init, */ if (select_lex->master_unit()->item && // 1) select_lex->first_cond_optimization && // 2) - !thd->lex->is_view_context_analysis()) // 3) + !thd->lex->is_ps_or_view_context_analysis()) // 3) { remove_redundant_subquery_clauses(select_lex); } -- cgit v1.2.1