An unexpected result was encountered after executing a Query. This exception indicates wrong usage of jOOQ's various fetch methods, or an integrity problem in your data after query execution, meaning that the execution of the query in the database is not affected.

This is typically the case in the following situations:

• When you call methods such as ResultQuery#fetchOne() and the database returns more than one record (you'll get a TooManyRowsException).
• When you call methods such as ResultQuery#fetchMap(org.jooq.Field) and the database returns several records per key.
• When you refresh a TableRecord using UpdatableRecord#refresh(), and the record does not exist anymore in the database (you'll get a NoDataFoundException).