isNull() though form correct SQL query for H2 - it returns '0' records. same query when executed directly using H2 UI console, returns correct records.
On Tuesday, November 4, 2014 10:51:09 AM UTC-8, [email protected] wrote: > > Hi, > > I have a table in H2 having column of type string with null as well as > empty value. > > So like to know jooq condition to select empty values for a row. > > jooq --> field.isNull() check allows me to select null value > > however for empty value tried following, but its not working. > > field.length.eq(0) or field.eq("") > > Could you please provide any pointers, whats going wrong here? > > Thanks > > > -- 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.
