No the scale is implementation dependent with numeric division, however there
is no doubt that in this case it should be handled as integer division.
Mark
----- Reply message -----
Van: "Dimitry Sibiryakov" <s...@ibphoenix.com>
Aan: "For discussion among Firebird Developers"
<firebird-devel@lists.sourceforge.net>
Onderwerp: [Firebird-devel] Literals in CASE expression
Datum: wo, jan. 6, 2016 11:37
06.01.2016 1:03, Arno Brinkman wrote:
> Well..... this :
>
> SELECT 1 / 3 FROM RDB$DATABASE
> SELECT 1.0 / 3 FROM RDB$DATABASE
>
> should return 0.33333333333333333333333, agree ?
Actually, I agree. I believe that division should produce double precision
result.
06.01.2016 8:28, Mark Rotteveel wrote:
> changing the math that is clearly described in the standard to something else
> is plain
wrong.
According to a quote from standard that was discussed a couple of months ago,
it is not
described clearly, but left as "implementation-dependent".
--
WBR, SD.
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
