Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-8378

Primary index doesn't include transactional documents

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • Major
    • Cheshire-Cat
    • Cheshire-Cat
    • gsi
    • DOC-2021-Jul04-S13
    • 1

    Description

      In 7.0.0 Primary index will not index the transactional documents.

      From Jeelan Poola (begin with a meta.id "_txn:" && binary && have-xattrs)

      This need to be documented: This also means some change in behavior to queries and UI.

      SELECT COUN(*) FROM collection;
      SELECT COUN(1) FROM collection;
      

      Above queries uses collection stats i.e include all the documents in the bucket those include transactional documents.

      If done Index scan on collection using primary index count might be differ.
      IndexScan on primary scan doesn't include keys of the transactional document in the collection.

      UI:

      If there is no primary index on collection UI shows all documents including transactional documents.
      Once primary index present on the collection it uses primary scan. This will skip transactional documents.

      Attachments

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

        Activity

          People

            simon.dew Simon Dew
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty