[Rails] Sunspot_rails order by not working

Hi Guys,

I'm using sunspot_rails-2.0.0.pre.120417 with postgres

In model i added searchable columns:

searchable do
string :display_title
integer :created_at
integer :ending_at
end

order_by(:created_at,:desc) not working.


ruby-1.9.2-p180 :027 > res=Listing.search{order_by(:created_at,:desc)}
=> <Sunspot::Search:{:fq=>["type:Listing"], :sort=>"created_at_d desc",
:start=>0, :rows=>30, :q=>"*:*"}>

ruby-1.9.2-p180 :028 > res.results.map(&:id)
Listing Load (3.0ms) SELECT "listings".* FROM "listings" WHERE
"listings"."id" IN (100, 99, 94, 95, 96, 97, 98, 93, 88, 89, 90, 91, 92,
83, 84, 85, 86, 87, 77, 78, 79, 80, 81, 82, 72, 73, 74, 75, 76, 67)
=> [*100, 99, 94, 95, 96, 97, 98, 93, 88, 89, 90, 91, 92, 83, 84, 85, 86,
87, 77, 78, 79, 80, 81, 82, 72, 73, 74, 75, 76, 67*]

ruby-1.9.2-p180 :029 > ActiveRecord::Base.connection.execute('select
listings.id FROM "listings" order by created_at desc limit
30').column_values(0)
(0.9ms) select listings.id FROM "listings" order by created_at desc
limit 30
=> [*"100", "99", "98", "97", "96", "95", "94", "93", "92", "91", "90",
"89", "88", "87", "86", "85", "84", "83", "82", "81", "80", "79", "78",
"77", "76", "75", "74", "73", "72", "71"*]

Its working during sql order by and order_by(:ending_at,:desc) but not
for order_by(:created_at,:desc), i dont know why, Any suggestion?

Thanks,
Dhamodharan.N