well, I think you are the first Oracle user to be posting on the
list, or at least really trying stuff. Oracle was actually a
trickier database due to its finickiness. the good news is that I
know oracle better than I know all the other DB's (although a user
recently showed me the ROW_NUMBER OVER syntax, which is necessary to
do LIMIT and OFFSET).
anyway, can I see the full query ? or a small test case ? it seems
the "ora_rn" name is the thing that is ambiguous ? if so, that is an
easy fix as we can just have the name of that column be dynamically
generated, using the same algorithm for Aliases, i.e. hex
(random.randint(0, 65535))[2:] .
if youre up to it, you can try that patch, otherwise ill have to get
around to making a test case (times a little short lately).
On Feb 24, 2006, at 8:03 AM, [EMAIL PROTECTED] wrote:
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
