[jira] [Commented] (DRILL-8278) The period character '.' is broken in SQL LIKE patterns

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-8278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17578932#comment-17578932 ] 

ASF GitHub Bot commented on DRILL-8278:
---------------------------------------

jnturton opened a new pull request, #2621:
URL: https://github.com/apache/drill/pull/2621

   # [DRILL-8278](https://issues.apache.org/jira/browse/DRILL-8278): The period character '.' is broken in SQL LIKE patterns
   
   ## Description
   
   The '.' character is added to the JAVA_REGEX_SPECIALS string in RegexpUtil (as has subsequently happened in the Calcite code that was originally copied to create this class).
   
   It will now be possible to use '.' correctly in queries like `show databases where table_schema like 'dfs.%'`
   
   ## Documentation
   No change.
   
   ## Testing
   TestSqlPatterns#testSqlRegexLike
   




> The period character '.' is broken in SQL LIKE patterns
> -------------------------------------------------------
>
>                 Key: DRILL-8278
>                 URL: https://issues.apache.org/jira/browse/DRILL-8278
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: 1.20.2
>            Reporter: James Turton
>            Assignee: James Turton
>            Priority: Minor
>             Fix For: 1.20.3
>
>
> In LIKE patterns, the period character is treated as a wildcard when it should act as a simple literal.
>  
> {code:java}
> apache drill> show databases where schema_name like 'dfs.%';
> SCHEMA_NAME  dfs.default
> SCHEMA_NAME  dfs.root
> SCHEMA_NAME  dfs.tmp
> SCHEMA_NAME  dfsfoo.default -- should not be present
> SCHEMA_NAME  dfsfoo.root    -- should not be present
> SCHEMA_NAME  dfsfoo.tmp     -- should not be present
> 6 rows selected (0.256 seconds)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)