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: [email protected] For additional commands, e-mail: [email protected]
