Michael Bayer [EMAIL PROTECTED] writes:
yes. but the question was, limit is ignored when offset is zero,
which is not the issue. LIMIT is ignored when its zero, period (it
evaluates to false). the decision to be made is, should Query
circumvent querying altogether when limit is zero.
On May 10, 2008, at 10:22 AM, Yannick Gingras wrote:
I attach a test case. In here, it prints:
--
** q[:0]
SELECT users.id AS users_id, users.name AS users_name
FROM users ORDER BY users.id
** q[0:0]
SELECT users.id AS users_id, users.name AS users_name
On May 2, 2008, at 6:33 AM, Yannick Gingras wrote:
My guess is that the underlying Select object does not take limit
into account when offset is 0.
you mean, a limit of zero itself is ignored. an offset of zero
doesn't affect limit.
You will all agree that this is a bug and that it
Michael Bayer [EMAIL PROTECTED] writes:
My guess is that the underlying Select object does not take limit
into account when offset is 0.
you mean, a limit of zero itself is ignored. an offset of zero
doesn't affect limit.
When _offset is 0 or None, _limit seems to be ignored. There
On May 2, 2008, at 10:52 AM, Yannick Gingras wrote:
When _offset is 0 or None, _limit seems to be ignored. There might be
something else but I see:
print q[:0] # no limit statement in the SQL
print q[0:0] # no limit statement in the SQL
print q[1:1] # limit statement is there
the first