liuyongvs opened a new pull request, #22946:
URL: https://github.com/apache/flink/pull/22946

   the spark and flink's behavior is different.
   
   ```
   spark: array_contains(array[1, null], null) -> null
   flink: array_contains(array[1, null], null) -> true  
   so array_remove is also different(the array_remove is  supported by me, 
which aligns with flink).
   ```
   ```
   spark: array_remove(array[1, null], null) -> null 
   flink: array_remove(array[1, null], null) -> 1  
   while array_position is align with spark, i think it is not correct.
   ```
   
   
   spark: array_position(array[1, null], null) -> 2 
   flink: array_position(array[1, null], null) -> 2   
   and i test on postgre which is also 2
   
   postgre:
   select array_position(ARRAY[1, null], null); 
   so the semantic should only follow one way to handle null element. so i 
think it should be changed


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to