winifredtang created CALCITE-2360: ------------------------------------- Summary: Why doesn't Like.sqlToRegexSimilar(String sqlPattern,char escapeChar) translate "." into "\\."? Key: CALCITE-2360 URL: https://issues.apache.org/jira/browse/CALCITE-2360 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.16.0 Reporter: winifredtang Assignee: Julian Hyde
org.apache.calcite.runtime.SqlFunctions.similar function call Like.sqlToRegexSimilar(String sqlPattern,char escapeChar) to translate SQL SIMILAR pattern to Java regex pattern. "." in SQL SIMILAR pattern is not a metacharacter, but when Like.sqlToRegexSimilar translates it to Java regex pattern, it becomes a metacharacter. For example, in SQL SIMILAR pattern, only string "ab." can match the pattern "ab.", but the result of org.apache.calcite.runtime.SqlFunctions.similar("ab1", "ab.") can also ruturn ture. -- This message was sent by Atlassian JIRA (v7.6.3#76005)