Bug #1190 Problem in JOIN

Description:
Hi,
       I tried to execute the statement

"Select m.message_id,m.message_subject,u.user_name from message m
 LEFT JOIN users u on u.user_id=m.message_user"

where as a user is not in the users table. For example (message_user has a user_id with a value of 10 and that is not available in users table.) The query results return Null for u.user_name for all the subsequent rows that return after the message_id having user_id 10.

Could anyone please let me know how to solve this issue.

Thanks,
Deiva.

How to repeat:
"Select m.message_id,m.message_subject,u.user_name from message m
 LEFT JOIN users u on u.user_id=m.message_user"

messages
mesasge_id message_subject message_user
1             xxx            2
2             aaa            10
3             ddd            1

users
user_id   user_name
1         deiva
2         raja

the query result is returning the nulls (it seems it works fine when ids or other are matched. but problem with date or lesser or grater than functions used.)

Is the problem reproducable for you with the exact data that you provided here
(2+3 rows)? Also, can you post CREATE TABLE statements for both tables,
including indices created on the tables.

Also, you could try upgrading to the latest MySQL version - I wasn't able to
reproduce this on 3.23.58 at this moment.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".