We're using MySQL 5.0.15 and it works just fine. The only thing we've encountered is with the J/Connector, its behaives different between different versions. The version we're using is 3.1.7.
Ok. Will start testing myself. May I know what differences?
We use stored procedures that returns multiple resultsets, and when I upgrade the J/Connector to the latest one, the working code stop working. The multiple resultsets are not returned for some reason.
Instead of trying to figure out why, we just use the version of J/Connector that we know works (in our case 3.1.7).