I have table ABC in H2 defined as CREATE TABLE ABC (A int,B varchar(30) DEFAULT NULL,C varchar(100) DEFAULT NULL);
I would like to run a query: Select * from ABC where C IS NULL; Expected Result: All the values where C is null. Obtained Result: No values at all... Only the table structure. It works when I give where C='null'. How can I use the IS NULL in H2. I tried by setting url as jdbc:h2:mem:configurations;DB_CLOSE_DELAY=-1;MODE=PostgreSQL. It didn't work as expected.The query works fine with Postgres I am also using Postgres Db . -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
