Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 4006 invoked from network); 30 Apr 2009 15:33:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 30 Apr 2009 15:33:56 -0000 Received: (qmail 60592 invoked by uid 500); 30 Apr 2009 15:32:42 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 53075 invoked by uid 500); 30 Apr 2009 15:32:07 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 51069 invoked by uid 99); 30 Apr 2009 15:19:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2009 15:19:32 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kaczmarek.w@gmail.com designates 209.85.218.170 as permitted sender) Received: from [209.85.218.170] (HELO mail-bw0-f170.google.com) (209.85.218.170) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2009 15:19:24 +0000 Received: by bwz18 with SMTP id 18so2084304bwz.11 for ; Thu, 30 Apr 2009 08:19:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=iy/PWpg0JSgAQzh2zTVR8QXrsMyXgAgFWC/D12Q6jro=; b=hnKm3dKm3z+qWd5KuTa4TFA3h5MxWQf7QUczcwsEViUlPkViWyckgfqq3w0P/8Eu6M 98XBoLsmi1iRUZ2ZlmjMN54rruJFB1Kj7nO39nI+LpWJyUjoYnBCXvOpoa3CR9plqFcH jy6vuP8Ztq/k8S2sEWLhONAFB7mWBmmsaGxg0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=hiyD0qcmZql+x34TMJw2WLgpSxfId+Rnki5KEZKQjKuehFMzv+MoJF3hT8QECmBChy SeJhqh+xnIavpdbTkPYMCu/ivxceoPljG3q+ljDHmRWMc5agQwhZRSN1ioouPOGuN8Xy Pv3dz1RHRjRFIhHADMgFUDA97KJldyx9pygIg= MIME-Version: 1.0 Received: by 10.223.111.211 with SMTP id t19mr786664fap.64.1241104743606; Thu, 30 Apr 2009 08:19:03 -0700 (PDT) In-Reply-To: <20090430145634.GA21776@uk.tiscali.com> References: <20090430132317.GA17764@uk.tiscali.com> <20090430145634.GA21776@uk.tiscali.com> Date: Thu, 30 Apr 2009 17:19:03 +0200 Message-ID: <31ae10910904300819v3de1e0c5ge2e9b9aedb24f9dd@mail.gmail.com> Subject: Re: The need for a key prefix view parameter From: Wojciech Kaczmarek To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Thu, Apr 30, 2009 at 16:56, Brian Candler wrote: > On Thu, Apr 30, 2009 at 02:23:17PM +0100, Brian Candler wrote: >> (5) Strangely, doc id keys in _all_docs appear to behave differently; >> perhaps they are ASCII-compared rather than UCA compared. See script 3 >> below. > > And this has just had me tearing my hair out for the last half hour: a > search for > > =A0 =A0_all_docs?startkey=3D"_design/"&endkey=3D"_design/ZZZZ" > > did not match some of my documents, e.g. _design/c000. Now I realise that > almost certainly this is because Z comes before c in ASCII collation. > > Is this intentional behaviour? If so I will change the Wiki so it recomme= nds > > =A0 =A0_all_docs?startkey=3D"_design/"&endkey=3D"_design/~" Isn't it better to use "\u9999" as the ending marker?