You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by GitBox <gi...@apache.org> on 2022/10/20 06:27:26 UTC

[GitHub] [drill] weijunlu opened a new issue, #2686: The function ILIKE syntax check error in the master version

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

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


[GitHub] [drill] vvysotskyi commented on issue #2686: The function ILIKE syntax check error in the master version

Posted by GitBox <gi...@apache.org>.
vvysotskyi commented on issue #2686:
URL: https://github.com/apache/drill/issues/2686#issuecomment-1285492786

   It fails because `ILIKE` became the reserved keyword. Please try using it with quotes: 
   ```sql
   SELECT `ILIKE`('abcde', 'ABC%') FROM (VALUES(1))
   ```


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

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


[GitHub] [drill] jnturton closed issue #2686: The function ILIKE syntax check error in the master version

Posted by GitBox <gi...@apache.org>.
jnturton closed issue #2686: The function ILIKE syntax check error in the master version
URL: https://github.com/apache/drill/issues/2686


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

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


[GitHub] [drill] jnturton commented on issue #2686: The function ILIKE syntax check error in the master version

Posted by GitBox <gi...@apache.org>.
jnturton commented on issue #2686:
URL: https://github.com/apache/drill/issues/2686#issuecomment-1285487900

   Thank you for these very helpful reports. I've confirmed this one so far. Please feel free to capture future reports directly into the Drill bug tracker in [the Apache Jira](https://issues.apache.org/jira/).


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

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


[GitHub] [drill] jnturton commented on issue #2686: The function ILIKE syntax check error in the master version

Posted by GitBox <gi...@apache.org>.
jnturton commented on issue #2686:
URL: https://github.com/apache/drill/issues/2686#issuecomment-1285502739

   Thanks @vvysotskyi I'll update the docs for this function.


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

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