DB2 SQL Error: SQLCODE=-214, SQLSTATE=42822 using Hibernate

Issue

• An HQL typed query uses DISTINCT and ORDER BY where the ORDER BY columns include a column that cannot be mapped to the HQL return type

  Raw

  SELECT DISTINCT employee FROM Employee employee, Task task ... ORDER BY employee.name, task.id
  

• The database driver raises an exception indicating the un-mapped column is illegal in the ORDER BY clause

  Raw

  DB2 SQL Error: SQLCODE=-214, SQLSTATE=42822, SQLERRMC=id;ORDER BY;2, DRIVER=4.15.134