Sequence of SQL actions gives wrong query result for 10 seconds!

2002-11-13 Thread Mike W-M
All, I've been having problems with a pretty simple series of SQL statements run against some InnoDB tables returning the wrong results - temporarily! Basically, I have one middle table that maps a role to an operation (many-to-many), and I have separate role and operation tables that contain

Re: Sequence of SQL actions gives wrong query result for 10 seconds!

2002-11-13 Thread Heikki Tuuri
[EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 11:07 AM Subject: Sequence of SQL actions gives wrong query result for 10 seconds! All, I've been having problems with a pretty simple series of SQL statements run against some InnoDB tables returning