From: "Rick Debay" <rdebay@...>

> Transaction A starts
> Transaction B starts
> TX B inserts many rows in table 1
> TX B commits
> TX A selects from table 1
>
> Can TX A see the rows that TX B committed? I wouldn't think so, but my
> coworker is seeing the data from a query executed in Database Workbench.
>

Yes, if Transaction A is set for read-committed records. If you set it for
snapshot, it won't see the new records until a new transaction is started.

HTH

Woody (TMW)