I now understand and agree with you, thanks for your reply! On Tue, Jul 22, 2025 at 8:12 AM Evgenij Ryazanov <kat...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com. > 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 h2-database+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/h2-database/CA%2B7nhiGSEycN%2BB%2BQygV4gp0WavhS1iH4Ah2w5FOMo_xMS%2B1k0Q%40mail.gmail.com.
