Subject | Re: [IBO] Steps to reproduce possible bad bugs |
---|---|
Author | Raymond Kennington |
Post date | 2003-08-12T19:23:17Z |
Jason Wharton wrote:
In the GSG: "Transaction Terminology"
"READ COMMITTED enables the transaction to see all committed data
in the database, and to update rows updated and committed by other
simultaneous transactions, without any loss of updates."
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)
>Then should the GSG be corrected?
> > The problem is not that the record is in use.
> >
> > The problem occurs when the record has been committed and an
> > update occurs that overwrites that record without warning.
>
> If you want the warning then you need to use the transaction isolation that
> provides it. tiCommitted will not provide such a warning if the record has
> been committed already.
>
> You can't have your cake and eat it too...
>
> Jason Wharton
In the GSG: "Transaction Terminology"
"READ COMMITTED enables the transaction to see all committed data
in the database, and to update rows updated and committed by other
simultaneous transactions, without any loss of updates."
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)