You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/08/12 05:51:00 UTC
[jira] [Updated] (DRILL-8278) The period character '.' is broken in LIKE patterns
[ https://issues.apache.org/jira/browse/DRILL-8278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Turton updated DRILL-8278:
--------------------------------
Description:
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}
was:
The period character is treated as a wildcard when it should act as a simple literal in a LIKE pattern.
{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
SCHEMA_NAME dfsfoo.root
SCHEMA_NAME dfsfoo.tmp
6 rows selected (0.256 seconds)
{code}
> The period character '.' is broken in 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
> 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)