Github user wangyum commented on the issue:

    https://github.com/apache/spark/pull/19635
  
    The below SQL will throw `AnalysisException`. but it can success on Spark 
2.1.x. Hope this can fix soon.
    ```sql
    CREATE TEMPORARY VIEW t4 AS SELECT * FROM VALUES
      (CAST(1 AS DOUBLE), CAST(2 AS STRING), CAST(3 AS STRING))
    AS t1(t4a, t4b, t4c);
    
    CREATE TEMPORARY VIEW t5 AS SELECT * FROM VALUES
      (CAST(1 AS DECIMAL(18, 0)), CAST(2 AS STRING), CAST(3 AS BIGINT))
    AS t1(t5a, t5b, t5c);
    
    SELECT * FROM t4
    WHERE
    (t4a, t4b, t4c) IN (SELECT t5a, t5b, t5c FROM t5);
    ```
    
    cc @yucai @seancxmao


---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to