Molnár Attila wrote 01.09.2021 8:29:
The problem: why the storage format has affect on calculation. It just feels wrong.
It is ordinary thing in all programming languages when data types decide calculation rules. In the Delphi product of integer division used to be floating point, but that's Pascal exclusive rules. SQL (including Firebird) is based rather on C where division of two integers produce integer.
What is the point of dialect 3 when it does not spare work, it just replace one boilerplate code writing to an other?
If it doesn't work the way you expect it doesn't mean that it works wrong. Just accept that rules of arithmetic are different in different programming languages and perform calculations in the language which comply with your goals.
-- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
