incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <paul.joseph.da...@gmail.com>
Subject Re: Views with composite keys inclusive_end not functioning correctly
Date Tue, 28 Sep 2010 01:28:14 GMT
On Mon, Sep 27, 2010 at 8:50 PM, Danny Brain <tehdanish@gmail.com> wrote:
> Hello,
>
> I'm having an issue where views with composite keys are not inclusive of the
> endkey, even with inclusive_end specified as true.
> This is preventing me from correctly selecting a group of documents as per
> the "Linked documents" section on the Http view API wiki page (
> http://wiki.apache.org/couchdb/Introduction_to_CouchDB_views)
>
> I'm running CouchDb 1.0.1. Example of the issue I'm seeing:
>
> composite_key_view?startkey=["AA"]&inclusive_end=true
> {"id":"1","key":["AA",0],"value":null},
> {"id":"1","key":["AA",1],"value":{"_id":"4"}},
> {"id":"2","key":["BB",0],"value":null}
>
> composite_key_view?startkey=["AA"]&endkey=["AA"]&inclusive_end=true
> No results

["AA"] == ["AA"] < ["AA", 0]

>
> composite_key_view?startkey=["AA"]&endkey=["BB"]&inclusive_end=true
> {"id":"1","key":["AA",0],"value":null},
> {"id":"1","key":["AA",1],"value":{"_id":"4"}}
>

["AA"] < ["AA", 0] < ["AA", 1] < ["BB"] < ["BB", 0]

> The last example works, but requires me to know what comes after AA in the
> results, and you'd think inclusive_end would make BB show up as well.
> Has anyone had this problem? Any ideas on how to solve it?
>
> Thanks!
>

In neither example does inclusive_end come into effect.

To get everything with "AA" as the first element of the array key you want:

?startkey=["AA"]&endkey=["AA", {}]

Inclusive end has nothing to do with it.

HTH,
Paul Davis

Mime
View raw message