Re: Possible Bug? Left Join With OR Clause Takes Minutes

2005-10-08 Thread Scott Gifford
Scott Klarenbach [EMAIL PROTECTED] writes: I'm using Mysql 5.0.7 and I've noticed the following very strange functionality, perhaps someone can shed some light on it for me. Try using the EXPLAIN statement to get some insight into what MySQL is thinking. Scott. -- MySQL General Mailing

Possible Bug? Left Join With OR Clause Takes Minutes

2005-10-07 Thread Scott Klarenbach
I'm using Mysql 5.0.7 and I've noticed the following very strange functionality, perhaps someone can shed some light on it for me. 2 Tables (Request and Inventory) Request id (int), partNumber varchar(60) Inventory id(int), MPN varchar(60), MPNClean varchar(60) I have about 1500