Thansk for the information Fred.

Iago Sineiro.

> -----Mensaje original-----
> De: Fred van Engen [mailto:[EMAIL PROTECTED]]
> Enviado el: jueves, 20 de febrero de 2003 10:37
> Para: Iago Sineiro
> CC: MySql Mail List
> Asunto: Re: Possibly bug in InnoDB with mysql 3.23.55
> 
> 
> 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
> 
> 


---------------------------------------------------------------------
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