Doesn't appear to be related to any particular data-type. It didn't work for String, Integer and Enum data-types. Using JOOQ 3.1.0.
Thanks On Wednesday, June 25, 2014 6:02:31 PM UTC-4, Ariel Tal wrote: > > This is possibly related to: > https://groups.google.com/forum/#!searchin/jooq-user/eq(null)/jooq-user/xmkOXh6VxdQ/QpAzJlEK2k0J > > > If you try to compare a field to a variable using > MY_TABLE.MY_FIELD.eq(myVar) and myVar happens to be null, the resulting > condition in the query (for MySQL) will be: > `MY_TABLE`.`MY_FIELD` = null instead of `MY_TABLE`.`MY_FIELD` IS NULL (as > it should). > > > Is this a known issue? > > Thanks, > Ariel > -- 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.
