[ https://issues.apache.org/jira/browse/PHOENIX-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15439231#comment-15439231 ]
ASF GitHub Bot commented on PHOENIX-2645: ----------------------------------------- GitHub user kliewkliew opened a pull request: https://github.com/apache/phoenix/pull/199 PHOENIX-2645 Wildcard characters do not match newline characters You can merge this pull request into a Git repository by running: $ git pull https://github.com/kliewkliew/phoenix PHOENIX-2645 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/phoenix/pull/199.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #199 ---- commit 813a7c698563a80ebe7f727fa2f5f6a20c20137d Author: kliewkliew <kliewkl...@users.noreply.github.com> Date: 2016-08-24T10:06:03Z PHOENIX-2645 Wildcard characters do not match newline characters ---- > 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 > Labels: newbie > Fix For: 4.9.0 > > > 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)