cannot sort cursor before limit

[keyleo]

Let us say, we have 1000 records, and I want to fetch latest 100 records by timestamp.

when i use
local r = col:find(criteria,nil,100)
r:sort({["timestamp"]=-1})

the cursor return sorted result of first 100 results.

what I want is sort 1000 records first, and then limit 100 records.

[sagrada1788]

it is a bug.
you can modify this file src/cursor.lua in line 42:

function cursor_methods:limit(n)
assert(n)
self.limit_n = n
return limit
end

modify

return limit

to

return self

[sagrada1788]

then use like this

r:sort({["timestamp"]=-1}):limit(100)