Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of b.candler@pobox.com designates
 64.74.157.62 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=pobox.com; h=date:from:to:cc
	:subject:message-id:references:mime-version:content-type
	:in-reply-to; q=dns; s=sasl; b=Mr4YwlFbq1dHaICfqO4SZ8nnlmUImESw4
	eBqFrTZebSJy0M87/E9VkL/1uHNjBHkbg3dtx/H9CXp0kSqPso7nm9yeOqe/evD3
	YVGBgW2b++0iB2omnhOWvYJLH+TlYKCci0OszX8BNTqNp9xybwNVZGyPCCOcWrhj
	Y8/jeudl10=
Date: Mon, 9 Nov 2009 09:46:40 +0000
From: Brian Candler <B.Candler@pobox.com>
To: Roger Binns <rogerb@rogerbinns.com>
Cc: user@couchdb.apache.org
Subject: Re: Silent corruption of large numbers
Message-ID: <20091109094640.GA8456@uk.tiscali.com>
Mail-Followup-To: Roger Binns <rogerb@rogerbinns.com>,
 user@couchdb.apache.org
References: <4AF622D5.9070708@rogerbinns.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4AF622D5.9070708@rogerbinns.com>
User-Agent: Mutt/1.5.17+20080114 (2008-01-14)

On Sat, Nov 07, 2009 at 05:45:57PM -0800, Roger Binns wrote:
> As Adam pointed out, the problem is indeed Javascript.  Accessing the
> document directly does give the right answer.
...
> I don't know what the right solution to this is.

One option: store the values as strings. If there is an upper bound then you
can pad them out so they still sort properly. For example, your 64-bit
quantities could be stored as a string of 16 hex digits, left-padded with
zeros.

Another option: use the Erlang view server, and get a big view-building
speed boost for free too. But in that case you must not expose your _design
docs or _temp_view to untrusted clients, since the Erlang view server is not
sandboxed and allows them to run arbitrary code.

Regards,

Brian.