* Fixed numerous SQL syntax change errors in null.test * Added tests to ensure that UPDATE .. SET col=NULL produced appropriate errors, but only when rows were contained in the table. * Added tests to ensure that LOAD DATA INFILE produces errors when setting NULL on NOT NULL columns
sql_insert.cc:
Modified the check_that_all_fields_are_given_values() function to ensure an error is thrown instead of a warning when NULL is inserted into a NOT NULL column.
sql_update.cc:
Modifed mysql_update(), setting ignore to only CHECK_FIELD_ERROR_FOR_NULL, which is used by field_conv:set_field_to_null() and set_field_to_null_with_conversions() during the update
field_conv.cc:
Raise an error, not a warning, when NULL is set for NOT NULL columns
sql_load.cc:
Set ignore again, same as in sql_update.cc, but leave error as 1263 which gives additional information in a LOAD statement.
Added a null_test.txt file to check the LOAD DATA INFILE statement in null.test