Log in or Sign up

Different behavior between MySQL 5 and MySQL 4.1

Discussion in 'MySQL' started by teknoledge, Mar 14, 2007.

teknoledge Active Member

Messages:

408

Likes Received:

14

Best Answers:

0

Trophy Points:

88

#1

I'm using pretty simple queries which should work under both versions but somehow the results I get are different.

Query one:

SELECT p.*, m.p_order as porder FROM product AS p LEFT JOIN mapper AS m ON m.pid = p.pid RIGHT JOIN category AS c ON m.cat_id = c.cat_id WHERE p.pid IS NOT NULL AND c.cat_id = $cat GROUP BY p.pid ORDER BY m.p_order ASC
Click to expand...

Query two:

SELECT p.* FROM product AS p LEFT OUTER JOIN mapper AS m ON m.pid = p.pid WHERE m.pid IS NULL
Click to expand...

I'm using these queries to filter the products by category etc... On my local I have MySQL 5 and everything works ok but on my dev server I have MySQL 4.1 and the results I get are not as they should be. Is there any chance I'm using the syntax that is not compatible with MySQL 4.1 ??

Any help would be appreciated. Thanks!

teknoledge, Mar 14, 2007 IP

(You must log in or sign up to reply here.)