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

SELECT distinct name FROM <bucket> WHERE META(<bucket>).id IS NOT NULL gives 0 results with primary index using view.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.5.0
    • query
    • Security Level: Public
    • 4.5.0-913
    • Untriaged
    • Yes

    Description

       

      1. Load bucket default with 2016 docs.

      2. Execute test_meta using command:
      ./testrunner -i rqg.ini doc-per-day=1,primary_indx_type=GSI,standard_buckets=1 -t tuqquery.tuq.QueryTests.test_meta,GROUP=SCALAR;META;P0

      The above test fails executing below query:
      cbq> SELECT distinct name FROM default WHERE META(default).id IS NOT NULL;
      {
      "requestID": "0692d111-e365-4e53-bc2c-4cb4f038fcbf",
      "signature":

      { "name": "json" }

      ,
      "results": [
      ],
      "errors": [

      { "code": 5000, *"msg": "Panic: interface conversion: interface is nil, not string - cause: interface conversion: interface is nil, not string"* }

      ],
      "status": "stopped",
      "metrics":

      { "elapsedTime": "2.66816ms", "executionTime": "2.57217ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      3.Below query works good:
      cbq> SELECT distinct name FROM default WHERE META(default).`type` = "json";
      {
      "requestID": "5e9b2009-2147-457a-9a84-3357abd4e7c1",
      "signature":

      { "name": "json" }

      ,
      "results": [

      { "name": "employee-12" }

      ,

      { "name": "employee-5" }

      ,

      { "name": "employee-14" }

      ,

      { "name": "employee-19" }

      ,

      { "name": "employee-13" }

      ,

      { "name": "employee-3" }

      ,

      { "name": "employee-20" }

      ,

      { "name": "employee-18" }

      ,

      { "name": "employee-2" }

      ,

      { "name": "employee-27" }

      ,

      { "name": "employee-25" }

      ,

      { "name": "employee-7" }

      ,

      { "name": "employee-26" }

      ,

      { "name": "employee-22" }

      ,

      { "name": "employee-24" }

      ,

      { "name": "employee-11" }

      ,

      { "name": "employee-8" }

      ,

      { "name": "employee-28" }

      ,

      { "name": "employee-23" }

      ,

      { "name": "employee-10" }

      ,

      { "name": "employee-6" }

      ,

      { "name": "employee-15" }

      ,

      { "name": "employee-4" }

      ,

      { "name": "employee-9" }

      ,

      { "name": "employee-17" }

      ,

      { "name": "employee-1" }

      ,

      { "name": "employee-21" }

      ,

      { "name": "employee-16" }

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

      { "elapsedTime": "396.320336ms", "executionTime": "396.217126ms", "resultCount": 28, "resultSize": 1251 }

      }

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-17263
          # Subject Branch Project Status CR V

          Activity

            People

              johan.larson Johan Larson (Inactive)
              Prerna.Manaktala Prerna Manaktala (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