I just committed something small to oracle similar to your working idea. I also put a note in to revisit that section since id rather not be hardcoding the table name + "rowid" like that.

On Feb 24, 2006, at 11:42 AM, [EMAIL PROTECTED] wrote:

The full query would be a bit long, but the query below emulates the problem
(without ora_rn)

SELECT ROW_NUMBER() OVER (ORDER BY rowid ASC)
FROM foo, bar

anyway, can I see the full query ?  or a small test case ?  it seems
Hi, I've found this odd thing.

All selects have this "ROW_NUMBER() OVER (ORDER BY rowid ASC) AS
ora_rn" in
them.

I found that when using inheritance mapping, and the resulting
select joins over
two tables, oracle tells me: "ORA-00918: column ambigously defined".

When I patch this in OracleCompiler.visit_select (line 216 in
database/oracle.py):
    orderby = "%s.rowid ASC" % select.froms[0].name

it works.

Anybody else saw that issue? Ideas if this is a good patch or if
this will come
crushing down on me later?

Thanks,
Florian




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the
live webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users






-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to