[h2] NOT IN also excludes NULL values, intended?

Hi, Executing the following statements only returns records with num != NULL. Is that the intended behavior? CREATE TABLE yyy (num DECIMAL(7)) / INSERT INTO yyy VALUES (NULL) / INSERT INTO yyy VALUES (1) / INSERT INTO yyy VALUES (5) / INSERT INTO yyy VALUES (NULL) / SELECT * FROM yyy WHERE

Re: [h2] NOT IN also excludes NULL values, intended?

Hi, Yes, this is how other databases work as well. The reason is that a comparison with NULL results in NULL. And NOT NULL is also NULL. And NULL means no match. Regards, Thomas On Fri, Nov 14, 2014 at 9:08 AM, christoff.schm...@finaris.de wrote: Hi, Executing the following statements only