pg.ddx.io  pgdogdev/pgdog GitHub issues and pull requests  
help / 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