phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Emiliia Nesterovych (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5173) LIKE and ILIKE statements return empty result list for search without wildcard
Date Thu, 28 Feb 2019 08:24:00 GMT
Emiliia Nesterovych created PHOENIX-5173:
--------------------------------------------

             Summary: LIKE and ILIKE statements return empty result list for search without
wildcard
                 Key: PHOENIX-5173
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5173
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
            Reporter: Emiliia Nesterovych


I expect these two statements to return same result, as MySql does:
{code:java}
SELECT * FROM USER WHERE USER_NAME = 'Some Name';
{code}
{code:java}
SELECT * FROM USER LIKE USER_NAME = 'Some Name';
{code}
But while there is data for this script the statement with "LIKE" operator returns empty
result set. Same affects "ILIKE" operator. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message