Re: v17 Possible Union All Bug

Andrei Lepikhov <a.lepikhov@postgrespro.ru>

From: Andrei Lepikhov <a.lepikhov@postgrespro.ru>
To: Alexander Korotkov <aekorotkov@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Alexander Korotkov <akorotkov@postgresql.org>, PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Date: 2024-02-01T09:53:47Z
Lists: pgsql-bugs

Attachments

On 1/2/2024 11:06, Andrei Lepikhov wrote:
>> Thank you for noticing.  I'm investigating this.
> Very curious bug. I simplified the test a bit (see in attachment), but 
> still can't replace system tables, like pg_authid, with a plain table. 
> Will try further.
Just for speedup the bug scrutiny - new replay script attached.

-- 
regards,
Andrei Lepikhov
Postgres Professional

Commits

  1. Fix usage of aggregate pathkeys in group_keys_reorder_by_pathkeys()

  2. Move is_valid_ascii() to ascii.h.

  3. Test EXPLAIN (FORMAT JSON) ... XMLTABLE

  4. Add test module injection_points

  5. Fix table name collision in tests in 0452b461bc

  6. Explore alternative orderings of group-by pathkeys during optimization.

  7. Generalize the common code of adding sort before processing of grouping

  8. Reorder actions in ProcArrayApplyRecoveryInfo()

  9. More documentation updates for incremental backup.

  10. Avoid useless ReplicationOriginExitCleanup locking