Bug #31905199: WHERE_CONDITION OPTIMIZATION MAY CAUSE A CORE DUMP

Chandan Kunal · Chandan Kunal · commit 28941bbabf61 · 2020-10-19T10:04:05.000+05:30
Description:
Fix an issue with SELECT query.

Change-Id: I8507077e8292803b79293daa97369a9c65e2386a
diff --git a/sql/item.cc b/sql/item.cc
@@ -5797,7 +5797,8 @@ Item *Item_field::equal_fields_propagator(uchar *arg)
       first converted to a string (in date/time format) and compared as such if
       compared with another string.
     */
-    if (item && field->type() != FIELD_TYPE_TIMESTAMP && cmp_context != INT_RESULT)
+    if (item && field->type() != FIELD_TYPE_TIMESTAMP && cmp_context != INT_RESULT
+        && item->real_item()->type() != Item::REAL_ITEM)
       convert_zerofill_number_to_string(&item, (Field_num *)field);
     else
       item= this;
