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

COUNT(*) with USE KEYS return wrong results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.0
    • 4.1.0, 4.5.0
    • query
    • Security Level: Public
    • None
    • Untriaged
    • Unknown

    Description

      cbq> select count from `beer-sample`;
      {
      "requestID": "698d6efa-99f7-4368-857f-c489512ea23b",
      "signature":

      { "$1": "number" }

      ,
      "results": [

      { "$1": 7304 }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "16.443185ms", "executionTime": "16.381563ms", "resultCount": 1, "resultSize": 34 }

      }

      cbq> select count(1) from `beer-sample` use keys ["z1"];
      {
      "requestID": "ec774d85-86c6-4a34-914c-e36066d5575f",
      "signature":

      { "$1": "number" }

      ,
      "results": [

      { "$1": 1 }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "1.752055ms", "executionTime": "1.717205ms", "resultCount": 1, "resultSize": 31 }

      }

      In the query below, count is ignoring the USE KEYS.
      cbq> select count from `beer-sample` use keys ["z1"];
      {
      "requestID": "670ee574-d27d-4438-9c6f-0d8c21c5bb98",
      "signature":

      { "$1": "number" }

      ,
      "results": [

      { "$1": 7304 }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "12.417036ms", "executionTime": "12.383154ms", "resultCount": 1, "resultSize": 34 }

      }

      cbq>

      Attachments

        Issue Links

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

          Activity

            People

              keshav Keshav Murthy
              keshav Keshav Murthy
              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