[PHOENIX-3046] NOT LIKE with wildcard unexpectedly returns results

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: like like-predicate phoenix regex wildcard wildcards
• Assignee: Kevin Liew
• Reporter: Kevin Liew
• Created: 04/Jul/16 20:24
• Updated: 27/Nov/16 07:42
• Resolved: 12/Sep/16 18:58

Description

The following returns all rows in the table when it should return no rows:

select * from emp where first_name not like '%'

The following returns no rows as expected:

select * from emp where first_name not like '%%'

first_name is a VARCHAR column

Issue Links

• is related to: PHOENIX-2641 Implicit wildcard in LIKE predicate search pattern
• links to: GitHub Pull Request #208