added tests for new behavior
allow for nulls in updates and inserts