Details
-
Task
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
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.