pg.ddx.io pgdogdev/pgdog GitHub issues and pull requestshelp / color / mirror / Atom feed
[pgdogdev/pgdog] issue #2043: Cached query plans causing wrong results with OFFSET 3+ messages / 1 participants [nested] [flat]
* [pgdogdev/pgdog] issue #2043: Cached query plans causing wrong results with OFFSET @ 2026-11-15 18:50 "murex971 (@murex971)" <noreply+murex971@github.com> 0 siblings, 0 replies; 3+ messages in thread From: murex971 (@murex971) @ 2026-11-15 18:50 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> **PgDog version** `main` **Description** PgDog caches prepared statements by SQL text only. If the same query runs first on an unsharded database and then on a sharded one, the sharded database reuses the unsharded plan. Each shard then applies OFFSET, and PgDog applies it again after merging. Rows get skipped, with no error. ^ permalink raw [nested|flat] 3+ messages in thread
* Re: [pgdogdev/pgdog] issue #2043: Cached query plans causing wrong results with OFFSET @ 2026-11-19 09:33 "murex971 (@murex971)" <noreply+murex971@github.com> 1 sibling, 0 replies; 3+ messages in thread From: murex971 (@murex971) @ 2026-11-19 09:33 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> @murex971 applied label "accepted". ^ permalink raw [nested|flat] 3+ messages in thread
* Re: [pgdogdev/pgdog] issue #2043: Cached query plans causing wrong results with OFFSET @ 2026-11-19 12:45 "murex971 (@murex971)" <noreply+murex971@github.com> 1 sibling, 0 replies; 3+ messages in thread From: murex971 (@murex971) @ 2026-11-19 12:45 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> a long term solution for this to fix the caching plan itself, maybe add database and sharded table hash to cache key so we know when to apply it also clear cache on config reload ? ^ permalink raw [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-11-19 12:45 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-11-15 18:50 [pgdogdev/pgdog] issue #2043: Cached query plans causing wrong results with OFFSET "murex971 (@murex971)" <noreply+murex971@github.com> 2026-11-19 09:33 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2026-11-19 12:45 ` "murex971 (@murex971)" <noreply+murex971@github.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox