Re: ORACLE QuerySet offset

2009-07-28 Thread Ian Kelly
On Tue, Jul 28, 2009 at 6:20 AM, slafs wrote: > > Hi there! > > I think I found a little bug in > http://code.djangoproject.com/browser/django/trunk/django/db/backends/oracle/query.py#L132 > Offsetting the QuerySet (like qs[2:4]) on Oracle backend mixes the > ordering in the final result set. > Au

ORACLE QuerySet offset

2009-07-28 Thread slafs
Hi there! I think I found a little bug in http://code.djangoproject.com/browser/django/trunk/django/db/backends/oracle/query.py#L132 Offsetting the QuerySet (like qs[2:4]) on Oracle backend mixes the ordering in the final result set. Author claims that "This is the canonical way to emulate LIMIT