pg.ddx.io pgdogdev/pgdog GitHub issues and pull requestshelp / color / mirror / Atom feed
[pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows 4+ messages / 1 participants [nested] [flat]
* [pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows @ 2026-10-31 21:32 "murex971 (@murex971)" <noreply+murex971@github.com> 0 siblings, 0 replies; 4+ messages in thread From: murex971 (@murex971) @ 2026-10-31 21:32 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> **Description** When a query groups by a SELECT alias, PgDog doesn't recognize the alias as a GROUP BY column. When it merges results from the shards, it puts every row into one group. Example: `SELECT name AS n, count(*) FROM orders GROUP BY n;` Postgres: ``` alice | 3 bob | 2 carol | 2 dave | 1 ``` PgDog: ``` bob | 8 ``` Grouping by the column name (GROUP BY name) or by position (GROUP BY 1) works correctly. **Reference** Vitess's end-to-end aggregation tests: [aggregation_test.go#L798](https://github.com/vitessio/vitess/blob/bf549e216779899ee12110b751132849f0920721/go/test/endtoend/vt...) ``` SELECT DATE(val1) AS date, SUM(val2) FROM aggr_test_dates GROUP BY date HAVING SUM(val2) > 100 ``` ^ permalink raw [nested|flat] 4+ messages in thread
* Re: [pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows @ 2026-11-17 14:23 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2 siblings, 0 replies; 4+ messages in thread From: murex971 (@murex971) @ 2026-11-17 14:23 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> @murex971 assigned @murex971. ^ permalink raw [nested|flat] 4+ messages in thread
* Re: [pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows @ 2026-11-19 12:31 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2 siblings, 0 replies; 4+ messages in thread From: murex971 (@murex971) @ 2026-11-19 12:31 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> handled in #2050 ^ permalink raw [nested|flat] 4+ messages in thread
* Re: [pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows @ 2026-11-19 12:31 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2 siblings, 0 replies; 4+ messages in thread From: murex971 (@murex971) @ 2026-11-19 12:31 UTC (permalink / raw) To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com> @murex971 closed this. ^ permalink raw [nested|flat] 4+ messages in thread
end of thread, other threads:[~2026-11-19 12:31 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-10-31 21:32 [pgdogdev/pgdog] issue #1927: Cross-shard GROUP BY on a SELECT alias returns wrong rows "murex971 (@murex971)" <noreply+murex971@github.com> 2026-11-17 14:23 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2026-11-19 12:31 ` "murex971 (@murex971)" <noreply+murex971@github.com> 2026-11-19 12:31 ` "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