Don't allow common table expressions with the same name
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9309 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Problem description
Exasol allows common table expressions with the same name:
with a as (select 3 as c) , a as (select 2 as c) select * from a;
This is forbidden according to the SQL standard and should raise an error.