On Wed, 2006-01-25 at 13:59 -0500, Michael Bayer wrote:
> Ill see if the current "rowid" functionality works for most cases, and
> I'll look into this to see how much of an alternative it is.
I'm a little confused, are we talking about the same thing? I'm looking
at OracleCompiler.visit_select:
if select.limit is not None:
limitselect.append_whereclause("rownum<%d" %
select.limit)
if select.offset is not None:
limitselect.append_whereclause("rownum>%d" %
select.offset)
What I'm saying is that "rownum>%d" is going to eat up all of the result
rows. The 10.1 documentation for rownum says:
====
Conditions testing for ROWNUM values greater than a positive integer are
always false. For example, this query returns no rows:
SELECT * FROM employees
WHERE ROWNUM > 1;
The first row fetched is assigned a ROWNUM of 1 and makes the condition
false. The second row to be fetched is now the first row and is also
assigned a ROWNUM of 1 and makes the condition false. All rows
subsequently fail to satisfy the condition, so no rows are returned.
====
http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10759/pseudocolumns008.htm#sthref714
Personally, I'm not really interested in "offset", but as I was reading
the code I happened to come across the ROWNUM conditions.
Aside: I think sqlalchemy is great; when I saw "topological" in there I
knew I was dealing with someone who knew what they were after. And who
was after the right thing.
Mitch
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
