Github user mgaido91 commented on a diff in the pull request:

    https://github.com/apache/spark/pull/21403#discussion_r198868288
  
    --- Diff: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/predicates.scala
 ---
    @@ -161,33 +161,38 @@ case class Not(child: Expression)
            true
       """)
     // scalastyle:on line.size.limit
    -case class In(value: Expression, list: Seq[Expression]) extends Predicate {
    +case class In(values: Seq[Expression], list: Seq[Expression]) extends 
Predicate {
    --- End diff --
    
    Well, that would really work. We have the same problem also in the case we 
don't have a subquery. Eg. from Postgres:
    ```
    mgaido=# select 1 from (select (1, 'a') as col1) tab1 where col1 in ((1, 
'a'));
    ERROR:  could not identify an equality operator for type unknown
    mgaido=# select 1 from (select (1, 'a') as col1) tab1 where (1, 'a') in 
((1, 'a'));
     ?column? 
    ----------
            1
    (1 row)
    ```


---

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to