On Thursday, March 2, 2023, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 17818
Logged by: Shiau Hoay Ong
Email address: cute_hoay88@hotmail.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.