Re[5]: [Firebird-devel] Computation problem in 1.5RC3

[Nickolay S. <sk...@bs...>]

Hello, Gabriel !

> Hi Ivan,

> Thursday, July 3, 2003, 9:59:48 PM, you wrote:

>>> IP> Look at documentation, rules for multiplication:
>>> IP> "If both operands are exact numeric, then multiplying or dividing the operands produces
>>> IP> an exact numeric with a precision of 18 and a scale equal to the sum of the scales of the
>>> IP> operands."
>>>
>>> Whoa, where did you find this? I searched the documentation before
>>> even posting to the list, and now, after I received your answer, I
>>> redownloaded documentation, searched again and still didn't find the
>>> above paragraph!

IP>> It is in Release Notes. (Beta Doc for IB6)

> Well, that explains it: Beta Doc (full set of manuals) downloaded from
> www.firebirdsql.org does not contain ReleaseNotes.pdf.
> Also Firebird15RC3 win32 kit does not contain ReleaseNotes.pdf.
> In ChangeLog.txt, WhatsNew.txt and InstallNotes.txt from Firebird
> 1.5RC3 there is no mention about this behaviour.
> So maybe I have to download Interbase 6.0 beta installation kit to
> find out such important (for me at least) behaviour of numerics (or to
> post a message on firebird-devel, wich I did ;-))

This behaviour is very strictly defined by SQL99 standard (and
possibly earlier standards too) this is why it is considered
well-known and is not documented explicitly.


Nickolay Samofatov