~drizzle-trunk/drizzle/development

  • 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
Filename Latest Rev Last Changed Committer Comment Size
..
innochecksum.c 660.1.3 15 years ago Eric Herman removed trailing whitespace with simple script: f 9.1 KB Diff Download File
Makefile.am 584.1.3 15 years ago Monty Taylor Merged from David. 989 bytes Diff Download File
my_print_defaults.cc 656.1.26 15 years ago Monty Taylor Finally removed all of the my_malloc stuff. 6 KB Diff Download File
mysql_waitpid.cc 660.1.3 15 years ago Eric Herman removed trailing whitespace with simple script: f 2.8 KB Diff Download File