Re: BUG #18264: Table has type text, but query expects integer.attribute 1 of type record has wrong type

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: vojtech(dot)benes(at)centrum(dot)cz, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18264: Table has type text, but query expects integer.attribute 1 of type record has wrong type
Date: 2024-01-04 07:43:00
Message-ID: CAApHDvqCFLu1kX7O41zrtTt+4WKF=bfaqoNqzvS8UeEwreLvMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, 31 Dec 2023 at 16:24, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> It looks like the problem is in ExecEvalPreOrderedDistinctMulti(). It
> overwrites the tmpcontext's slots but fails to properly restore the
> originals again.

I pushed a slightly revised version of this. I ended up adding a bool
isdistinct local variable so I didn't have to reset the slots in two
places. It kinda makes it easier to see what the true and false
means, so that might have been a good change regardless of the bug.

Thanks for reporting this Vojtěch and for the reproducer script.

David

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dilip Kumar 2024-01-04 10:13:20 Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication.
Previous Message Amit Kapila 2024-01-04 06:27:42 Re: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication.