I have recently upgraded from MySQL 3.22.27 to 3.23.33.
I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram.
The following select statement worked fine in mysql 3.22.27:
SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode
FROM subcatsicbond
LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code
LEFT JOIN supplier ON suppliersiclink.sup_id=supplier.id
WHERE ((subcatsicbond.sub_catid=20) AND (supplier.max_latitude<=32.99) AND
(supplier.min_latitude>=31.55) AND (supplier.min_longitude>=89.25) AND
(supplier.max_longitude<=90.97))
ORDER BY supplier.company_name ASC LIMIT 0,10;
It gives me EXACTLY the data I want.
However, in 3.23.33, it does not return any data at all. I have tried
changing the order of the tables, adding/removing indexes, nothing helps.
I also have another statement which does not work anymore...
SELECT supplier.id,supplier.company_name,specials.id,specials.s_title,s_body
FROM supplier
LEFT JOIN suppliersiclink ON supplier.id=suppliersiclink.sup_id
LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code
LEFT JOIN specials ON supplier.id=specials.sup_id
WHERE ((subcatsicbond.sub_catid=20) AND (supplier.special_live=1))
ORDER BY supplier.company_name ASC;
Is there something wrong with my joins here??
I have downgraded back to 3.22.27 because I have to get on with my work..
any help would be appriciated...
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
---------------------------------------------------------------------
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
