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
14466	"""ORA-00918: column ambiguously defined error"" has reappeared in 1.2.3"	biolsen	nobody	"It seems that the ORA-00918 error, regarding identical column names in multiple tables (where aliases are necessary for instance in nested result sets like SELECT * FROM (SELECT .. FROM ...) ), somehow has been reintroduced into the code since its resolution in ticked #7057.

The following patch has resolved the issue in 1.2.3 (solution based on ticked #7057).

In /django/db/models/sql/compiler.py:

{{{
--- 71,88 ----
          result = ['SELECT']
          if self.query.distinct: 
              result.append('DISTINCT') 
+         # Below is a patch to the 1.2.3 code that, at least with Oracle 
+         # made selects with identical column names crash with a ambiguous 
+         # column name error. This error was corrected in previous versions
+         # of Django, but seemed to be re-introduced with 1.2.3. 
+         if ordering: 
+             cols = [clause.split('.')[-1] for clause in out_cols] 
+             for index, col in enumerate(cols): 
+                 if cols.count(col) > 1: 
+                     col = '%s%d' % (col.replace('""', ''), index) 
+                     cols[index] = col 
+                     out_cols[index] = '%s AS %s' % (out_cols[index], col) 
          result.append(', '.join(out_cols + self.query.ordering_aliases)) 
          result.append('FROM') 
          result.extend(from_) 
          params.extend(f_params) 
*************** 
}}}"		closed	Database layer (models, ORM)	1.2		invalid	Oracle, column ambiguously defined		Unreviewed	1	0	1	0	0	0