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.

Jonathan Viney's latest activity

Wednesday, February 11 2009
1925 Mysql::Error: SAVEPOINT active_record_1 does not exist: ROLLBACK TO SAVEPOINT... was updated in Ruby on Rails
  • Jonathan Viney
    Jonathan Viney commented at 12:07 PM

    No worries, let's close this off then.

  • Jonathan Viney
    Jonathan Viney commented at 11:56 AM

    It appears that TRUNCATE is a DDL statement, http://dev.mysql.com/doc/refman/..., and therefore causes an implicit commit. The docs already warn against using D...

  • Jonathan Viney
    Jonathan Viney commented at 11:06 AM

    A basic test seems to work ok:

    
    Person::Note.transaction do
      Person::Note.transaction :requires_new => true do
        ActiveRecord::Base.connection.execute("T...
Tuesday, February 10 2009
1925 Mysql::Error: SAVEPOINT active_record_1 does not exist: ROLLBACK TO SAVEPOINT... was updated in Ruby on Rails
  • Jonathan Viney
    Jonathan Viney commented at 3:01 PM

    Can you show more of your logs? Are the savepoints being defined?

Sunday, August 31 2008
383 ActiveRecord should use savepoints for nested transactions was updated in Ruby on Rails
  • Jonathan Viney
    Jonathan Viney commented at 11:38 AM

    I've attached a patch for master.

    The handling of increment/decrement_open_transactions has been moved to the connection object rather than handling it in AR::B...

Thursday, July 03 2008
383 ActiveRecord should use savepoints for nested transactions was updated in Ruby on Rails
  • Jonathan Viney
    • Tag set to activerecord, nested, savepoint, transaction
    by Jonathan Viney at 1:12 PM

    I'd like to see #533 included first (moving the transaction counter from Thread.current to the connection object), and then I'll add an updated patch for the s...

Monday, June 02 2008
295 Sum on associations should return 0 when no rows are returned was created in Ruby on Rails
  • Jonathan Viney
    Jonathan Viney created the ticket at 4:05 AM

    This works when calling sum directly on a model, but not on an association. Patch attached.

Sunday, May 04 2008
104 Fix blank conditions with find on AssociationCollection was updated in Ruby on Rails
  • Jonathan Viney
    Jonathan Viney commented at 4:07 AM

    Here's the patch.

  • Jonathan Viney
    Jonathan Viney created the ticket at 4:06 AM

    Passing blank conditions straight to ActiveRecord::Base.find works as expected, no conditions are added to the sql. The same is not true when calling find on a...