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.

Matt Moriarity's latest activity

Thursday, August 05 2010
5094 ActiveRelation doesn't quote columns that are SQL keywords was updated in Ruby on Rails
  • Matt Moriarity
    Matt Moriarity commented at 8:54 PM

    Alright, it was worth a shot. Still loving Rails 3 anyway!

  • Matt Moriarity
    Matt Moriarity commented at 8:48 PM

    Perhaps it could be quoted automatically only if the user provided a symbol as the parameter.

    For instance, List.order(:order) would generate '... ORDER BY "ord...

  • Matt Moriarity
    Matt Moriarity commented at 4:32 AM

    I guess I'm just surprised this is such a difficult fix, since the double quotes are already used earlier in the SQL statement in the SELECT block. There's no r...

Tuesday, July 13 2010
5094 ActiveRelation doesn't quote columns that are SQL keywords was updated in Ruby on Rails
  • Matt Moriarity
    Matt Moriarity commented at 1:25 AM

    I mean double-quoted, which will treat it as a column name and not a keyword:

    SELECT cars.* FROM "cars" ORDER BY "id"

    would be the same as the original, but if ...

Monday, July 12 2010
5094 ActiveRelation doesn't quote columns that are SQL keywords was created in Ruby on Rails
  • Matt Moriarity
    Matt Moriarity created the ticket at 3:19 PM

    I created a table using migrations called lists, which has a column named order for maintaining the order of the lists. This worked fine, but then I tried to ca...