[PHOENIX-2645] Wildcard characters do not match newline characters

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: newbie

Environment

Phoenix 4.7.0 on Calcite 1.5

• Assignee: Kevin Liew
• Reporter: Kevin Liew
• Created: 29/Jan/16 22:11
• Updated: 28/Sep/16 05:15
• Resolved: 30/Aug/16 19:20

Description

Wildcard characters do not match newline characters

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> 

Issue Links

• is cloned by: PHOENIX-2643 LIKE predicate single-character wildcard '_' does not match any characters in a CHAR column
• links to: GitHub Pull Request #199