INNER JOIN doesn't work correctly.. - Michael Widenius - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsINNER JOIN doesn't work correctly..

From	Sent On	Attachments
Sergey S. Kostyliov	28 Nov 2001 04:27
Sinisa Milivojevic	28 Nov 2001 08:26
Sergey S. Kostyliov	28 Nov 2001 08:31
Michael Widenius	28 Nov 2001 08:35

Subject:	INNER JOIN doesn't work correctly..
From:	Michael Widenius (mon...@mysql.com)
Date:	11/28/2001 08:35:34 AM
List:	com.mysql.lists.bugs

Hi!

"Sergey" == Sergey S Kostyliov <rath...@php4.ru> 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