Details
Description
The query below contains two CTE with the same alias name and executed with no error, and returns a result for the last alias.
with CTE1 as (select 42), CTE1 as (select 43) select * FROM CTE1;
For such a situation it should be thrown a validation error.
Attachments
Issue Links
- Testing discovered
-
IGNITE-21947 Cover SQL T121(WITH (excluding RECURSIVE) in query expression) feature by tests
- Resolved