Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-38956

FlexIndex: FTS index(with type mapping) returns 0 results for query:predicate with datetime comparison

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      It has been observed that below datetime fts index field type flex query with fts is not working.

      • Flex using FTS queries with datetime index field : —> not working

                select meta().id, name,join_date from `default` USE INDEX (USING GSI,  USING FTS)  where type='emp' and join_date<'2015-08-13’
                select meta().id, name,join_date from `default` USE INDEX (USING FTS)  where type='emp' and join_date<'2015-08-13’
                select meta().id, name,join_date from `default` USE INDEX (emp_type_index USING FTS)  where type='emp' and join_date<'2015-08-13'
        

        Expected result: 978 rows (same as GSI query)
        Actual result: 0 rows (fts index search is happening as per the plan)

      • Primary GSI index query: --> working as expected

                select meta().id, name,join_date from `default`   where type='emp' and join_date<'2015-08-13’
        

        Expected result: 978 rows
        Actual result: 978 rows

      • Dataset: Attached
      • FTS index definition : attached.

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              jagadesh.munta@couchbase.com Jagadesh Munta
              jagadesh.munta@couchbase.com Jagadesh Munta
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty