You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2016/01/29 20:15:39 UTC

[jira] [Created] (PHOENIX-2642) LIKE predicate does not work if there no wildcard in the pattern

Kevin Liew created PHOENIX-2642:
-----------------------------------

             Summary: LIKE predicate does not work if there no wildcard in the pattern
                 Key: PHOENIX-2642
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2642
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: Phoenix 4.7.0 on Calcite 1.5
            Reporter: Kevin Liew


Does not work:
{code}select at1.col2 from at1 group by at1.col2 having at1.col2 not like 'Mickey Mouse'{code}

Works:
{code}select at1.col2 from at1 group by at1.col2 having at1.col2 not like 'Mickey Mous_'{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)