Re:DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

2001-08-17 Thread Eric J. Schwertfeger
On Fri, 17 Aug 2001, Heikki Tuuri wrote: Problem resolved, thank you very much. It was indeed my missing a concept, description below: > it was not immediately clear to me what your application > does. Does one connection update the table and > another connection do the SELECT? Yes, as it's t

Re:DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

2001-08-17 Thread Heikki Tuuri
Eric, it was not immediately clear to me what your application does. Does one connection update the table and another connection do the SELECT? Then the problem might be the consistent read. I have copied below a segment from the InnoDB manual at www.innodb.com : When you issue a consistent