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

Incorrect indexes are picked up for indexed where predicate

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • None
    • 400-2010
      single node (kv, query, index)
      empty buckets - default
      beer-sample bucket
    • Untriaged
    • Unknown

    Description

      1. create bucket beer-sample and default.
      2.create primary view indexes on each of the buckets
      3.create index on meta().type
      4. Issue a query on bucket where meta().type="json" — this always defaults to Primary Scan – causing the tests to fail.

      Automated job to run
      ./testrunner -i /tmp/tuqvm.ini doc-per-day=6,standard_buckets=1,services_init=kv:index:n1ql -t tuqquery.tuq_index.QueriesViewsTests.test_explain_query_meta

      Error formatting macro: code: java.lang.StackOverflowError

      cbq> CREATE INDEX my_index_meta ON `beer-sample`(meta(`beer-sample`).type) ;
      {
      "requestID": "fd90ef05-98b8-4e3f-8ed9-f4023bdf1908",
      "signature": null,
      "results": [
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "6.989639565s", "executionTime": "6.985476848s", "resultCount": 0, "resultSize": 0 }

      }

      cbq> EXPLAIN SELECT name FROM `beer-sample` WHERE meta(`beer-sample`).type = "json";
      {
      "requestID": "eb8dd195-a787-4bca-a24a-e4d8b6489f65",
      "signature": "json",
      "results": [
      {
      "#operator": "Sequence",
      "~children": [

      { "#operator": "PrimaryScan", "index": "#primary", "keyspace": "beer-sample", "namespace": "default", "using": "view" }

      ,
      {
      "#operator": "Parallel",
      "~child": {
      "#operator": "Sequence",
      "~children": [

      { "#operator": "Fetch", "keyspace": "beer-sample", "namespace": "default" }

      ,

      { "#operator": "Filter", "condition": "((meta(`beer-sample`).`type`) = \"json\")" }

      ,
      {
      "#operator": "InitialProject",
      "result_terms": [

      { "expr": "(`beer-sample`.`name`)" }

      ]
      },

      { "#operator": "FinalProject" }

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

      { "elapsedTime": "31.815736ms", "executionTime": "31.465614ms", "resultCount": 1, "resultSize": 1502 }

      }

      whereas
      cbq> SELECT name FROM `beer-sample` WHERE meta(`beer-sample`).type = "json";
      {
      "requestID": "a023abfc-550b-41fd-8744-4ac5b1794d78",
      "signature":

      { "name": "json" }

      ,
      "results": [

      { "name": "Original" }

      ,

      { "name": "Govnor's Public House" }

      ,

      { "name": "Pelican Bay Brown" }

      ,

      { "name": "Derailed Black Cherry Ale" }

      ,

      cbq> select * from system:indexes;
      {
      "requestID": "40c9b401-e683-40ab-99fe-495b1509d604",
      "signature":

      { "*": "*" }

      ,
      "results": [
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "my_index_meta", "index_key": [ "(meta(`default`).`type`)" ], "keyspace_id": "default", "name": "my_index_meta", "namespace_id": "default", "state": "online", "using": "view" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "#primary", "index_key": [ "(meta(`default`).`id`)" ], "keyspace_id": "default", "name": "#primary", "namespace_id": "default", "state": "online", "using": "view" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "#primary", "index_key": [ "(meta(`beer-sample`).`id`)" ], "keyspace_id": "beer-sample", "name": "#primary", "namespace_id": "default", "state": "online", "using": "view" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "my_index_meta", "index_key": [ "(meta(`beer-sample`).`type`)" ], "keyspace_id": "beer-sample", "name": "my_index_meta", "namespace_id": "default", "state": "online", "using": "view" }

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

      { "elapsedTime": "446.996117ms", "executionTime": "446.653723ms", "resultCount": 4, "resultSize": 1736 }

      }

      attaching logs.

      Attachments

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

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            ketaki Ketaki Gangal (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