goldmedal commented on issue #12637:
URL: https://github.com/apache/datafusion/issues/12637#issuecomment-2457058113
Interesting, I haven't checked the source code but I tried different numbers
of the `%` char. Only one and two will be wrong.
```
> select arrow_cast(null, 'Utf8View') like '%';
+--------------------------------------------------+
| arrow_cast(NULL,Utf8("Utf8View")) LIKE Utf8("%") |
+--------------------------------------------------+
| true |
+--------------------------------------------------+
1 row(s) fetched.
Elapsed 0.001 seconds.
> select arrow_cast(null, 'Utf8View') like '%%';
+---------------------------------------------------+
| arrow_cast(NULL,Utf8("Utf8View")) LIKE Utf8("%%") |
+---------------------------------------------------+
| true |
+---------------------------------------------------+
1 row(s) fetched.
Elapsed 0.001 seconds.
> select arrow_cast(null, 'Utf8View') like '%%%';
+----------------------------------------------------+
| arrow_cast(NULL,Utf8("Utf8View")) LIKE Utf8("%%%") |
+----------------------------------------------------+
| |
+----------------------------------------------------+
1 row(s) fetched.
Elapsed 0.001 seconds.
> select arrow_cast(null, 'Utf8View') like '%%%%';
+-----------------------------------------------------+
| arrow_cast(NULL,Utf8("Utf8View")) LIKE Utf8("%%%%") |
+-----------------------------------------------------+
| |
+-----------------------------------------------------+
1 row(s) fetched.
Elapsed 0.001 seconds.
```
It's a nice find 👍
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
