[
https://issues.apache.org/jira/browse/PHOENIX-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15447217#comment-15447217
]
ASF GitHub Bot commented on PHOENIX-2645:
-----------------------------------------
Github user kliewkliew commented on the issue:
https://github.com/apache/phoenix/pull/199
Sure, I'll pick up that JIRA. The unit tests evaluate both byte and string
based regex (and compares the two results) but the integration tests only
evaluate string based regex.
> Wildcard characters do not match newline characters
> ---------------------------------------------------
>
> Key: PHOENIX-2645
> URL: https://issues.apache.org/jira/browse/PHOENIX-2645
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Environment: Phoenix 4.7.0 on Calcite 1.5
> Reporter: Kevin Liew
> Assignee: Kevin Liew
> Labels: newbie
> Fix For: 4.9.0, 4.8.1
>
>
> Wildcard characters do not match newline characters
> {code:sql}
> 0: jdbc:phoenix:thin:url=http://localhost:876> create table testnewline (pk
> varchar(10) primary key)
> . . . . . . . . . . . . . . . . . . . . . . .> ;
> No rows affected (2.643 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> upsert into testnewline values
> ('AA\nA');
> 1 row affected (0.079 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline
> where pk like 'AA%'
> . . . . . . . . . . . . . . . . . . . . . . .> ;
> +------------+
> | PK |
> +------------+
> | AA
> A |
> +------------+
> 1 row selected (0.086 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline
> where pk like 'AA_A';
> +------------+
> | PK |
> +------------+
> +------------+
> No rows selected (0.053 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline
> where pk like 'AA%A';
> +------------+
> | PK |
> +------------+
> +------------+
> No rows selected (0.032 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
