Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTVkZjczYjkz... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15578?atlOrigin=eyJpIjoiNTVkZj... ) HHH-15578 ( https://hibernate.atlassian.net/browse/HHH-15578?atlOrigin=eyJpIjoiNTVkZj... ) Add min/max emulation for uuid on PostgreSQL ( https://hibernate.atlassian.net/browse/HHH-15578?atlOrigin=eyJpIjoiNTVkZj... ) Issue Type: Improvement Affects Versions: 6.1.4 Assignee: Unassigned Components: hibernate-core Created: 05/Oct/2022 01:14 AM Fix Versions: 6.1.5 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In https://hibernate.atlassian.net/browse/HHH-15495 ( https://hibernate.atlassian.net/browse/HHH-15495 ) we made sure UUID is treated as comparable type, which works great, except on PostgreSQL for the min / max aggregate functions. The workaround/emulation is to cast to text and the result of the aggregate function to uuid again. It’s not very efficient to do the casting, but it’s the best we can do without requiring users to add functions to PostgreSQL. Let’s make sure though, that users could override this behavior in a custom dialect subclass. ( https://hibernate.atlassian.net/browse/HHH-15578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15578#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#100207- sha1:427dab2 )