[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3536) Projections ignores dialect

[Hauke Rabe (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31463#action_31463 ] 

Hauke Rabe commented on HHH-3536:
---------------------------------

In case of an aggregate projections for a boolean value PSQL is different to Oracle. PSQL has a boolean type whereas Oracle normally uses a int. So the query works on Oracle but not on PSQL cause of  "function min(boolean) does not exist".

SQL Oracle: select min(this.booleanValue) from Foo this
SQL PSQL: select min(case when this.booleanValue then 1 else 0) from Foo this

> Projections ignores dialect
> ---------------------------
>
>                 Key: HHH-3536
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3536
>             Project: Hibernate Core
>          Issue Type: Bug
>            Reporter: Hauke Rabe
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira