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

Query returns wrong results in partition index and order by

    XMLWordPrintable

Details

    • 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

          backports to

          Bug - A problem which impairs or prevents the functions of the product. MB-34387 [BP MB-34157] - Query returns wrong results in partition index and order by

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-34426 [BP MB-34157] - Query returns wrong results in partition index and order by

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-34136 Query returns wrong results in partition index and order by

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              deepkaran.salooja Deepkaran Salooja
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty