@andatki The SCRUB_BATCHES procedure has an off-by-one bug that causes it to skip one row after each batch. Here is output showing the incorrect behavior: owner@localhost:5432 rideshare_development# CALL SCRUB_BATCHES(); NOTICE: current_id: 1 - Number of rows updated: 1000 NOTICE: current_id: 10…

Hi @douglasshuang . Thank you for the detailed bug report. I was able to verify what you’re saying and agree that the last assignment within the loop should not add 1. I took that off as you suggested and the print output matches what you have. I’m submitting a fix and hopefully it makes it into a f…

High Performance PostgreSQL for Rails: Off-by-one bug in `SCRUB_BATCHES` procedure (page 65)

Pragmatic Bookshelf PragProg Customers

douglasshuang 5 May 2025 13:51 3

My pleasure, Thank you!

1 Like