Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Roger Tomas — — source: Informix-list mailing list archive (1991-1998)
M. Livenspargar wrote:
>
> And if so, where??
>
> I have a table with one column of datatype serial. The table has 2
> rows when I execute the following SQL in DBAccess:
>
> set isolation to committed read;> begin work;
> insert into table1 values (0);
> select count(*) from table1;> rollback work;
>
> The 'select count(*)' line returns a value of 3. After this code has
> executed, a 'select count(*)' returns a value of 2, just as I would
> expect.
>
> Why does the select in the code given return a value of 3 when the
> isolation level is set to committed read and there are two committed
> rows and one uncommitted row? I assume it is because the same process
> that issued the insert is doing the select. Is this an
> implementation-dependent feature, a rule, or a bug? I'm running
> v7.11.x of the engine.
I would have expected this behavior. Isolation level pertains to
concurrency with other transactions - not with your own transaction.
-----------
Roger Tomas
AG Communication Systems
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.