Sunspot_rails order by not working

[DHAMODHARAN N]

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