[hibernate-issues] [JIRA] (HHH-16504) Custom types in HQL

Алексей Макаров ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a93eff... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjNkNDU5NGMw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16504?atlOrigin=eyJpIjoiMjNkND... ) HHH-16504 ( https://hibernate.atlassian.net/browse/HHH-16504?atlOrigin=eyJpIjoiMjNkND... ) Custom types in HQL ( https://hibernate.atlassian.net/browse/HHH-16504?atlOrigin=eyJpIjoiMjNkND... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Unassigned Attachments: hibernate-orm-6.zip Components: query-hql Created: 24/Apr/2023 02:30 AM Priority: Major Reporter: Алексей Макаров ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a93eff... ) I have entity with field, that processed different string values to “true” or “false”. In real life i’ve used Oracle and Y/N, but H2Database successfully processed this values, so i choosed ‘#’ and ‘&’ as symbols for “true” and “false” I expect, that query analyzer will handle field’s type and tried to convert it by provided methods (for 5.6.3 worked version was f.flag=1 or f.flag=0) But currently it raised exception “Wrong number” for my production Oracle and Data conversion error converting “CHARACTER VARYING to BOOLEAN” for H2 ( https://hibernate.atlassian.net/browse/HHH-16504#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16504#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100223- sha1:77dfe11 )