Hi!
>>>>> "Sergey" == Sergey S Kostyliov <[EMAIL PROTECTED]> writes: >> Description: Sergey> Query with INNER JOIN return 0 rows, but the same query + yet another Sergey> WHERE condition return 1 row >> How-To-Repeat: Sergey> Query: Sergey> SELECT orders_common.vendor_id Sergey> FROM orders_common Sergey> INNER JOIN orders_common_count Sergey> ON (orders_common.id=orders_common_count.orders_id) Sergey> WHERE orders_common_count.clients_names_id in (3639) Sergey> AND orders_common.vendor_id=95 Sergey> Result - 0 rows Sergey> but, Sergey> SELECT orders_common.vendor_id Sergey> FROM orders_common Sergey> INNER JOIN orders_common_count Sergey> ON (orders_common.id=orders_common_count.orders_id) Sergey> WHERE orders_common_count.clients_names_id in (3639) Sergey> AND orders_common.vendor_id=95 Sergey> AND and orders_common.id=1060340 Sergey> Result - 1 row Could you please provide a full test case for this and ftp it to: ftp://support.mysql.com/pub/mysql/secret We have in 3.23.46 fixed a bug that could have caused this problem. We are now building binary versions of 3.23.46 I would appreicate if we could get a change to verify that it fixes your problem before we release it. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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