Failed to run SQL that uses full outer join with a boolean literal join condition #5382
Description
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
DataFusion CLI v18.0.0
❯ create table test1(intt int, inttt int) as select 1 as intt, 2 as inttt;
0 rows in set. Query took 0.017 seconds.
❯ create table test2(intt int, inttt int) as select 1 as intt, 2 as inttt;
0 rows in set. Query took 0.006 seconds.
❯ SELECT *
FROM test2
FULL JOIN test1 ON true;
Execution error: Build left right indices error
❯ Expected behavior
A clear and concise description of what you expected to happen.
return the correct record
Additional context
Add any other context about the problem here.