Bug? InnoDB transactions and temporary table hanging

2003-02-07 Thread Samuel Liddicott
I came accross a problem porting our tv listings system from postgres to mysql with InnoDB. With InnoDB tables, read-only transactions started after a read-write transaction touching the same rows are able to read data as it was before the read-write transaction began; UNLESS the read-only

Re: Bug? InnoDB transactions and temporary table hanging

2003-02-07 Thread Heikki Tuuri
... Subject: Bug? InnoDB transactions and temporary table hanging From: Samuel Liddicott Date: Thu, 6 Feb 2003 10:57:13 - I came accross a problem porting our tv listings system from postgres to mysql with InnoDB. With InnoDB tables, read-only transactions started after a read-write