[reporter="jhyde", created="Fri, 17 Mar 2006 15:09:03 -0500 (GMT-05:00)"]
The testing of the CAST operator is incomplete. One of the side-effects is that
CAST(-125.75) produces -125 on the Java implementation, -126 on the C++
implementation. The FarragoSqlOperatorsTest is designed to ensure that C++ and
Java implementations of functions produce the same result, but it can only do so
if exhaustive tests are written.
The numeric cast tests should include tests for negative numbers, test whether
cast rounds / truncates towards zero / truncates torwards -infintiy, and test
overflow and conditions.
This task should also add tests for CEIL and FLOOR.
------- Comment #1 From Julian Hyde 2005-02-28 19:19 [reply] -------
I meant to say:
[reporter="jhyde", created="Fri, 17 Mar 2006 15:09:03 -0500 (GMT-05:00)"] The testing of the CAST operator is incomplete. One of the side-effects is that
CAST(-125.75) produces -125 on the Java implementation, -126 on the C++
implementation. The FarragoSqlOperatorsTest is designed to ensure that C++ and
Java implementations of functions produce the same result, but it can only do so
if exhaustive tests are written.
The numeric cast tests should include tests for negative numbers, test whether
cast rounds / truncates towards zero / truncates torwards -infintiy, and test
overflow and conditions.
This task should also add tests for CEIL and FLOOR.
------- Comment #1 From Julian Hyde 2005-02-28 19:19 [reply] -------
I meant to say:
...and test overflow and underflow conditions.