The SELECT of a column based on a numerical expression could result
into the output of 0E-nn, 0E-27 in my sample.
This is a correct, but a bit a stupid representation of the value
zero.
Maybe this could be fixed.
Thanks.
The test case:
CREATE SCHEMA IF NOT EXISTS TEST AUTHORIZATION SA;
CREATE CACHED TABLE IF NOT EXISTS TEST.TEST(
PRM NUMERIC(8, 2),
SBT NUMERIC(8, 2)
);
INSERT INTO TEST.TEST(PRM, SBT) VALUES (17852.08, 0.00);
SELECT PRM, SBT, CASE WHEN PRM > 0 THEN 100 / PRM * SBT ELSE 0 END
FROM TEST.TEST;
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
