Please consider rigorous SQL code review to make sure this works with MySQL 5.0.x (.15 or later) during the development process. There are some rather significant changes in MySQL 5 that make it far more strict than previous versions, especially in 5.0.12.
Reply: SQL Considerations
Testopia is being developed on MySQL 5.0. Careful measures are being taken to make sure it is fully ANSI SQL compliant. -