#70 Sybase and LIMIT

[Eddie]

In SybaseConnection it reads:

def _queryAddLimitOffset(self, query, start, end):
# XXX Sybase doesn't support LIMIT
return query

Sybase does support LIMIT. I suggest having something like:

def _queryAddLimitOffset(self, query, start, end):
if end:
return "SET ROWCOUNT %i %s SET ROWCOUNT 0" %
(end, query)
return query

Cheers,

eddie

[Oleg Broytman]

Logged In: YES
user_id=4799

You do not use "start" parameter. Do Sybase has a notion of
offset?

[Eddie]

Logged In: YES
user_id=1570436

Not that I am aware of.

[Oleg Broytman]

Logged In: YES
user_id=4799

Well, it is better than nothing. Thank you!

Applied in the revision 1852 to the trunk, rev. 1853 to the
0.7-branch.

PS. Are you sure there is no need for semicolons:

SET ROWCOUNT %i; %s; SET ROWCOUNT 0

???

[Eddie]

Logged In: YES
user_id=1570436

Yeah, no semicolons.

[Oleg Broytman]

Logged In: YES
user_id=4799

ok