alamb commented on issue #5633:
URL: 
https://github.com/apache/arrow-datafusion/issues/5633#issuecomment-1653408032

   This query appears to work now in datafusion 28.0.0:
   
   ```
   (arrow_dev) alamb@MacBook-Pro-8:~$ datafusion-cli  -f /tmp/test.sql
   DataFusion CLI v28.0.0
   0 rows in set. Query took 0.001 seconds.
   +---------+---------+
   | column1 | column2 |
   +---------+---------+
   | 1       | 111     |
   | 2       | 222     |
   +---------+---------+
   2 rows in set. Query took 0.001 seconds.
   +---------+
   | column1 |
   +---------+
   | 1       |
   | 2       |
   +---------+
   2 rows in set. Query took 0.000 seconds.
   +---------+
   | column1 |
   +---------+
   | 2       |
   | 1       |
   +---------+
   2 rows in set. Query took 0.001 seconds.
   0 rows in set. Query took 0.002 seconds.
   0 rows in set. Query took 0.001 seconds.
   0 rows in set. Query took 0.001 seconds.
   ```
   
   ```
   (arrow_dev) alamb@MacBook-Pro-8:~$ 
DATAFUSION_OPTIMIZER_SKIP_FAILED_RULES=false datafusion-cli  -f /tmp/test.sql
   DataFusion CLI v28.0.0
   0 rows in set. Query took 0.002 seconds.
   +---------+---------+
   | column1 | column2 |
   +---------+---------+
   | 1       | 111     |
   | 2       | 222     |
   +---------+---------+
   2 rows in set. Query took 0.001 seconds.
   +---------+
   | column1 |
   +---------+
   | 1       |
   | 2       |
   +---------+
   2 rows in set. Query took 0.000 seconds.
   +---------+
   | column1 |
   +---------+
   | 1       |
   | 2       |
   +---------+
   2 rows in set. Query took 0.002 seconds.
   0 rows in set. Query took 0.002 seconds.
   0 rows in set. Query took 0.001 seconds.
   0 rows in set. Query took 0.001 seconds.
   ```
   
   I bet some of @jackwener 's / @mingmwang 's cleanups have fixed it


-- 
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]

Reply via email to