[hibernate-issues] [JIRA] (HHH-16771) group by someEntity where entity has json (not jsonb) columns results in failure on PostgreSQL

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16771 ( https://hibernate.atlassian.net/browse/HHH-16771?atlOrigin=eyJpIjoiYWY1Zj... ) Re: group by someEntity where entity has json (not jsonb) columns results in failure on PostgreSQL ( https://hibernate.atlassian.net/browse/HHH-16771?atlOrigin=eyJpIjoiYWY1Zj... ) Note that another workaround for top-level queries, other then obviously using jsonb instead of json as column type, would be grouping by the entity's primary key, e.g. group by b.id in your example, that will work on DBs that support functional group by dependency like PostgreSQL. ( https://hibernate.atlassian.net/browse/HHH-16771#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16771#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:62413c2 )