Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
Date: Tue, 7 Nov 2017 22:50:00 +0000 (UTC)
From: "ASF subversion and git services (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.13113412.1509477758000.175854.1510095000363@Atlassian.JIRA>
In-Reply-To: <JIRA.13113412.1509477758000@Atlassian.JIRA>
References: <JIRA.13113412.1509477758000@Atlassian.JIRA> <JIRA.13113412.1509477758298@jira-lw-us.apache.org>
Subject: [jira] [Commented] (ASTERIXDB-2153) Fulltext does not handle the
 search option properly
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 07 Nov 2017 23:58:24 -0000


    [ https://issues.apache.org/jira/browse/ASTERIXDB-2153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16243058#comment-16243058 ] 

ASF subversion and git services commented on ASTERIXDB-2153:
------------------------------------------------------------

Commit 63645130f5e590dae2e117235a37b35d30044943 in asterixdb's branch refs/heads/master from [~wangsaeu]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=6364513 ]

[ASTERIXDB-2153][COMP][RT] Ensure the fulltext search option is properly handled

- user model changes: no
- storage format changes: no
- interface changes: no

details:
When a fulltext search operation is combined with multiple
other predicates, the fulltext search option was not handled
properly. This patch set ensures that the fulltext search option
is correctly handled.

Change-Id: I240fbe08891d29532c6fcd60638a3b6bbe8da771
Reviewed-on: https://asterix-gerrit.ics.uci.edu/2116
Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Taewoo Kim <wangsaeu@gmail.com>
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>


> Fulltext does not handle the search option properly
> ---------------------------------------------------
>
>                 Key: ASTERIXDB-2153
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2153
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Taewoo Kim
>            Assignee: Taewoo Kim
>
> Fulltext search does not handle the search option (conjunctive - AND or disjuctive - OR) properly when a WHERE predicate contains multiple conditions like the following case. It always conducts a disjunctive (OR) search even though the option tells to do "AND" search. 
> {code}
> select t.`text` from twitter.ds_tweet t
> where t.`create_at` >= datetime('2017-10-10T16:48:28.980Z') and t.`create_at` < datetime('2017-10-10T17:48:28.980Z') and ftcontains(t.`text`, ['house','of','cards'], {'mode':'all'});
> {code}
> {code}
> select t.`text` from twitter.ds_tweet t
> where t.`create_at` >= datetime('2017-10-10T16:48:28.980Z') and t.`create_at` < datetime('2017-10-10T17:48:28.980Z') and ftcontains(t.`text`, ['house','of','cards']);
> {code}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)