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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
