Skip to content

PostgreSQL case in where clause errror #1538

@dreab8

Description

@dreab8

Version

5.0.0

Context

Wile working on Hibernate Reactive I noticed that
using PostgreSQL the query using client.preparedQuery(sql).execute(parameters):

select f1_0.id,f1_0.age,f1_0.rating,f1_0.title
from Film f1_0
where f1_0.age<=case when (f1_0.rating=$1) then $2 when (f1_0.rating=$3) then $4 else $5 end
order by f1_0.id

with parameters [1,2,3,4,5].

It throws:

operator does not exist: integer <= text (42883)] [select 
f1_0.id,f1_0.age,f1_0.rating,f1_0.title from Film f1_0 where f1_0.age<=case when (f1_0.rating=$1) then $2 when (f1_0.rating=$3) then $4 else $5 end order by f1_0.id]

Steps to reproduce

No response

Do you have a reproducer?

No response

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions