Re: SUM in Informix 7.20 vs. Informix 6.0

May be you included value added tax in your first calculation ;-) But 30% vat is a *little* on the high side. Seriously this is more than critical if it's an Informix defect. This kind of bug seems too incredible to believe. What are the exact type and version numbers of your engine and 4GL? Have you tried to write a small 4GL program that does nothing but these calculations? Have you reported this to Informix? We are extremely interested in hearing the results. Please post again when you have talked to Informix. We have just taken delivery of the same engine on the same OS and hardware to a major customer. We are aware that version 7.20 have several bugs, but that whas what they delivered when we ordered the Wrokgroup Server. We also got 7.22 of Dynamic Server. Due to hollidays at Informix here in Norway we haven't been able to complain about this yet. It's somewhat crazy to deliver version 7.20 now. Kai Shen <kai_shen@ccmail.acer.de> wrote: :Dear all, : :we experienced some calculation problems with Informix 7.20 4GL on SCO :Unix 5.02. E.G. converting a cost value from Austrian Schilling to US :Dollar requires a multiplication with 12.11, say 1000.00*12.11. This :gave a result of 8900, whereas calculating 1000.00*12.10 resulted in :12100 and 1000.00*12.12 = 12120. This strange behaviour only occurs with :i4GL and under Informix 7.20, not with iSQL or Informix 6.0. : :A similar problem was caused by the SUM within i4GL, when using SELECT :firstvalue, SUM(anyvalue) FROM anytable GROUP BY 1. :Sometimes (not always) this SUM would be wrong. What does sometimes mean? Where there different data, different programs or some other differense? How wrong would the sum be? :Is it only us to have this problem? Yes, we are running Intel Pentium :Pro 200, but an error of 30% is a little bit too high, right? An error of *anything* is too high. I have never had any problems of this kind over some 15 years of using Informix software. :TIA, Regards :Kai Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org