From 1e6ad0ce13c5d2e4125df8006316d9dfe0f8d649 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Mon, 9 Jan 2023 12:49:37 +0100 Subject: don't set default value in temp table if NO_DEFAULT_VALUE_FLAG when an internal temporary table field is created from a real field, a new temp field should only copy a default from the source field when the latter has it --- sql/sql_select.cc | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql/sql_select.cc') diff --git a/sql/sql_select.cc b/sql/sql_select.cc index d7b2891c9d4..d5519e9f541 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -18241,7 +18241,8 @@ Field *Item_field::create_tmp_field_ex(TABLE *table, src->set_field(field); if (!(result= create_tmp_field_from_item_field(table, NULL, param))) return NULL; - if (field->eq_def(result)) + if (!(field->flags & NO_DEFAULT_VALUE_FLAG) && + field->eq_def(result)) src->set_default_field(field); return result; } -- cgit v1.2.1