-
Committer:
Jay Pipes
-
Date:
2008-12-17 04:02:20 UTC
-
Revision ID:
jpipes@serialcoder-20081217040220-b062yr3pwibi0j2o
Enabled the null.test.
* 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