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