This project is archived and is in readonly mode.

#2384 ✓wontfix
Dan Van Derveer

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

    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

    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>

People watching this ticket

Pages