model-writtenrun 9352 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alexander Korotkov reported an EXPLAIN failure with “bogus varno: 65000” for a hash join containing a subplan, crediting Nikita Glukhov with finding it and providing a reproducer in #1.
- Andres Freund traced the problem to executor startup installing hash expressions into a subsidiary HashState and proposed storing those expressions in the Hash plan node itself in #3.
- Tom Lane proposed reverting the earlier executor fix and postponing a planner-assisted solution in #4, but Andres warned that reverting would restore assertion failures in #5.
- Andres posted a prototype that splits hash expressions during planning and gives Hash its own correctly referenced keys in #6, rejecting workarounds that would slow execution or complicate deparsing; merging Hash and HashJoin remained a possible future redesign.
- Tom reviewed the prototype in #9, supporting its direction while requesting a regression test, clearer comments and moving the new Hash field away from the structure's end.
- Andres committed the revised prototype as 2abd7ae9b2, additionally moving outer hashkeys, operators and collations into planning and adding subplan-heavy regression coverage; his closing message #10 confirmed the push, leaving the reported bug fixed.