[ https://issues.apache.org/jira/browse/PHOENIX-5173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emiliia Nesterovych updated PHOENIX-5173: ----------------------------------------- Description: I expect these two statements to return same result, as MySql does: {code:java} SELECT * FROM my_schema.user WHERE USER_NAME = 'Some Name'; {code} {code:java} SELECT * FROM my_schema.user WHERE USER_NAME LIKE 'Some Name'; {code} But while there is data for these scripts, the statement with "LIKE" operator returns empty result set. Same affects "ILIKE" operator. Create table SQL is: {code:java} {code} was: I expect these two statements to return same result, as MySql does: {code:java} SELECT * FROM my_schema.user WHERE USER_NAME = 'Some Name'; {code} {code:java} SELECT * FROM my_schema.user WHERE USER_NAME LIKE 'Some Name'; {code} But while there is data for these scripts, the statement with "LIKE" operator returns empty result set. Same affects "ILIKE" operator. > 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 > Priority: Blocker > > I expect these two statements to return same result, as MySql does: > {code:java} > SELECT * FROM my_schema.user WHERE USER_NAME = 'Some Name'; > {code} > {code:java} > SELECT * FROM my_schema.user WHERE USER_NAME LIKE 'Some Name'; > {code} > But while there is data for these scripts, the statement with "LIKE" operator > returns empty result set. Same affects "ILIKE" operator. > Create table SQL is: > {code:java} > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)