Upgrade to 11g: 11g raises error but Oracle 10g not for ambiguous ANSI joins

Beware:

Metalink note: Bug 5368296  ANSI join SQL may not report ORA-918 for ambiguous column

Long story short: Oracle 10g does not raise error for ambiguous columns missing aliases. Oracle 11g catches the ambiguity meaning that for good or for bad your application won’t work in 11g.

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s