Is there a known bug with outer joins in MySQL 5.0.1? I tried the following query on 5.0.1:
SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted FROM student s INNER JOIN enrollment e ON e.tech_id = s.tech_id INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id RIGHT JOIN assignment a ON a.a_id = sa.a_id WHERE a.a_id = '100' AND e.term_id = '3' ORDER BY s.full_name; None of the outer results are present. At first I thought the query was wrong, but if I run the same exact query using the same tables (from a mysqldump) on a 4.0.20 server I get the expected results including student's who have not yet submitted the assignment. Running on SuSE linux 5.0.1 compiled from source. Any more details I can provide? I have to imagine that something like this has already been found. Is the 5.0.1 snapshot on the products download page updated frequently? If so I guess I could try to download and install again. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
