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
 gcdcu-couchdb-user@m.gmane.org designates 80.91.229.3 as permitted sender)
To: user@couchdb.apache.org
From: Luca Morandini <lmorandini@ieee.org>
Subject: Fixed precision of floating point  number not respected in views
Date: Tue, 19 Feb 2013 19:05:37 +1100
Lines: 57
Message-ID: <kfvbob$c6p$1@ger.gmane.org>
Reply-To: lmorandini@ieee.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/17.0 Thunderbird/17.0

Folks,

I have stored fixed precision numbers in a database, but when they are spit out by 
a view, the precision is full, and -which is worse- the trailing decimal digits 
are not all zeroes.

In other words:

Data in the database (as I loaded them as they do appear in Futon):
{
    "_id": "4864f365b6962af5a9c4064b34001722",
    "_rev": "1-73d234f7ed07b0fc9d4671a9f8ef9b91",
    "type": "Feature",
    "properties": {
        "poll_id": 2734,
        "dataset": "pbc",
        "ced": null
    },
    "bbox": [
        151.17281,
        -33.91018,
        151.18159,
        -33.90162
    ]
...

Output of the view:
{
   "_id": "4864f365b6962af5a9c4064b34001722",
   "_rev": "1-73d234f7ed07b0fc9d4671a9f8ef9b91",
   "type": "Feature",
   "properties": {
         "poll_id": 2734,
         "dataset": "pbc",
         "ced":null
   },
   "bbox": [
      151.17280999999999835,
      -33.91017999999999688,
      151.18158999999999992,
      -33.901620000000001198
   ]
...

Of course, in the view I do not alter the doc (moreover, the same output of the 
view is replicated when I directly request a document via the Document API).

Am I doing something silly ?

Regards,

Luca Morandini
Data Architect - AURIN project
Department of Computing and Information Systems
University of Melbourne
Tel. +61 03 903 58 380
Skype: lmorandini