Oracle bug? Where is ORA-00918 error?
Hi all!
I've found an issue.
I'm joining three tables in a query, first and third table have the same named column. The query is hierarchical, CONNECT BY clause references the same named column, but with no alias or table name specified. I expected that Oracle should raise an error ORA-00918. But it doesn't raise an error and uses a column from the last (third) table.
Is it really a bug or I don't understand something?
Thank you
RDBMS Version : 10.2.0.1.0
Operating System and Version : Windows Server 2003 R2 Standard Russian 32-bit
Example to reproduce:
create table tab_a (id number(2) primary key, parentid number(2) references tab_a(id));
I've found an issue.
I'm joining three tables in a query, first and third table have the same named column. The query is hierarchical, CONNECT BY clause references the same named column, but with no alias or table name specified. I expected that Oracle should raise an error ORA-00918. But it doesn't raise an error and uses a column from the last (third) table.
Is it really a bug or I don't understand something?
Thank you
RDBMS Version : 10.2.0.1.0
Operating System and Version : Windows Server 2003 R2 Standard Russian 32-bit
Example to reproduce:
create table tab_a (id number(2) primary key, parentid number(2) references tab_a(id));
0