You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "findepi (via GitHub)" <gi...@apache.org> on 2024/10/31 08:55:27 UTC

Re: [I] The LIKE and ILIKE behavior for NULL handling in StringView differs from other string types [datafusion]

findepi commented on issue #12637:
URL: https://github.com/apache/datafusion/issues/12637#issuecomment-2449352017

   Concise repro. This should return NULL
   
   ```
   > select arrow_cast(null, 'Utf8') LIKE '%';
   +----------------------------------------------+
   | arrow_cast(NULL,Utf8("Utf8")) LIKE Utf8("%") |
   +----------------------------------------------+
   | true                                         |
   +----------------------------------------------+
   ```
   
   @goldmedal can you please change issue title to something like ``Incorrect LIKE and ILIKE result for NULL input and `%` pattern``?


-- 
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@datafusion.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org