Hacker News new | ask | show | jobs
by itishappy 932 days ago

    SELECT * FROM Foobar WHERE Val = NULL;
no results

I'm admittedly still learning SQL, but I'm very surprised by this.

The query should be:

    SELECT * FROM Foobar WHERE Val IS NULL;