[Info-ingres] Same select statement doesn't consistently return same number of rows

[Dennis]

On 9/23/2014 12:36 PM, Dennis wrote:
> Ingres
> II 9.2.4 (a64.lnx/100)NPTL
> 14674
> ------------------------------------------------------------
> II 9.2.4 (a64.lnx/100)NPTL
>
> select * from table where col = 'xxxx' will return different number of
> rows on different runs of the sql.  I know that no one is
> updating/inserting rows that affect col = 'xxx'.
>
> If I run select count(*) from table where col = 'xxxx' then the row
this should be col = 'xxx' :-(

> count is consistent across different runs of this sql.
>
> On another system that only differs in Ingres version (9.2.1) I don't
> have this issue.
>
> Both systems have
> cursor_default_open READONLY
> system_isolation READ_COMMITED
>
> What should I be looking for to resolve this?
>
> Thanks
>
> Dennis
>