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

Skip NULLs when scanning index for LESS THAN and LESS THAN or EQUALS

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.0
    • 4.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      For a query predicate with < or <=, e.g.

      WHERE updateTime < "2016-04-04T14:30:00"

      the query engine should generate both upper and lower bounds for the span. The lower bound should be greater than NULL, because NULLs cannot satisfy this predicate. This is required for pushdown and performance.

      Attachments

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            gerald Gerald Sangudi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty