Hi all

SELECT
ROUND(-1.4),
ROUND((-1.4)),
ROUND(ABS(-1.4))
FROM
RDB$DATABASE
;

ROUND ROUND ROUND
============ ============ ============
-1 -1 <null>

SELECT
CEILING(-1.4),
CEILING((-1.4)),
CEILING(ABS(-1.4))
FROM
RDB$DATABASE
;

CEILING CEILING CEILING
======================= ======================= =======================
-1.000000000000000 -1.000000000000000 2.000000000000000


ROUND(ABS(-1.4)) returns 1 is correct I think?

I think it is caused by ABS() is in ib_udf and ROUND() is in fbudf. Is
this correct? Is this bug?

Tsutomu Hayashi in Japan
Mail : hayashi@...
Web : http://www.apex-jp.com/ (Japanese Only)
http://dmj.psnet.ne.jp/ (Delphi Magazine)