Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

Nested Transactions feature in Rails 2.3.2 depends on MySQL 5.x syntax

#2384

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

Reported by Dan Van Derveer · March 31st, 2009 @ 03:54 PM

State: wontfix
Milestone: 2.x
Assigned to: Ryan Bigg Ryan Bigg
Importance: none

Activity

  1. Steve St. Martin
    Steve St. Martin
    • 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

    April 15th, 2010 @ 10:21 PM

  2. Ryan Bigg
    Ryan Bigg
    • State changed from new to wontfix

    Please upgrade to MySQL 5, as it contains important bugfixes / features.

    April 15th, 2010 @ 10:30 PM