Kevin Liew created PHOENIX-2641: ----------------------------------- Summary: Implicit wildcard in LIKE predicate search pattern Key: PHOENIX-2641 URL: https://issues.apache.org/jira/browse/PHOENIX-2641 Project: Phoenix Issue Type: Bug Affects Versions: 4.7.0 Environment: Phoenix 4.7.0 on Calcite 1.5.0 Reporter: Kevin Liew
LIKE predicates have an implicit wildcard at the end of the search pattern ie. {code:sql}select distinct at1.col2 from at1 group by at1.col2 having at1.col2 like '_'{code} will match every row in the table, including NULL cells -- This message was sent by Atlassian JIRA (v6.3.4#6332)