> Does these queries work on other databases?
I can test only MS SQL Server today, and the original query generates
error. IMHO, the bug is in both SQLite and MS SQL Server :)
> Are they valid correlated subqueries?
I think, yes.
-----------------------------------------------------------------
Put my initial question another way, I think this is correct SQL:
select (
select a
from (select a
from (select a
from (select a
from (select a
from (select b as a) as T1
) as T2
) as T3
) as T4
) as T5
) as column_1
from (select 1 as b) as T0
It is certainly weird, but it is correct. But SQLite
generate error
--
Best regards,
Alexander mailto:[EMAIL PROTECTED]
