[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5192) Can't use group_concat in mysql without creating a custom function

[Douglas Ferguson (JIRA)]

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

Douglas Ferguson commented on HHH-5192:
---------------------------------------

How do you guys create test cases?  Since this is a mysql issue how do you handle schema and user setup. etc....

This is a really simple one, just run a simple query select group_concat(column) from table group by column;





> Can't use group_concat in mysql without creating a custom function
> ------------------------------------------------------------------
>
>                 Key: HHH-5192
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5192
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.5.1
>         Environment: Linux, Mysql 
>            Reporter: Douglas Ferguson
>
> After upgrading we starting getting the exception below and had to register a "custom" function..
> Caused by: org.hibernate.HibernateException: Unable to locate mapping for function named [group_concat]
> at org.hibernate.criterion.AggregateProjection.getFunction(AggregateProjection.java:93)
> at org.hibernate.criterion.AggregateProjection.getFunction(AggregateProjection.java:85)
> at org.hibernate.criterion.AggregateProjection.getTypes(AggregateProjection.java:64)
> at org.hibernate.criterion.ProjectionList.getTypes(ProjectionList.java:61)
> at org.hibernate.loader.criteria.CriteriaQueryTranslator.getProjectedTypes(CriteriaQueryTranslator.java:362)
> at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:101)
> at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:83)
> at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:92)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1687)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)

-- 
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