BUG #17818: CTE is not returning the right data.

On Thursday, March 2, 2023, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17818
> Logged by: Shiau Hoay Ong
> Email address: cute_hoay88(at)hotmail(dot)com
> PostgreSQL version: 12.1
> Operating system: window
> Description:
>
> Hi Postgresql Support Team, today i encounter a mystery case. The Stored
> Procedure is already used for sometime, but today there are some issue in
> this Stored Procedure which causing the data got deleted. The scenario is
> like sample below :
>
>
> I do try out with Create Temp Table also work fine with the sample without
> need filtering (as filtering will only reduce data record set).
> Can you please help to investigate and explain what is the possible root
> cause for this?
> Thanks!
>
>
Upgrade to a supported minor release and probably rebuild all indexes
(though being windows I’m less sure about collation issues…)

David J.