houqp commented on pull request #605:
URL: https://github.com/apache/arrow-datafusion/pull/605#issuecomment-867342777


   @alamb, I wasn't able to reproduce the errors you showed in 
https://github.com/apache/arrow-datafusion/pull/605#pullrequestreview-690682368
   
   Here is what I got:
   
   ```
   > CREATE EXTERNAL TABLE foo(bar int)
   STORED AS CSV
   LOCATION '/tmp/foo.csv';
   0 rows in set. Query took 0.001 seconds.
   > select f1.bar, f2.bar from foo as f1 JOIN foo as f2 ON f1.bar = f2.bar;
   +-----+-----+
   | bar | bar |
   +-----+-----+
   | 3   | 3   |
   | 1   | 1   |
   | 4   | 4   |
   | 2   | 2   |
   +-----+-----+
   4 rows in set. Query took 0.022 seconds.
   >  select * from foo as f1 JOIN foo as f2 ON f1.bar = f2.bar;
   +-----+-----+
   | bar | bar |
   +-----+-----+
   | 3   | 3   |
   | 1   | 1   |
   | 4   | 4   |
   | 2   | 2   |
   +-----+-----+
   4 rows in set. Query took 0.022 seconds.
   > select f1.bar, f2.bar from foo as f1 JOIN foo as f2 USING(bar);
   +-----+-----+
   | bar | bar |
   +-----+-----+
   | 2   | 2   |
   | 3   | 3   |
   | 1   | 1   |
   | 4   | 4   |
   +-----+-----+
   4 rows in set. Query took 0.020 seconds.
   > 
   ```
   
   Perhaps you rain those tests with a different build?


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

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to