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

Posted in 1998

Idiot — 29 Oct 1998 20:08:38 GMT — source: Informix-list mailing list archive (1991-1998)

For Solaris 2.5.1 a new version is already available. Please check out the attachment in my previous post. Idiot Steve Romankiw wrote in message <71a9jr$ght$1@news.xmission.com>... > >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 | >> +--------------------------+------------------------------------------+ >