I found in one of my oldder program which supplied to other people/customers, I can use continous number comparisons like this: 300 < num < 900 with the h2 database version: 1.4.196. While the new(not newest) h2 database with version 2.0.206, it comes to a error: [90110-206] Values of types "BOOLEAN" and "INTEGER" are not comparable;
The smallest reproduction case: CREATE TABLE rxt1_ABI35149 ( id_ varchar(32), num_ decimal(12,2) ) INSERT INTO rxt1_ABI35149 VALUES ('a', 230); INSERT INTO rxt1_ABI35149 VALUES ('b', 500); SELECT * FROM rxt1_ABI35149 SELECT id_, CASE WHEN a.NUM_ < 300 THEN '5分钟以下' ELSE (CASE WHEN 300 <= a.NUM_<900 THEN '5分钟(含)~15分钟' ELSE (CASE WHEN a.NUM_ >= 1800 THEN '30分钟及以上' ELSE '15分钟(含)~30分钟' END) END) END FROM rxt1_ABI35149 a Why the act changed ? How can I fix it ? -- 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/234073e7-9f4a-495d-b789-da3a232f26f6n%40googlegroups.com.