diff --git a/sql/field.cc b/sql/field.cc index fb605da3fdc..156eadd43d3 100644 --- a/sql/field.cc +++ b/sql/field.cc @@ -10435,6 +10435,12 @@ Create_field *generate_create_field(THD *thd, Item *item, TABLE *tmp_table) { if (is_temporal_type_with_date(tmp_table_field->type()) && thd->is_strict_mode() && !item->is_nullable()) tmp_table_field->set_flag(NO_DEFAULT_VALUE_FLAG); + + if (item->type() == Item::FUNC_ITEM && + item->is_nullable() == false && + tmp_table_field->real_type() == MYSQL_TYPE_GEOMETRY) { + tmp_table_field->set_flag(NO_DEFAULT_VALUE_FLAG); + } } }