Github user dilipbiswal commented on the issue: https://github.com/apache/spark/pull/22408 @ushin @gatorsmile Here are the results from presto. Please let me know if you want me try any case in particular. One thing to note is that presto allows comparison between int and decimal. In our `findTightestCommonType` we don't do the promotion. ``` SQL presto:default> select contains(array[1,2,3], '1'); Query 20180914_053612_00006_pru6h failed: line 1:8: Unexpected parameters (array(integer), varchar(1)) for function contains. Expected: contains(array(T), T) T:comparable select contains(array[1,2,3], '1') presto:default> select contains(array[1,2,3], 'foo'); Query 20180914_053729_00007_pru6h failed: line 1:8: Unexpected parameters (array(integer), varchar(3)) for function contains. Expected: contains(array(T), T) T:comparable select contains(array[1,2,3], 'foo') presto:default> select contains(array['1','2','3'], 1); Query 20180914_053850_00008_pru6h failed: line 1:8: Unexpected parameters (array(varchar(1)), integer) for function contains. Expected: contains(array(T), T) T:comparable select contains(array['1','2','3'], 1) presto:default> select contains(array[1,2,3], cast(1.0 as decimal(10,2))); _col0 ------- true (1 row) presto:default> select contains(array[1,2,3], cast(1.0 as double)); _col0 ------- true (1 row) ```
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org