James Turton created DRILL-8281: ----------------------------------- Summary: Info schema LIKE with ESCAPE push down bug Key: DRILL-8281 URL: https://issues.apache.org/jira/browse/DRILL-8281 Project: Apache Drill Issue Type: Bug Components: Storage - Information Schema Affects Versions: 1.20.2 Reporter: James Turton Assignee: James Turton Fix For: 1.20.3
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. {code:java} apache drill> show databases where schema_name like 'dfs^_foo.%' escape '^'; No rows selected (2.305 seconds){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)