Github user dilipbiswal commented on the issue: https://github.com/apache/spark/pull/22408 @cloud-fan For the above case, from the plan, it seems like presto convert both sides to decimal(12,2) ```SQL presto:default> explain select contains(array[1], 1.34); Query Plan ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ - Output[_col0] => [contains:boolean] Cost: {rows: 1 (10B), cpu: 10.00, memory: 0.00, network: 0.00} _col0 := contains - Project[] => [contains:boolean] Cost: {rows: 1 (10B), cpu: 10.00, memory: 0.00, network: 0.00} contains := "contains"(CAST("$literal$array(integer)"("from_base64"('CQAAAElOVF9BUlJBWQEAAAAAAQAAAA==')) AS array(decimal(12,2))), CAST(DECIMAL '1.34' AS decimal - LocalExchange[ROUND_ROBIN] () => Cost: {rows: 1 (0B), cpu: 0.00, memory: 0.00, network: 0.00} - Values => [] Cost: {rows: 1 (0B), cpu: 0.00, memory: 0.00, network: 0.00} () ```
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org