[jira] [Closed] (ASTERIXDB-2153) Fulltext does not handle the search option properly

["Taewoo Kim (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Taewoo Kim closed ASTERIXDB-2153.
---------------------------------
    Resolution: Fixed

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