diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-11-14 22:51:54 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-12-21 21:30:54 +0100 |
| commit | 0686c34d22a5cbf93015012eaf77a4a977b63afb (patch) | |
| tree | 3c95207d5e01a905f9e87820e6439fe6c6547653 /sql/sql_load.cc | |
| parent | ad5db17e882fea36dcae6f6e61996b5f9bf28962 (diff) | |
| download | mariadb-git-0686c34d22a5cbf93015012eaf77a4a977b63afb.tar.gz | |
MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column
NOT NULL constraint must be checked *after* the BEFORE triggers.
That is for INSERT and UPDATE statements even NOT NULL fields
must be able to store a NULL temporarily at least while
BEFORE INSERT/UPDATE triggers are running.
Diffstat (limited to 'sql/sql_load.cc')
| -rw-r--r-- | sql/sql_load.cc | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/sql_load.cc b/sql/sql_load.cc index aed26bd2fa5..e102066c0bc 100644 --- a/sql/sql_load.cc +++ b/sql/sql_load.cc @@ -295,6 +295,9 @@ int mysql_load(THD *thd,sql_exchange *ex,TABLE_LIST *table_list, if (setup_fields(thd, 0, set_values, MARK_COLUMNS_READ, 0, 0)) DBUG_RETURN(TRUE); } + switch_to_nullable_trigger_fields(fields_vars, table); + switch_to_nullable_trigger_fields(set_fields, table); + switch_to_nullable_trigger_fields(set_values, table); table->prepare_triggers_for_insert_stmt_or_event(); table->mark_columns_needed_for_insert(); |