Hi Gunther >> As a workaround, I am using a patched version of the AbstractSelect >> class where the asTable(String alias) method does not delegate to the >> no-arg variant but creates the SelectQueryAsTable directly. This >> avoids the call to hashCode() and the exception. I think it also makes >> more sense this way because the current code generates an alias >> unnecessarily. > > Unfortunately, this alias is necessary in some database dialects, if I > remember correctly. But it makes sense to review that code again.
Removing this alias will break the following integration tests on most databases, including MySQL: - testCombinedSelectQuery() - testComplexUnions() - testOrderByInSubquery() - testJoinQuery() - testCrossJoin() All of which use subqueries. I advise you do not patch jOOQ this way. I'll continue investigation. The actual bug is likely to be found in the missing dialect specification for the extract function. Cheers Lukas
