calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Payne (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1674) LIKE Operator with % does not match when column contains newline
Date Tue, 07 Mar 2017 19:15:38 GMT
Mark Payne created CALCITE-1674:
-----------------------------------

             Summary: LIKE Operator with % does not match when column contains newline
                 Key: CALCITE-1674
                 URL: https://issues.apache.org/jira/browse/CALCITE-1674
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Mark Payne
            Assignee: Julian Hyde


If I have a column where some rows contain a newline, then using a % does not match as it
should. For example, if I have a column named 'foo' where a row contains 'My\nValue' then
the following query I would expect to match:

SELECT * FROM MyTable WHERE foo LIKE 'M%'

However, this row is not returned by the above query. This appears to be a bug in the regex
generated by the org.apache.calcite.runtime.Like class, as it generates '.*' for the %, but
in Java the dot character does not match newlines unless it is compiled in dot-all mode.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message