Hi,

On Thu, Feb 20, 2003 at 10:12:56AM +0100, Iago Sineiro wrote:
> I think I detected a bug in InnoDB with MySQL 3.23.55.
> 
> I have a table named ARTICLE_POID of type InnoDB and transaction_isolation
> is READ-COMMITTED. AUTOCOMMIT is 1 (default value).
> 

...

> I think this is a bug because in pass 4) I updated instanceNo to 6. The
> transaction isolation is READ-COMMITED then in connection A I should obtain
> values updated in connection B (automatically committed).
> 

This is called a consistent read, which is documented in:

http://www.mysql.com/doc/en/InnoDB_consistent_read.html


Regards,

Fred.


-- 
Fred van Engen                              XB Networks B.V.
email: [EMAIL PROTECTED]                Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to