Ariel,
No, you are correct.. To get that effect, you should use the *.isNull()*
method on the field type:
.where(MYTABLE.MYFIELD.isNull()).fetchOne()
Cheers,
Deven
On Wednesday, June 25, 2014 6:18:13 PM UTC-4, Ariel Tal wrote:
>
> 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.
