Re: Possible bug on Postgres 12 (CASE THEN evaluated prematurely) - Change of behaviour compared to 11, 10, 9

2020-06-04 Thread Juan Fuentes
Thanks Tom! I was just hopping somebody could point out if this kind of issue has been reported before spending 2 days fabricating a simpler self contained example. Best, Juan > On 4 Jun 2020, at 16:26, Tom Lane wrote: > > Juan Fuentes writes: >> As you could see the query in

Possible bug on Postgres 12 (CASE THEN evaluated prematurely) - Change of behaviour compared to 11, 10, 9

2020-06-04 Thread Juan Fuentes
Greetings, Our system uses an EAV like database and generates queries like the example below. As you could see the query includes castings, we noticed testing with Postgres 12 that the castings of the CASE THEN statement (commented out below) where failing in some cases, of course if you do th