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

UNNEST using Array index wrongly using covering index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.3, 5.0.0
    • 4.6.2, 4.6.3, 5.0.0
    • query
    • None
    • Triaged
    • Unknown

    Description

       
      INSERT INTO default VALUES("k200",{"messages":[{"seqno":100,"id":"abc"}]});
      CREATE INDEX ix200 ON default(ALL ARRAY v.seqno FOR v IN messages END);
       
      SELECT v.seqno FROM default UNNEST default.messages AS v WHERE v.id = "abc" AND v.seqno > 1;
      -- Above query returns 0 results instead of 1 and uses ix200 and should n't be using cover fetch the data.
       
      
      

      Attachments

        Issue Links

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

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty