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)
