Re: FYI: So called "SUM-Bug" in Informix 7.3

Posted in 1998

Steve Romankiw — Thu, 29 Oct 1998 12:28:40 -0500 — source: Informix-list mailing list archive (1991-1998)

This type of bug has been reported by several people. If fact we have ran into the same problem. I believe this problem is going to fixed in 7.30 UC6. This should be GA by around Thanksgiving. We are running on Solaris 2.5.1. Steve Romankiw Executive Risk Inc. Richard Spitz wrote: > Idiot wrote: > > > 1. create table x (d decimal(4,2)) > > 2. insert into x values(99.99), say 500 times. > > > > Now select sum(d) or avg(d) from x will cause sql error 1226. > > > > I could produce it in 7.30.UC3 on Solaris 2.6. My co-workers have produced > > it on HP-UX platform. > > Same on 7.30.UC3 on Reliant UNIX (SINIX) 5.43C30. > -- > +--------------------------+------------------------------------------+ > | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | > | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | > | Klinikum Grosshadern | FAX : +49-89-7095-8886 | > | 81366 Munich, Germany | GSM : +49-172-8933578 | > +--------------------------+------------------------------------------+