mysql version dependencies?

[Bradley Baetz]

On Fri, Jan 10, 2003 at 10:30:32AM -0800, Joel Peshkin wrote:
> 
> Developers:
> 
>    I had no problem with mysqld (the server) 3.23.41.   Richard had 
> problems with 3.23.39-nt that went away when he updated to 3.23.54-nt.

There was a mysql bug with joins which affected mysql from at least
3.22, which was fixed in 3.23.44. I did look for this in the new
permission code when that was rewritten, and I didn't think we triggered
it anymore. That doesn't explain why it works in .41, though.

If you could track this down, that would be helpful. Try running the
query in CanSeeBug (in globals.pl) with the two different db versions,
and compare teh results. Then start removing bits.

The 3.23.40 changelogs for mysql do say: "Fixed a bug when using
COUNT(DISTINCT) with LEFT JOIN and there weren't any matching rows."

We do use that, but on the LHS of the join. Does 3.23.40 work? IF so, we
should update the required mysql version.

Bradley