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

Precise index scans for NOW() and CLOCK() predicates

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Critical
    • 4.6.0, 5.0.0
    • 4.5.0
    • query

    Description

      In 4.5, predicates involving NOW() and CLOCK() functions lead to broad scans of secondary indexes. They should instead lead to precise scans based on the actual clock values at execution time.

      See https://forums.couchbase.com/t/n1ql-how-to-use-a-gsi-when-doing-a-join/8539/6

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            gerald Gerald Sangudi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty