No, this is not a bug, but most likely caused by the dirty read isolation.
Remember that dirty read casues the cursor or select to return EVERY ROW
that there, including the one that are (partially) entered, deleted, update
and not rolled back or committed.

------------------------------------------------------------------------
R.A. Reissaus
Risdi, Amsterdam, the Netherlands
Ibm/Informix Consultants
Telefoon: +31(0)20 6331140 : Phone
Mobiel : +31(0)6 51185352 : Mobile
E-mail : r.a.reissaus@risdi.com
Website : www.risdi.com
------------------------------------------------------------------------
Disclaimer:
`Externe E-Mail wordt door partijen niet gebruikt voor het aangaan van
verplichtingen`

`Any e-mail messages from sending parties named in this e-mail are given
in good faith but shall not be binding nor shall they be construed as
constituting any obligation on the part of any such party.`
------------------------------------------------------------------------



-----Oorspronkelijk bericht-----
Van: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]
Namens scottishpoet
Verzonden: woensdag 28 september 2005 11:24
Aan: informix-list@iiug.org
Onderwerp: Re: Strange behaviour of FOREACH (INFORMIX-4GL Version
7.30.HC4P1)


ravi,

it may be a bug in the server, 9.30.HC2 is now obsolete

get your engine onto 9.40 or 10 and see if the problem still reproduces.



Ravi wrote:
> Hi All,
>
> We are facing a very strange issue while using FOREACH. The
> environment is as follows:
>
> HP-UX 11.11
> Informix 4GL 7.30.HC4P1
> Informix Dynamic Server Version 9.30.HC2
>
> 4GL program is opening a cursor on table 'tab1' with certain
> conditions in the where clause. When a FOREACH is applied to traverse
> through this cursor, it is not returning all the rows which satisfy
> the conditions. Due to this, the output of the program is not as
> expected. The behaviour is also not consistent as sometimes it gives
> 'x' number of records less and sometimes it gives 'y' number of
> records less.
>
> Please note:
> (1) The cursor declared is a plain cursor and not scroll cursor and
> without any WITH HOLD clause.
> (2) The isolation is set to dirty read before opening the cursor.
>
> Kindly let us know if there is any resolution to this issue. Is this
> some kind of bug in Informix 4GL tool for the version mentioned above.
>
> Thanks.
>
> Regards,
> Ravi.
sending to informix-list