total_rows does not match actual results


#1

I have a view that is returning a array as the key, however when I query this view the total_rows returned does not match the actual result values:

E.g.
Query:

/default/_design/groups/_view/memberPath?&startkey=%5B"79025604-489b-4acf-80e6-357038c9575d"%2C"41246761-dc46-400d-a889-86d8b89e5d40"%5D&endkey=%5B"79025604-489b-4acf-80e6-357038c9575d"%2C"41246761-dc46-400d-a889-86d8b89e5d40"%5D&inclusive_end=true&stale=false&connection_timeout=60000&limit=1000

Response:

{"total_rows":200,"rows":[
{"id":"41246761-dc46-400d-a889-86d8b89e5d40","key":["79025604-489b-4acf-80e6-357038c9575d","41246761-dc46-400d-a889-86d8b89e5d40"],"value":null}
]
}

Using the java sdk I get the same result (calling totalRows() returns 200).
200 is the number of documents in the bucket, the actual result data is correct, i.e. 1 match.

Any thoughts on what is going on here?

Version 3.0.0 Enterprise Edition (build-1209)
SDK 2.0.0


#2

total_rows does not mean how many rows in the result. It means

  • total_rows
    A count of the number of rows of information within the stored View. This shows the number of rows in the full View index, not the number of rows in the returned data set.

http://docs.couchbase.com/admin/admin/REST/rest-views-get.html