[SQL-CVS] [ sqlobject-Bugs-1764739 ] Buggs in Select

[SourceForge.net <no...@so...>]

Bugs item #1764739, was opened at 2007-07-31 17:27
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1764739&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Johan Carlsson (johanc)
Assigned to: Nobody/Anonymous (nobody)
Summary: Buggs in Select

Initial Comment:
This is for: sqlobject-0.10dev_r2829-py2.4.egg

I've found some things that doesn't work in the
sqlbuilder.Select class.

In the __sqlrepr__ method ops['limit'] isn't used correctly:

def __sqlrepr__:
    ...
    if self.ops['limit'] is not NoDefault:
        end = start + limit

Now it seem like when using slices ops['limit'] can be None (not NoDefault). 

Also as can be noted limit is never set, I supposed it to be self.ops['limit'].
Resulting in:

NameError: global name 'limit' is not defined


Select(..., limit=2)
does give (not sure why, I might be me):

OperationalError: near "<": syntax error


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1764739&group_id=74338