I now understand and agree with you, thanks for your reply! On Tue, Jul 22, 2025 at 8:12 AM Evgenij Ryazanov <[email protected]> wrote:
> 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 > <https://groups.google.com/d/msgid/h2-database/ea5c8b06-27e8-47e8-929a-43f05fcd5216n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CA%2B7nhiGSEycN%2BB%2BQygV4gp0WavhS1iH4Ah2w5FOMo_xMS%2B1k0Q%40mail.gmail.com.
