[DRILL-8281] Info schema LIKE with ESCAPE push down bug

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.20.2
• Fix Version/s: 1.20.3
• Component/s: Storage - Information Schema
• Assignee: James Turton
• Reporter: James Turton
• Created: 19/Aug/22 13:59
• Updated: 22/Aug/22 03:53
• Resolved: 22/Aug/22 03:45

Description

DRILL-8057 brought in a regression whereby info schema LIKE patterns containing an escape character are not correctly processed. For example if a storage plugin called dfs_foo (note the presence of the special '_') is present then the following query wrongly returns no records.

apache drill> show databases where schema_name like 'dfs^_foo.%' escape '^';
No rows selected (2.305 seconds)

Issue Links

• is related to: DRILL-8057 INFORMATION_SCHEMA filter push down is inefficient