xudong963 commented on pull request #1639: URL: https://github.com/apache/arrow-datafusion/pull/1639#issuecomment-1019091358
It is a unreasonable behavior that a single cte block with the same name for many times. But currently, datafusion doesn't process it correctly. ```sql // datafusion ❯ create table t1 as select '123' as c; 0 rows in set. Query took 0.005 seconds. ❯ create table t3 as select '12' as c; 0 rows in set. Query took 0.005 seconds. ❯ with a as (select * from t1), a as (select * from t3) select * from a; +----+ | c | +----+ | 12 | +----+ 1 row in set. Query took 0.007 seconds. //postgres postgres=# with a as (select * from t1), a as (select * from t2) select * from a; ERROR: WITH query name "a" specified more than once LINE 1: with a as (select * from t1), a as (select * from t2) select... ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
