hibernate ifnull
mysql中sql语句的ifnull函数,在hibernate的hql中可用coalesce代替。
例:
mysql的sql:select ifnull(max(sort),0) from table;
hibernate的hql:select coalesce(max(sort),0) from table;
经测试,这2个sql在mysql中都能执行:
select ifnull(max(sort),0) from table;
select coalesce(max(sort),0) from table;
----------------------------------------------------------------------------------------
参考:https://forum.hibernate.org/viewtopic.php?f=1&t=938874