I attended the MySQL conference in Santa Clara last week, and I attended the Stored Procedures and Functions tutorial. These are already available in 5.0 beta, and the stable 5.0 release is expected later this year.
The presenter said that the syntax of MySQL stored procedures conforms to SQL 2003, and the only other database to have a similar conforming stored procedure language is IBM DB2. It reminded me of Informix SPL in a lot of ways, too.
It would be nice to have a SQLUnit test suite for MySQL 5.0 stored procedures. If anyone is actively looking at it, and are using SQLUnit to test it out, building and donating a demo test suite for MySQL would be very helpful and would be much appreciated.
TIA
Sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I attended the MySQL conference in Santa Clara last week, and I attended the Stored Procedures and Functions tutorial. These are already available in 5.0 beta, and the stable 5.0 release is expected later this year.
The presenter said that the syntax of MySQL stored procedures conforms to SQL 2003, and the only other database to have a similar conforming stored procedure language is IBM DB2. It reminded me of Informix SPL in a lot of ways, too.
It would be nice to have a SQLUnit test suite for MySQL 5.0 stored procedures. If anyone is actively looking at it, and are using SQLUnit to test it out, building and donating a demo test suite for MySQL would be very helpful and would be much appreciated.
TIA
Sujit