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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.20.2
• Fix Version/s: 1.20.3
• Component/s: SQL Parser
• Assignee: James Turton
• Reporter: James Turton
• Created: 12/Aug/22 05:47
• Updated: 17/Aug/22 15:16
• Resolved: 17/Aug/22 15:15

Description

In LIKE patterns, the period character is treated as a wildcard when it should act as a simple literal.

 

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)