maropu commented on a change in pull request #26811: [SPARK-29600][SQL] 
array_contains built in function is not backward compatible in 3.0
URL: https://github.com/apache/spark/pull/26811#discussion_r357104358
 
 

 ##########
 File path: docs/sql-migration-guide.md
 ##########
 @@ -256,6 +256,52 @@ license: |
 
   - Since Spark 3.0, the unary arithmetic operator plus(`+`) only accepts 
string, numeric and interval type values as inputs. Besides, `+` with a 
integral string representation will be coerced to double value, e.g. `+'1'` 
results `1.0`. In Spark version 2.4 and earlier, this operator is ignored. 
There is no type checking for it, thus, all type values with a `+` prefix are 
valid, e.g. `+ array(1, 2)` is valid and results `[1, 2]`. Besides, there is no 
type coercion for it at all, e.g. in Spark 2.4, the result of `+'1'` is string 
`1`.
 
+  - Since Spark 3.0, the parameter(first or second) to array_contains function 
is implicitly promoted to the wider type parameter.
 
 Review comment:
   Ah, I see. The current latest fix looks reasonable. This fix is not a 
behaviour change but a bug fix. 

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

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

Reply via email to