Thank you very much for reporting. Indeed, we guarded against this situation in single value IN predicates, but not row value IN predicates. I've created an issue for this: https://github.com/jOOQ/jOOQ/issues/4437
And a fix: https://github.com/jOOQ/jOOQ/commit/a01a4720b381075d92f4be7120b4ce6b528eab88 Cheers, Lukas 2015-07-31 10:01 GMT+02:00 jdoe <[email protected]>: > Strange bug appeared: > > > FIELD1.in(emptyIdsCollection()).or(DSL.row(FIELD2,FIELD3).in(emptyRowsCollection)) > > Generates something like: > > where ( > 1 = 0 /* which is OK */ > or (field2, field3) in () /* invalid syntax */ > ) > > I'm looking forward to seeing a fix! > > -- > 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.
