duplicated CTE names are allowed

[xxchan]

Describe the bug

dev=> with cte1 as (select 42), cte1 as (select 43) select * FROM cte1;
 ?column? 
----------
       43
(1 row)

Error message/log

No response

To Reproduce

No response

Expected behavior

error: WITH query name "cte1" specified more than once

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

found in #5987

[xxchan]

It seems this occurs after supporting #7212

# refer to same-named CTE in a subquery expression
query I
with cte as (Select i as j from a) select * from cte where j = (with cte as (select max(j) as j from cte) select j from cte);
----
42

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[xxchan]

Not very harmful, so leave for the future