alamb commented on issue #2867:
URL: https://github.com/apache/datafusion/issues/2867#issuecomment-2305061069
This query seems to work great on datafusion 41.0.0
```sql
andrewlamb@Andrews-MacBook-Pro-2:~/Software/datafusion2$ datafusion-cli
DataFusion CLI v41.0.0
> create or replace table test1(c0 int, c1 int, c2 int, c3 int);
0 row(s) fetched.
Elapsed 0.030 seconds.
> SELECT __t404.__c394, __t404.__c395, __t404.__c396, __t404.__c397
FROM ((
(SELECT test1.c0 AS __c394, test1.c1 AS __c395, test1.c2 AS __c396,
test1.c3 AS __c397
FROM (test1)) __t398
INNER JOIN
(SELECT test1.c0 AS __c399, test1.c1 AS __c400, test1.c2 AS __c401,
test1.c3 AS __c402
FROM (test1)) __t403
ON __t398.__c395 = __t403.__c401) __t404)
WHERE __t404.__c395 != __t404.__c396;
+--------+--------+--------+--------+
| __c394 | __c395 | __c396 | __c397 |
+--------+--------+--------+--------+
+--------+--------+--------+--------+
0 row(s) fetched.
Elapsed 0.046 seconds.
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
