Re: Why I can not using alias in 11G

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 08 Feb 2010 11:19:09 +0100
Message-ID: <4b6fe51f$0$22944$e4fe514c_at_news.xs4all.nl>

Op 8-2-2010 2:16, Havel Zhang schreef:
> hi all:
> I found some query will cause ORA-00918 error(column ambiguously
> defined) in 11G, but running well in 10G.
> I give an example:
> ---------------------------
> select
>
> supplier_code,dept_code,local_name,english_name
> from
> supplier a inner join
> (select supplier_code s,
> dept_code d,
> max(rowid) r
> from supplier
> group by
> supplier_code,dept_code
> ) b on a.supplier_code =
> b.s and a.dept_code = b.d and a.rowid = b.r
>
> ---------------------------
> The query above can running well in 10G, but will cause an
> error on 11G, of course, I can rewrite the query, but who can tell me
> why, 11G have new feature ? have any parameter to solve this problem?
>
> Thank you.
>
> Havel

Apart from the bug you encounter, I definitely think you should rethink your query, if this is a real life example and if I understand its functionality.

Shakespeare Received on Mon Feb 08 2010 - 04:19:09 CST