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

Posted in 1998

Richard Spitz — Thu, 29 Oct 1998 09:51:18 +0100 — source: Informix-list mailing list archive (1991-1998)

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 | +--------------------------+------------------------------------------+