Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of paul.p.carey@gmail.com
 designates 66.249.92.168 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=V0o0t4xoAmXyNkvYLrhVLYvaLnWt9G28JvdOjcR244LBg4Bp17lEMiMl0vQLHgy1oE
         F+La6PPEgUdYCqJKxMA/Tqv+dqeiSHF3u8GJGsH0iUTpeShLkeMubjD9KbxK4ixWcfex
         QEefN5rfkbkS0kpq+hsORrC1ndBMkNkaR4Fmo=
Message-ID: <13ae4dd50812121319l71a1e9ecva1e0da997ecaa96a@mail.gmail.com>
Date: Fri, 12 Dec 2008 21:19:14 +0000
From: "Paul Carey" <paul.p.carey@gmail.com>
To: user@couchdb.apache.org
Subject: Re: Array key queries
In-Reply-To: <e2111bbb0812121313n5bcc633l8e6b78c207626a6c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <13ae4dd50812121259r492a925dkf7ee9fe8388a0868@mail.gmail.com>
	 <CC49A7EA-6C1B-487D-A36E-FE073C344AFE@gmail.com>
	 <e2111bbb0812121313n5bcc633l8e6b78c207626a6c@mail.gmail.com>

Adam, Paul

Thanks for the quick replies, very helpful.

Paul

On Fri, Dec 12, 2008 at 9:13 PM, Paul Davis <paul.joseph.davis@gmail.com> wrote:
> On Fri, Dec 12, 2008 at 4:09 PM, Adam Kocoloski
> <adam.kocoloski@gmail.com> wrote:
>> Hi Paul, yes it is.  The startkey/endkey filtering can only select a
>> continuous range in the keyspace, and the keys are sorted by the first
>> element in the array (first).  If you happened to have row in that view with
>> a key [{}, 1], your second query would have suppressed it.
>>
>> I realize that filtering on an arbitrary position in the array would be
>> sweet, but it would be quite a lot more work for the server.  I'm not a
>> member of the development team, but I'll bet that kind of functionality will
>> only appear if CouchDB's flavor of MapReduce grows support for a remap
>> phase.  Best,
>>
>
> On a side note, one of my github branches is a custom sort order patch
> for views that allows for declaring ascending or descending sort order
> for each position in an array key.
>
>> Adam
>>
>> On Dec 12, 2008, at 3:59 PM, Paul Carey wrote:
>>
>>> Querying with an array based key produces inconsistent results across
>>> different key indexes.
>>>
>>> For example, consider a view that emits the following keys
>>>
>>> [0, 0]
>>> [0, 1]
>>> [1, 0]
>>> [1, 1]
>>>
>>> Querying with startkey=[0, null] and endkey=[0, {}] returns
>>>
>>> [0, 0]
>>> [0, 1]
>>>
>>> However, querying with startkey=[null, 0] and endkey=[{}, 0] does not
>>> return
>>>
>>> [0, 0]
>>> [1, 0]
>>>
>>> Instead, all rows are returned.
>>>
>>> Is this the expected behaviour?
>>>
>>> Thanks
>>> Paul
>>
>>
>