[
https://issues.apache.org/jira/browse/PHOENIX-5173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819657#comment-16819657
]
Hadoop QA commented on PHOENIX-5173:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12966169/PHOENIX-5173.4.x-HBase-1.3.v1.patch
against 4.x-HBase-1.3 branch at commit
2e12af8e0d8c58a7ad4178b0476057d02fb1a7a3.
ATTACHMENT ID: 12966169
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:red}-1 tests included{color}. The patch doesn't appear to include
any new or modified tests.
Please justify why no new tests are needed for this
patch.
Also please list what manual steps were performed to
verify this patch.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:red}-1 release audit{color}. The applied patch generated 6 release
audit warnings (more than the master's current 0 warnings).
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:red}-1 core tests{color}. The patch failed these unit tests:
org.apache.phoenix.compile.WhereOptimizerTest
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/2512//testReport/
Release audit warnings:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/2512//artifact/patchprocess/patchReleaseAuditWarnings.txt
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/2512//console
This message is automatically generated.
> 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
> Assignee: Swaroopa Kadam
> Priority: Blocker
> Attachments: PHOENIX-5173.4.x-HBase-1.3.v1.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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}
> CREATE SCHEMA IF NOT EXISTS my_schema;
> CREATE TABLE my_schema.user (USER_NAME VARCHAR(255), ID BIGINT NOT NULL
> PRIMARY KEY);{code}
> Fill up query:
> {code:java}
> UPSERT INTO my_schema.user VALUES('Some Name', 1);{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
