On 2017/06/30 1:05 PM, Thomas Kellerer wrote:
But to be consistent you would need to throw an exception for derived tables as
well, as they have the same visibility.
good point
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe
But to be consistent you would need to throw an exception for derived
tables as well, as they have the same visibility.
However, the following works as expected (given the table definitions from
my initial post):
select *
from (
select c3, c4 + 42
from b
) a;
Am Freitag, 30. Juni 2017
I'm inclined to take the simple approach and throw an exception if a CTE alias is declared with the same name as an
existing table or view.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails