RE: Bug with update...

Posted in 1998

Alain Martin — Wed, 25 Feb 1998 10:52:10 -0500 — source: Informix-list mailing list archive (1991-1998)

On 24 fevrier, 1998 16:29, Vickey Crouch [SMTP:vcrouch@matcom2.fcic.usda.gov] wrote: > How do you know only one row was updated? > > > Hi, > > > > I've got a strange bug (called "erotic bug" by us :-)). I ran an "update" > > who updade physically one (1) row but dbaccess or esql-c tell me that the > > are two (2) rows updated! > > > > Does anybody have I idea why? > > > > Thanks > > > > Alain Martin > > INT Systemes d'Information Inc. > > alainmartin@POBoxes.com > > amartin@magrit.com > > There is only one row that meet my condition. I use count with the condition and i got a result of one (1). I think the problem is with indexes. I rebuilt the indexes and this fix the problem. Bye