Exists in Hibernate 5.0.5 final. A JPQL query like the following (or criteria),
SELECT c FROM Country c WHERE lower(trim(c.countryName)) LIKE '%a%'
Generates the corresponding SQL query correctly as expected but it leaves warnings like
org.hibernate.dialect.function.TemplateRenderer] (default task-55) HHH000174: Function template anticipated 4 arguments, but 1 arguments encountered
unless those two functions namely lower() and trim() are excluded from the JPQL. |