[Info-ingres] same select statement returns different results when repeatedly executed
Dennis
droesler at comcast.net
Tue Sep 23 18:41:27 UTC 2014
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 = 'xxxx'.
If I run select count(*) from table where col = 'xxxx' then the row
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
More information about the Info-ingres
mailing list