Mark Rotteveel wrote 31.08.2021 19:05:
What does SQL standard say about it?Not much, beyond "iv) The precision and scale of the result of division are implementation-defined."
So theoretically result of division of two exact numbers can be inexact number like DOUBLE PRECISION but it has not enough precision to make 1/3*3=1 anyway.
-- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel