~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
..
1st.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 93 bytes Diff Download File
alter_table.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 32.9 KB Diff Download File
bench_count_distinct.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 438 bytes Diff Download File
bigint.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 16.2 KB Diff Download File
binlog_index.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.1 KB Diff Download File
bulk_replace.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 281 bytes Diff Download File
comment_column.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 98.5 KB Diff Download File
comment_column2.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 355 KB Diff Download File
comment_index.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 137 KB Diff Download File
comment_table.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 14.8 KB Diff Download File
comments.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 771 bytes Diff Download File
commit_1innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 7 KB Diff Download File
compare.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.7 KB Diff Download File
consistent_snapshot.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 268 bytes Diff Download File
constraints.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 847 bytes Diff Download File
count_distinct.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.2 KB Diff Download File
count_distinct2.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.2 KB Diff Download File
count_distinct3.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 219 bytes Diff Download File
create_select_tmp.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 846 bytes Diff Download File
ctype_filename.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 324 bytes Diff Download File
date_formats.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 24.5 KB Diff Download File
delete.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 11.3 KB Diff Download File
distinct.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 21.1 KB Diff Download File
drizzleslap.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 6.4 KB Diff Download File
drop_table.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 40 bytes Diff Download File
drop_table_if_exists.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 128 bytes Diff Download File
drop_table_temp.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 90 bytes Diff Download File
empty_table.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 226 bytes Diff Download File
endspace.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 6.5 KB Diff Download File
flush2.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 218 bytes Diff Download File
func_compress.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 4.3 KB Diff Download File
func_concat.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2 KB Diff Download File
func_crc32.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 250 bytes Diff Download File
func_date_add.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.5 KB Diff Download File
func_default.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.2 KB Diff Download File
func_equal.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.2 KB Diff Download File
func_gconcat.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 38 KB Diff Download File
func_group.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 38 KB Diff Download File
func_group_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.8 KB Diff Download File
func_if.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.6 KB Diff Download File
func_in.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 13.9 KB Diff Download File
func_isnull.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 270 bytes Diff Download File
func_like.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.5 KB Diff Download File
func_math.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 15.1 KB Diff Download File
func_misc.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.4 KB Diff Download File
func_op.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 809 bytes Diff Download File
func_sapdb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 9.7 KB Diff Download File
func_str.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 61.5 KB Diff Download File
func_time.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 51 KB Diff Download File
func_weight_string.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.7 KB Diff Download File
greedy_optimizer.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 39.8 KB Diff Download File
group_by.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 38.3 KB Diff Download File
group_min_max_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 4.7 KB Diff Download File
have_log_bin.require 656.1.10 15 years ago Monty Taylor Fixed a couple of moving oopses. 31 bytes Diff Download File
having.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 11.7 KB Diff Download File
heap.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 18.7 KB Diff Download File
heap_auto_increment.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 881 bytes Diff Download File
heap_btree.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 8.8 KB Diff Download File
heap_hash.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 13.3 KB Diff Download File
heap_var.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.6 KB Diff Download File
information_schema.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 18.1 KB Diff Download File
innodb-lock.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 994 bytes Diff Download File
innodb-semi-consistent.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 940 bytes Diff Download File
innodb_autoinc_lock_mode_zero-master.opt 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 29 bytes Diff Download File
innodb_autoinc_lock_mode_zero.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.2 KB Diff Download File
innodb_mysql.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 37.4 KB Diff Download File
innodb_notembedded.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 300 bytes Diff Download File
innodb_timeout_rollback.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 561 bytes Diff Download File
innodb_trx_weight.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 27 bytes Diff Download File
insert.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 7.7 KB Diff Download File
insert_select.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 11.8 KB Diff Download File
insert_update.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 9.4 KB Diff Download File
join.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 34.7 KB Diff Download File
join_crash.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 4.5 KB Diff Download File
join_nested.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 52.8 KB Diff Download File
join_outer.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 38.4 KB Diff Download File
join_outer_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 863 bytes Diff Download File
key.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 17.8 KB Diff Download File
key_diff.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 829 bytes Diff Download File
key_primary.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 667 bytes Diff Download File
keywords.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 798 bytes Diff Download File
kill.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1 KB Diff Download File
limit.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.7 KB Diff Download File
lock.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.9 KB Diff Download File
lock_tables_lost_commit.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 136 bytes Diff Download File
myisam-blob.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.1 KB Diff Download File
mysqldump-compat.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 111 bytes Diff Download File
mysqldump-max.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.5 KB Diff Download File
null.result 685.4.1 15 years ago Jay Pipes Enabled the null.test. * Fixed numerous SQL synta 9.3 KB Diff Download File
order_by.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 39.8 KB Diff Download File
order_fill_sortbuf.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 250 bytes Diff Download File
overflow.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 235 bytes Diff Download File
parser.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 32.7 KB Diff Download File
parser_bug21114_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 25.1 KB Diff Download File
parser_precedence.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 13.7 KB Diff Download File
pool_of_threads.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 55.2 KB Diff Download File
range.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 44.1 KB Diff Download File
replace.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 828 bytes Diff Download File
rollback.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 582 bytes Diff Download File
round.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 4.3 KB Diff Download File
row.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 14.3 KB Diff Download File
rowid_order_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.4 KB Diff Download File
schema.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 243 bytes Diff Download File
select.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 104 KB Diff Download File
subselect.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 156 KB Diff Download File
subselect3.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 26.9 KB Diff Download File
subselect_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 6.9 KB Diff Download File
sum_distinct.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.4 KB Diff Download File
synchronization.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 3.2 KB Diff Download File
tablelock.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 1.4 KB Diff Download File
true.require 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 7 bytes Diff Download File
type_blob.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 14.3 KB Diff Download File
type_date.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 7.7 KB Diff Download File
type_datetime.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 18.7 KB Diff Download File
type_float.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 8.7 KB Diff Download File
type_newdecimal.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 44.4 KB Diff Download File
type_ranges.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 12.4 KB Diff Download File
type_time.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 2.9 KB Diff Download File
type_timestamp.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 15.4 KB Diff Download File
type_uint.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 268 bytes Diff Download File
type_varchar.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 14.6 KB Diff Download File
unsafe_binlog_innodb.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 4.3 KB Diff Download File
update.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 11.7 KB Diff Download File
variables-notembedded.result 656.2.1 15 years ago Monty Taylor Moved non-working tests into broken suite for easi 555 bytes Diff Download File