[ https://issues.apache.org/jira/browse/PHOENIX-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Liew reassigned PHOENIX-2645: ----------------------------------- Assignee: Kevin Liew > 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 > > > 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)