How a seemingly straightforward DELETE query using a CTE and LIMIT returned more rows than expected due to query planner optimization.