Strange result of using CTE

Question

Can someone explain to me why this script returns 'some_word', but not an error about a non-existent schema trying to remove data from schema_that_doesnt_exist.tab?

with tab as (select 'some_word' str from dual)
select * 
from schema_that_doesnt_exist.tab

Some oracle documentation urls on this subject will also help me)

thanks

Answer 1

I assume it is associated with qualified name traversal with :

MariaDB Demo

Oracle Demo

SQLite Demo - no such table: schema_that_doesnt_exists.tab

PostgreSQL Demo - relationship "schema_that_doesnt_exists.tab" does not exist

SQLServer Demo - 'schema_that_doesnt_exists.tab'.