Horton

Fix reset of incorrect hash iterator in GROUPING SETS queries

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: 0b6a02f0355c8950ffe22b52eac86f6261e19caf
Author: David Rowley <drowley@postgresql.org>
Date: 2025-10-18T03:07:41Z
Releases: 18.1 
Fix reset of incorrect hash iterator in GROUPING SETS queries

This fixes an unlikely issue when fetching GROUPING SET results from
their internally stored hash tables.  It was possible in rare cases that
the hash iterator would be set up incorrectly which could result in a
crash.

This was introduced in 4d143509c, so backpatch to v18.

Many thanks to Yuri Zamyatin for reporting and helping to debug this
issue.

Bug: #19078
Reported-by: Yuri Zamyatin <yuri@yrz.am>
Author: David Rowley <dgrowleyml@gmail.com>
Reviewed-by: Jeff Davis <pgsql@j-davis.com>
Discussion: https://postgr.es/m/19078-dfd62f840a2c0766@postgresql.org
Backpatch-through: 18

Files

PathChange+/−
src/backend/executor/nodeAgg.c modified +1 −1
src/include/lib/simplehash.h modified +4 −0

Discussion