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).