From: Martijn Tonies
Date: May 13 2005 10:46am
Subject: Re: Read past Equivalent in MySQL
List-Archive: http://lists.mysql.com/mysql/184066
Message-Id: <02bc01c557a9$101db8c0$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-15"
Content-Transfer-Encoding: 7bit

> > I am using InnoDB only.
> > But, it's not skipping locked rows.
>
> Ditto that here.

Actually, I consider that a good thing... What's the point in leaving
out rows that have not been modified yet but are about to be updated?
The transaction that has the rows locked might as well be rolled back.

The data that is visible is the data as available at that moment.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com