unit test for coalesce on insert