Hello! Such expression is not valid in SQL. You need to write it as 300 < num AND num < 900.
In historic versions of H2 boolean result of 300 < num (TRUE, FALSE, or NULL /UNKNOWN) was treated as 1, 0, or NULL and compared with 900. The whole expression returned NULL if num is a null value and TRUE otherwise. Modern versions of H2 protect you from that type of mistakes. -- 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 view this discussion visit https://groups.google.com/d/msgid/h2-database/ea5c8b06-27e8-47e8-929a-43f05fcd5216n%40googlegroups.com.
