If I try the code below in SQL Server database selectQuery.addSelect(Employee.EMPLOYEE.EMPLOYEE_DESC); selectQuery.addFrom(Employee.EMPLOYEE);
it generates SQL as below: select dbo.Employee.Description from dbo.Employee order by 1 which throws exception as below. Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Why does jOOQ adds order by 1? can that be removed? -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
