asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taewoo Kim (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ASTERIXDB-2153) Fulltext does not handle the search option properly
Date Tue, 31 Oct 2017 19:23:03 GMT
Taewoo Kim created ASTERIXDB-2153:
-------------------------------------

             Summary: 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


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)

Mime
View raw message