Please keep in mind, or disproove, that an explicit rollback also reverts any SQL module compilations done in the course of the transaction (in the same session).