According to ArgumentTypesValidator.checkType() the types BINARY and UUID are not comparable. This means that trying to use the aggregator MAX or MIN on a UUID column while grouping (SELECT MAX(id) FROM x GROUP BY id) results in the error message “Parameter 1 of function max() has type COMPARABLE, but argument is of type java.util.UUID”. This is a problem, especially since mysql natively supports UUIDs since version 8. |