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

["Chen Li (JIRA)" <ji...@apache.org>]

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

Chen Li commented on ASTERIXDB-2153:
------------------------------------

For our record, this bug was found when we issued the query "house of cards" on Cloudberry/TwitterMap.

Just curious: did this bug exist before?  If so, does it mean previously when we issued multiple keywords on TwitterMap, the results were not correct since the engine was using "OR"?  The reason it was not found earlier was because those queries still didn't generate too many results?

> 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
>            Priority: Major
>
> 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)