[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15439775#comment-15439775 ]
ASF GitHub Bot commented on PHOENIX-2641: ----------------------------------------- Github user kliewkliew closed the pull request at: https://github.com/apache/phoenix/pull/200 > 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 > Assignee: Kevin Liew > Labels: newbie > > 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 cell in col2 whereas it should only match single-character > cells. > This affects both VARCHAR and CHAR. > Note that selecting by pattern '__' (two single-character wildcards) works > properly for VARCHAR but not for CHAR (no result). -- This message was sent by Atlassian JIRA (v6.3.4#6332)