Cannot sort by Id when filtering by id

[GoogleCodeExporter]

Sort by ID works only when not used to filter.
working scenario:

> @r = TwitterCrawling::TwitterUser.all(:order => [:id.asc], :limit => 5)
[
1
3
7
22
25
]

> @r = TwitterCrawling::TwitterUser.all(:order => [:id.desc], :limit => 5)
[
51407
51400
51388
51375
51342
]

Not working scenario, when filtering by id:

@r = TwitterCrawling::TwitterUser.all(:id.gt => 2, :order => [:id.desc], :limit 
=> 5)
[
51407
51400
51388
51375
51342
]

> @r = TwitterCrawling::TwitterUser.all(:id.gt => 2, :order => [:id.asc], 
:limit => 5) 
[
51407
51400
51388
51375
51342
]

Original issue reported on code.google.com by michal.h...@gmail.com on 3 Jan 2010 at 11:44