weijunlu opened a new issue, #2686:
URL: https://github.com/apache/drill/issues/2686
The function ILIKE syntax check error in the master version
1. The version information is as follows:
apache drill> select commit_message, commit_time from sys.version;
+----------------------------------------------------------------------------------+---------------------------+
| commit_message
| commit_time |
+----------------------------------------------------------------------------------+---------------------------+
| DRILL-8314: Add support for automatically retrying and disabling broken
storage plugins (#2655) | 18.10.2022 @ 18:15:31 CST |
2. The error message is as follows:
apache drill> SELECT ILIKE('abcde', 'ABC%') FROM (VALUES(1));
Error: PARSE ERROR: Encountered "" at line 1, column 8.
SQL Query: SELECT ILIKE('abcde', 'ABC%') FROM (VALUES(1))
^
[Error Id: 58f34ff2-ae8f-4479-9089-90e8be450613 ] (state=,code=0)
-------------------------------------------------------------------------------------
But there was no problem with the other commit in the master version.
1. The version information is as follows:
apache drill> select commit_message, commit_time from sys.version;
+-----------------------------------------------------------+---------------------------+
| commit_message |
commit_time |
+-----------------------------------------------------------+---------------------------+
| DRILL-8273: Complex typed columns cannot be made implicit | 31.07.2022 @
14:34:14 CST |
+-----------------------------------------------------------+---------------------------+
2. The ilike function is executed as follows:
apache drill> SELECT ILIKE('abcde', 'ABC%') FROM (VALUES(1));
+--------+
| EXPR$0 |
+--------+
| true |
+--------+
--
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: dev-unsubscr...@drill.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
