[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15468777#comment-15468777 ]
Hudson commented on PHOENIX-2641: --------------------------------- FAILURE: Integrated in Jenkins build Phoenix-master #1382 (See [https://builds.apache.org/job/Phoenix-master/1382/]) PHOENIX-2641 Implicit wildcard in LIKE predicate search pattern (tdsilva: rev c02d6cb5971f7b17bcd5e308952fa081e32adf19) * (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java * (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/LikeExpressionIT.java * (edit) phoenix-core/src/test/java/org/apache/phoenix/expression/LikeExpressionTest.java > 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 > Fix For: 4.9.0, 4.8.1 > > > 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)