backtrace.txt

DEBUG -- :   Test Load (0.2ms)  SELECT "tests".* FROM "tests" ORDER BY COALESCE(updated_at DESC, created_at) ASC LIMIT 1
DEBUG -- : SQLite3::SQLException: near "DESC": syntax error: SELECT  "tests".* FROM "tests" ORDER BY COALESCE(updated_at DESC, created_at) ASC LIMIT 1
/Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `log': SQLite3::SQLException: near "DESC": syntax error: SELECT  "tests".* FROM "tests" ORDER BY COALESCE(updated_at DESC, created_at) ASC LIMIT 1 (ActiveRecord::StatementInvalid)
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/connection_adapters/sqlite_adapter.rb:135:in `execute'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/connection_adapters/sqlite_adapter.rb:284:in `select'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/connection_adapters/abstract/query_cache.rb:56:in `select_all'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/base.rb:473:in `find_by_sql'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/relation.rb:64:in `to_a'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/relation/finder_methods.rb:349:in `find_last'
	from /Users/titanous/.rvm/gems/ree-1.8.7-2011.03@fix/gems/activerecord-3.0.8/lib/active_record/relation/finder_methods.rb:136:in `last'
	from order_by_coalesce.rb:15

order_by_coalesce_bug.rb

require 'active_record'
require 'logger'

ActiveRecord::Base.logger = Logger.new(STDOUT)
ActiveRecord::Base.establish_connection(:adapter => 'sqlite3', :database => 'data.sqlite3')

ActiveRecord::Schema.define :version => 0 do
  create_table :tests, :force => true do |t|
    t.timestamps
  end
end

class Test < ActiveRecord::Base; end

Test.order('COALESCE(updated_at, created_at) DESC').last