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

[BP MB-34157] - Query returns wrong results in partition index and order by

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 6.0.3
    • 5.5.4, 6.0.0, 6.5.0
    • secondary-index
    • Untriaged
    • Unknown

    Description

      USE 2 indexer nodes
      insert into default values("k01",{"fname":"xyz", "gender":"M", "lname":"abc","company":"pqr"});
      insert into default values("k02",{"fname":"xyz", "gender":"M", "lname":"abc","company":"pqr"});
      CREATE INDEX ix1 ON default (fname, gender, META().id, company, lname) PARTITION BY HASH(META().id);
      SELECT lname FROM default WHERE fname IS VALUED ORDER BY fname, gender, META().id;
       
      laname values returned is META().id
      

      Attachments

        Issue Links

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

          Activity

            People

              prathibha Prathibha Bisarahalli (Inactive)
              jeelan.poola Jeelan Poola
              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