When inserting multiple rows, the end state should be that all non-conflicting rows are successfully inserted, while conflicting rows are silently dropped.
When we ask for the number of affected rows after the query, we should get a count of the rows which were inserted.
Good to know, thanks, I'll code that up.