Failing test showing broken db-side default value handling

Added some additional tests, including one showing a case where an
exception is thrown while trying to insert a shadow row that missed a
default column value (current date/time) populated by the db. Failing
test is surrounded by explanatory comments