• Got it wrong because I misread the UNION for UNION ALL. I focused on the transaction rollback and therefore counted the number rows with 3 in it in the first insert statement.

    Good question. A good reminder that assumptions seldom leads to any good!