Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-01799 not always raised when it should

1321532Sep 2 2023 — edited Sep 4 2023

I've had a SR open (and global support in India is playing pong with me) for nearly 3 mths because most instances do the following query wrong with a wrong result …

SQL> select count(*) from all_synonyms
2 left
3 join all_objects b on (b.owner,object_name)=(select table_owner,table_name from dual)
4 ;

COUNT(*)
----------
13466

… and one does it as expected (because of not being supported) …

SQL> select count(*) from all_synonyms
2 left
3 join all_objects b on (b.owner,object_name)=(select table_owner,table_name from dual)
4 ;
select count(*) from all_synonyms
*
FEHLER in Zeile 1:
ORA-01799: a column may not be outer-joined to a subquery

Comments highly appreciated (not how to rewrite the query but how to finally get a BUG opened on this).

Comments
Post Details
Added on Sep 2 2023
10 comments
346 views