Re: temporary tables, replication, and innodb tables

2004-11-21 Thread Heikki Tuuri
Mike, - Original Message - From: "Mike Debnam" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, November 21, 2004 9:25 PM Subject: temporary tables, replication, and innodb tables I'm working on a new series of queries that share a temporary ta

temporary tables, replication, and innodb tables

2004-11-21 Thread Mike Debnam
I'm working on a new series of queries that share a temporary table. I've tried using both "create temporary table select" and "create temp table" then "insert into t ... select from y". Both seem to create a lock that (if the select portion runs long enough) causes a deadlock with the replica