[
https://issues.apache.org/jira/browse/CALCITE-1674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15901311#comment-15901311
]
Mark Payne commented on CALCITE-1674:
-------------------------------------
[~julianhyde] - thanks for pointing me in the right direction for unit tests.
Makes a lot of sense to add them there. I added two unit tests. Verified that
they failed without the patch and pass with the patch. Updated the PR
accordingly. Thanks!
> 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
> Fix For: 1.12.0
>
>
> 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)
