[I] Projections require unique expression names error [arrow-datafusion]

[via GitHub]

lewiszlw opened a new issue, #9130:
URL: https://github.com/apache/arrow-datafusion/issues/9130

   ### Describe the bug
   
   Datafusion failed to execute `select * from (t1 cross join t2) as t cross 
join t3` with error message
   ```
   Error during planning: Projections require unique expression names but the 
expression "t.a" at position 0 and "t.a" at position 2 have the same name. 
Consider aliasing ("AS") one of them.
   ```
   I tested on sqlite3 and it return expected result.
   latest commit: 840499fbd3c25bf82a6ee0641ef6888079e096da
   
   ### To Reproduce
   
   create table t1 (a int, b int);
   create table t2 (a int, b int);
   create table t3 (a int, b int);
   insert into t1 values (1, 2);
   insert into t2 values (3, 4);
   insert into t3 values (5, 6);
   select * from (t1 cross join t2) as t cross join t3;
   
   ### Expected behavior
   
   Return result like sqlite3
   ```
   1|2|3|4|5|6
   ```
   
   ### Additional context
   
   _No response_


-- 
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: github-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org