Page 1 of 1

mysql 5.18 bug workaround?

PostPosted: 28. February 2006 23:51
by darkbluesun
Hi
I am using the latest version of xampp with mysql 5.18. There is a bug in 5.18 that stops me from using any left joins. Since I use these a lot in my programming it makes it almost impossible to program with this version of mysql. Can I get xampp with mysql 4.1?

PostPosted: 01. March 2006 00:02
by Wiedmann
There is a bug in 5.18 that stops me from using any left joins

Can you give me the id from the bug database?

Can I get xampp with mysql 4.1?

Why not? Please go to the project page and read where you can get older versions...

PostPosted: 01. March 2006 01:16
by darkbluesun
Wiedmann wrote:Can you give me the id from the bug database?

Bug #13551

Wiedmann wrote:Why not? Please go to the project page and read where you can get older versions...

where is this project page?

PostPosted: 01. March 2006 01:39
by Wiedmann
Bug #13551

You have read the complete page? ;-)

This is not realy a bug, the wrong behaviour was in the old MySQL versions and not in the new one.

Here you can read how JOINS are working. And what you can do, to make a valid query for older and newer MySQL versions (hint: use parentheses):
http://dev.mysql.com/doc/refman/5.0/en/join.html

where is this project page?

http://www.apachefriends.org/en/xampp-windows.html

PostPosted: 01. March 2006 01:54
by darkbluesun
No, actually, I had not read much of the page at all.
You were right, and that seems to have solved my problems.

Thank You for going out of your way to help me with that one. :D