-
Notifications
You must be signed in to change notification settings - Fork 208
Open
Description
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