[GitHub] [arrow-datafusion] WinkerDu opened a new issue, #2626: Like, NotLike expressions work with literal `NULL`

[GitBox <gi...@apache.org>]

WinkerDu opened a new issue, #2626:
URL: https://github.com/apache/arrow-datafusion/issues/2626

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   `like`, `not like` expressions doesn't work well with literal `NULL` in DF.
   
   **To Reproduce**
   ```
   > SELECT column1 like NULL from (values('a'), ('b'), (NULL)) as t
   Plan("'Utf8 LIKE Null' can't be evaluated because there isn't a common type to coerce the types to")
   ```
   Postgres works like
   ```
   # SELECT column1 like NULL from (values('a'), ('b'), (NULL)) as t;
    ?column? 
   ----------
    
    
    
   (3 rows)
   ```
   
   **Describe the solution you'd like**
   - Introduces `null_coercion` to `like_coercion`
   - Enhances `compute_utf8_op_scalar` to produce null array when  scalar value `NULL` inputs.
   
   **Describe alternatives you've considered**
   No.
   
   **Additional context**
   No.
   


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] alamb closed issue #2626: Like, NotLike expressions work with literal `NULL`

[GitBox <gi...@apache.org>]

alamb closed issue #2626: Like, NotLike expressions work with literal `NULL`
URL: https://github.com/apache/arrow-datafusion/issues/2626


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org