[EMAIL PROTECTED] writes: > >Description: > We recently tried to upgrade from mysql 3.23.27 to 3.23.43 - we switched > back caused by we sometimes recieved different results with 3.23.43. The > statements below gives the same result with 3.23.27 but not with > 3.23.43. Apperently it matters in what order the tables are written in > the FROM clause. > I have tried to narrow it down to two simple tables, but then the > problem disappeared. > > >How-To-Repeat: > mysql> SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord like >'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > +----------------+-----+ > | titel | id | > +----------------+-----+ > | Bethanias Unge | 404 | > +----------------+-----+ > 1 row in set (0.01 sec) > > mysql> SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord like >'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > Empty set (0.01 sec) > > mysql> explain SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord >like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > | table | type | possible_keys | key | key_len | ref | rows | >Extra | > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > | o1 | range | iord,kilde_id,ord | iord | 61 | NULL | 1 | >where used | > | link | eq_ref | PRIMARY | PRIMARY | 4 | o1.kilde_id | 1 | > | > | o2 | range | iord,kilde_id,ord | iord | 61 | NULL | 121 | >where used | > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > 3 rows in set (0.00 sec) > > mysql> explain SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord >like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > | table | type | possible_keys | key | key_len | ref | rows | >Extra | > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > | o1 | range | iord,kilde_id,ord | iord | 61 | NULL | 1 | >where used | > | o2 | range | iord,kilde_id,ord | iord | 61 | NULL | 121 | >where used | > | link | eq_ref | PRIMARY | PRIMARY | 4 | o1.kilde_id | 1 | > | > >+-------+--------+-------------------+---------+---------+-------------+------+------------+ > 3 rows in set (0.00 sec) > > mysql> > > > > >Fix:
Hi! Can you tar and gzip your tables and upload them to : ftp://support.mysql.com:/pub/mysql/secret so that we can check it out ?? After you upload them, please let us know a filename. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php