After playing a bit further i found that the weirdness is about orderby
and limit
In [76]: a = db().select(db.movies.ALL, orderby=~(db.movies.year),
limitby=(0,10))
In [77]: for m in a:
print m.id
....:
26
16
8
43905
17
1474
13
14
1
27
In [78]: a = db().select(db.movies.ALL, orderby=~(db.movies.year),
limitby=(0,20))
In [79]: for m in a:
print m.id
....:
46
47
31
39
43
36
8
14
38
16
17
34
1474
29
43905
13
26
27
1
49
In [80]:
In the second query i would expect the first 10 items to be the same,
but they don't!
Is this a bug?
--
