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

SELECT COUNT(*) ... WHERE should avoid memcached operations

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.5.0
    • cbq-DP3
    • query
    • Security Level: Public
    • Untriaged
    • No

    Description

      Index:

      CREATE INDEX by_year ON bucket-1(year)

      Query:

      SELECT COUNT FROM bucket-1 WHERE year = 1990

      https://gist.github.com/pavel-paulau/7163e8757810004f6506

      https://gist.github.com/pavel-paulau/441692fcf82f05677d46

      Attachments

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

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            pavelpaulau Pavel Paulau (Inactive)
            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