Github user mgaido91 commented on the issue:
https://github.com/apache/spark/pull/22029
Oracle doesn't support EQUAL between structs: `(1, 'a') = (1, 'b')` doesn't
work on Oracle. Postgres is the only one returning NULL in the case `(1, 'a') =
(1, null)`.
My main reason here is to make IN working in the same way (assuming that
the same data is involved) both when literals and when subqueries are involved:
this is my goal. One of the main reasons is that often users who want to debug
queries try to put the expected output in the subquery in the IN expression so
having a different behavior may be deceived and anyway a user would be at least
surprised by this behavior.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
