jnturton opened a new pull request, #2627: URL: https://github.com/apache/drill/pull/2627
# [DRILL-8281](https://issues.apache.org/jira/browse/DRILL-8281): Info schema LIKE with ESCAPE push down bug ## Description [DRILL-8057](https://issues.apache.org/jira/browse/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) ``` This PR makes schema path prefix comparison use RegexpUtil.SqlPatternInfo#getSimplePatternString when comparing prefixes so that escape characters are correctly processed. ## Documentation N/A ## Testing TestInfoSchema#likePatternWithEscapeChar -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
