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.