The row level security example will break transactions, so they won't roll back. A way to avoid it, is to use interactive transactions only. This guide might be helpful: https://github.com/prisma/prisma/discussions/25034 (This claim is valid for Prisma Client 5.14.0)