James Turton created DRILL-8278:
-----------------------------------
Summary: 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
Fix For: 1.20.3
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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
