Three issues:
1) The MySQL Dialect with my version of hibernate (3.2) doesnt seem to declare some of the MySQL control flow functions (IFNULL, NULLIF etc...). Am I missing something?
2) HQL doesn't seem to support these kind of functions or something similar in the SELECT clause. I am trying to do something like:
Code:
SELECT ifnull(i.price.price,0.0) as avgPrice
from Item i...
or even
Code:
SELECT {fn ifnull(i.price.price,0.0)} as avgPrice
from Item i...
3) HQL doesn't seem to support function chaining/nesting in the select clause, somehting like:
Code:
SELECT avg(ifnull(i.price.price,0.0)) as avgPrice
from Item i...
The avg() and other functions seem to expect only a column name as the argument and not allow for another nested function...
Thanks for any help...
Eric
Login
FAQ
Search