tgujar commented on issue #8361:
URL: 
https://github.com/apache/arrow-datafusion/issues/8361#issuecomment-1852390607

   Maybe, I am unsure how to rewrite the query to avoid alias here
   ```sql
   SELECT * FROM data WHERE a IN (SELECT a FROM data2 WHERE f NOT IN ('a', 'b', 
'c', 'd'))
   ```
   `assert_expected_plan` works fine for cases like this where plans are 
equivalent but don't have the same representation as a string. I am not sure if 
its usage in tests is encouraged though. If I understand correctly, changes to 
the plan generation might break these tests where we compare for exact string 
equality.


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