[
https://issues.apache.org/jira/browse/ASTERIXDB-2153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16234466#comment-16234466
]
Taewoo Kim commented on ASTERIXDB-2153:
---------------------------------------
Yes. This bug was not detected when I implemented the fulltext feature. There
are bunch of test cases and they all cover single condition (only contains
ftcontains predicate). For Twittermap, since it combines the time range and
fulltext predicate, this bug could surface. Again, if you just send a fulltext
predicate, it would work fine. Anyway, a fix is on the way.
> 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)
