Re: need help

Posted in 1998

Art S. Kagel — Mon, 07 Dec 1998 15:04:18 -0500 — source: Informix-list mailing list archive (1991-1998)

Reynald Gastebois wrote: > > Hi, > > I work on Enterprise Server 351, on HPUX 10.20, accessing INFORMIX 7.20 > via Livewire (Javascript). > > My problem is with count(*) or sum() in Livewire DB requests. > > It used to work but, since I upgraded SQL from 6.04.UC2 to 7.20.UD4, the > > result of a count(*) or sum() is wrong: > > for count(*), it is 10 times the right number > for sum(), it is 10 times the right number, + it does not care about > decimal, i.e. I receive 1038 for 10.38 !!! > > I wonder if the problem is due to livewire or the Informix Client > 7.20... > > Does anyone know about that? I have a suspicion! In going from 6.0x to 7.xx, with the addition of fragmented tables, Informix had to change the result of aggregates that returned INTEGER to return DECIMAL(32) since a COUNT(*) could now return a count > 2^31. Livewire may be incorrectly converting the value from DECIMAL to INTEGER. Art S. Kagel