pgsql: Update query_id computation

Started by Bruce Momjianabout 5 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Update query_id computation

Properly fix:

- the "ONLY" in FROM [ONLY] isn't hashed
- the agglevelsup field in GROUPING isn't hashed
- WITH TIES not being hashed (new in PG 13)
- "DISTINCT" in "GROUP BY [DISTINCT]" isn't hashed (new in PG 14)

Reported-by: Julien Rouhaud

Discussion: /messages/by-id/20210425081119.ulyzxqz23ueh3wuj@nol

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f7a97b6ec31f3f57a6154d0039c4de81ad517064

Modified Files
--------------
.../expected/pg_stat_statements.out | 151 +++++++++++++++++++++
.../pg_stat_statements/sql/pg_stat_statements.sql | 52 +++++++
src/backend/utils/misc/queryjumble.c | 4 +
3 files changed, 207 insertions(+)