Bug #31472704 : MYSQL CRASHES ON SOME QUERIES WITH SUBSELECTS

Chandan Kunal · gipulla · commit 9bb243a3fa25 · 2020-09-23T17:47:26.000+05:30
Description:
Fix an issue with SELECT query.

Change-Id: I90a256bf237f1ce7860b1b3cfb25813287036607
(cherry picked from commit b3039dc34acc2544f5451b7d55ff239cc4c268a9)
diff --git a/sql/item.cc b/sql/item.cc
@@ -1,5 +1,5 @@
 /*
-   Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
+   Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
 
    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License, version 2.0,
@@ -3005,7 +3005,8 @@ void Item_ident::fix_after_pullout(st_select_lex *parent_select,
         The subquery on this level is outer-correlated with respect to the field
       */
       Item_subselect *subq_predicate= child_select->master_unit()->item;
-
+      if (subq_predicate == NULL)
+	return;
       subq_predicate->used_tables_cache|= OUTER_REF_TABLE_BIT;
       child_select= child_select->outer_select();
     }
