This project is archived and is in readonly mode.
Nested Transactions feature in Rails 2.3.2 depends on MySQL 5.x syntax
Reported by Dan Van Derveer | March 31st, 2009 @ 03:54 PM | in 2.x
I am upgrading my Rails application from a 2.2 release to 2.3.2. We still use MySQL 4.1.x as our DB which seems to be a problem.
My unit tests fail with this error: ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RELEASE SAVEPOINT active_record_1' at line 1: RELEASE SAVEPOINT active_record_1
If you compare the documentation between MySQL 4.1 and 5.0, it shows that the RELEASE SAVEPOUNT feature was added in MySQL 5.0.
4.1: http://dev.mysql.com/doc/refman/... 5.0: http://dev.mysql.com/doc/refman/...
This should at least be in the release docs. However ideally, this feature should degrade nicely on MySQL 4.1
Comments and changes to this ticket
-
Steve St. Martin April 15th, 2010 @ 10:21 PM
- Assigned user set to “Ryan Bigg”
Maintaining backwards compatibility across many MySQL versions is probably an edgecase as most people would probably just upgrade their DB, please submit a patch if 4.1 support is something thats vital to you.
mark as incomplete
-
Ryan Bigg April 15th, 2010 @ 10:30 PM
- State changed from “new” to “wontfix”
Please upgrade to MySQL 5, as it contains important bugfixes / features.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<h2 style="font-size: 14px">Tickets have moved to Github</h2>
The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>
ctagg
Dan Van Derveer
Ryan Bigg