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

UnnestScan on scalar values not generating proper spans

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      INSERT INTO default VALUES("01",{"ka1": [1,2,3,100,101], "ka2":[{"id":1},{"id":100}]});
      CREATE INDEX ix1 ON default (ALL v FOR v IN ka1 END);
      EXPLAIN SELECT v  FROM default d UNNEST d.ka1 AS v WHERE v = 100;
       
      Span generated is v IS NOT MISSING; 
       
       
      Following works. Because Unnest results as object  and where clause has fields.
       
      CREATE INDEX ix2 ON default (ALL v1.id FOR v IN ka2 END);
      EXPLAIN SELECT v1.id  FROM default d UNNEST d.ka2 AS v1 WHERE v1.id = 100;
      

      Filter classification needs to take care of identifiers. that matched with keyspace.

      Attachments

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

        Activity

          People

            bingjie.miao Bingjie Miao
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty