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

2002-11-13 Thread Heikki Tuuri
uot;Mike W-M"" <[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 sta

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 conta