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

non-covered NEST/INDEX JOIN gives wrong results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.6.0, 5.0.0
    • 5.0.0
    • query
    • None
    • Untriaged
    • Yes

    Description

      insert into default values("a_12345",{ "_id": "a_12345", "_type": "service" });
      insert into default values("b_12345", { "_id": "b_12345", "parent": "a_12345", "data": { "a": "b", "c": "d" } });
      insert into default values("b_12346", { "_id": "b_12346", "parent": "a_12345", "data": { "6": "3", "d": "f" } });
      create primary index on default;
      CREATE INDEX idx_parent ON default( parent );
      SELECT * FROM default a NEST default b ON KEY b.parent FOR a;
       
      gives no results.  Should return 1 row
      

      Attachments

        Issue Links

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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty