phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5173) LIKE and ILIKE statements return empty result list for search without wildcard
Date Wed, 17 Apr 2019 02:03:00 GMT

    [ 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)

Mime
View raw message