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] [Commented] (ASTERIXDB-2153) Fulltext does not handle the search option properly
Date Wed, 01 Nov 2017 17:47:00 GMT

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

Mime
View raw message