Slick compare table column with null

Question

Can someone please tell me how do we compare a table column against NULL using slick's lifted embedding.

What i want to achieve in mysql:

select * from Users where email = '<some_email_addr>' and ( removed = NULL OR removed <= 1 )

It gives me an errors at x.removed === null when i try:

val q = for {
    x <- Users
        if x.email === email && ( x.removed === null || x.removed <= 1 )
} yield x.removed

Thanks

Answer 1

Try:

x.removed.isNull

I think that is what you are looking for

Answer 2

As daaatz said and per http://slick.typesafe.com/doc/2.1.0/upgrade.html#isnull-and-isnotnull you should use isEmpty, but it only works on Option columns. A workaround is x.removed.?.isEmpty.

Answer 3

Try

x.removed.isEmpty()

There are no nulls in scala ;-)