id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 7057,ORA-00918: column ambiguously defined error,Erin Kelly,nobody,"Column aliases aren't being generated for columns with conflicting names. This causes problems in Oracle when doing pagination, which effectively wraps the query in ""SELECT * FROM (%s)"". Here's an example, where the test_species.id and test_genus.id columns conflict, as well as the test_species.name and test_genus.name columns: {{{ In [5]: qs = Species.objects.all().select_related(depth=1)[:5] In [6]: qs.query.as_sql() Out[6]: ('SELECT * FROM (SELECT (ROW_NUMBER() OVER (ORDER BY ""TEST_SPECIES"".""ID"" )) AS rn, ""TEST_SPECIES"".""ID"", ""TEST_SPECIES"".""NAME"", ""TEST_SPECIES"".""GENUS_ID"", ""TEST_GENUS"".""ID"", ""TEST_GENUS"".""NAME"", ""TEST_GENUS"".""FAMILY_ID"", ""TEST_SPECIES"".""ID"", ""TEST_SPECIES"".""NAME"", ""TEST_SPECIES"".""GENUS_ID"", ""TEST_GENUS"".""ID"", ""TEST_GENUS"".""NAME"", ""TEST_GENUS"".""FAMILY_ID"" FROM ""TEST_SPECIES"" INNER JOIN ""TEST_GENUS"" ON (""TEST_SPECIES"".""GENUS_ID"" = ""TEST_GENUS"".""ID"")) WHERE rn > 0 AND rn <= 5', ()) In [7]: list(qs) ... : ORA-00918: column ambiguously defined }}}",,closed,"Database layer (models, ORM)",queryset-refactor,,fixed,,,Accepted,0,0,0,0,0,0