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
