Thanks for your message. This is due to the following incompatible change in jOOQ 3.10: https://github.com/jOOQ/jOOQ/issues/5818
The change in the behaviour of the fetch() method also affected the behaviour of the MockDataProvider. We've already improved the documentation to reflect that: https://github.com/jOOQ/jOOQ/issues/6774 https://github.com/jOOQ/jOOQ/issues/6923 There is also a discussion here, which I recommend reading: https://github.com/jOOQ/jOOQ/issues/6907 Essentially, there has been a misunderstanding around the design of MockResult(0, null), in particular the null part. In SQL, in JDBC, and in jOOQ, there are no ResultSets with no columns / unknown columns. So, if you pass a "null" Result to the MockResult, the only reasonable meaning is that there are no results at all (not even an empty result). That's the way MockResult was designed before, and your tests were already wrong before (but may have accidentally passed). jOOQ 3.10 (with #5818) now changes in a way that when you fetch a result from what does not return a result, you're getting an 1x1 result containing update count - 0 in your case. If you want to create a MockResult for the query selecting MPS_PEOPLE.FIRST_NAME, then you should create an empty result containing exactly that column and return that. Again, a more detailed discussion is available in https://github.com/jOOQ/jOOQ/issues/6907 I hope this helps, Lukas 2017-12-22 9:26 GMT+01:00 Paul Hamer <[email protected]>: > Forgot to mention that, obviously, I've had jOOQ regenerate all sources > after switching between the two jOOQ versions. > > -- > 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/d/optout. > -- 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/d/optout.
