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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/h2-database/234073e7-9f4a-495d-b789-da3a232f26f6n%40googlegroups.com.
