From dev-return-12018-apmail-couchdb-dev-archive=couchdb.apache.org@couchdb.apache.org Thu Sep 30 18:04:55 2010 Return-Path: Delivered-To: apmail-couchdb-dev-archive@www.apache.org Received: (qmail 24528 invoked from network); 30 Sep 2010 18:04:55 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 30 Sep 2010 18:04:55 -0000 Received: (qmail 32215 invoked by uid 500); 30 Sep 2010 18:04:54 -0000 Delivered-To: apmail-couchdb-dev-archive@couchdb.apache.org Received: (qmail 32146 invoked by uid 500); 30 Sep 2010 18:04:54 -0000 Mailing-List: contact dev-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@couchdb.apache.org Delivered-To: mailing list dev@couchdb.apache.org Received: (qmail 32136 invoked by uid 99); 30 Sep 2010 18:04:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Sep 2010 18:04:53 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Sep 2010 18:04:53 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o8UI4XbW000504 for ; Thu, 30 Sep 2010 18:04:33 GMT Message-ID: <10133547.481611285869873145.JavaMail.jira@thor> Date: Thu, 30 Sep 2010 14:04:33 -0400 (EDT) From: "John Le Drew (JIRA)" To: dev@couchdb.apache.org Subject: [jira] Updated: (COUCHDB-899) Array fields being returned empty in permanent views, but work fine as temporary views. In-Reply-To: <9367269.453751285715136863.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/COUCHDB-899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Le Drew updated COUCHDB-899: --------------------------------- Same db replicated to my cloudant account does not show this issue. > Array fields being returned empty in permanent views, but work fine as temporary views. > --------------------------------------------------------------------------------------- > > Key: COUCHDB-899 > URL: https://issues.apache.org/jira/browse/COUCHDB-899 > Project: CouchDB > Issue Type: Bug > Components: JavaScript View Server > Affects Versions: 1.0.1 > Environment: CouchDB 1.0.1 running on Ubuntu 10.10 beta - this is the contents of my local.ini (comments removed) > [couchdb] > delayed_commits = false > [httpd] > port = 80 > bind_address = 0.0.0.0 > WWW-Authenticate = Basic realm="administrator" > [couch_httpd_auth] > require_valid_user = true > [log] > level = debug > Reporter: John Le Drew > > I am creating an accounting app; the transactions are stored using the following doc: > { > "_id": "405b791b64424d12e03c12e6e5001535", > "_rev": "1-97d53ba31a6ebb8c0508d0fc8776fac5", > "type": "transaction", > "account": "account_id", > "payee": "Gas Company", > "description": "May Bill", > "date": "2009/05/25", > "status": "cleared", > "category": "Bills / Gas", > "value": -5000 > } > Or they can be split acroll multiple accounts / categories / etc. In this case split over two categories: > { > "_id": "405b791b64424d12e03c12e6e5002532", > "_rev": "1-da46384d5f9fbfd26acbf8fc9a8e82fe", > "type": "transaction", > "account": "account_id", > "payee": "Credit Card Company", > "description": "May Statement", > "date": "2009/06/02", > "status": "uncleared", > "category": "Debt / Credit Card Payments", > "value": -5000, > "split": [ > { > "category": "Dept / Default Charges", > "value": -1000 > } > ] > } > I have made a view to display all the unique categories in use across all transactions. > // MAP > function(doc) { > if (doc.type && doc.type == 'transaction') { > if (doc.category) emit(doc.category); > if (doc.split) doc.split.map(function(spl) { > if (spl.category) emit(spl.category); > }); > } > } > // REDUCE > function(keys, values, rereduce) { > return true; > } > // CURRENT OUTPUT OF VIEW (with group=true) > { > "rows": [ > { > "key": "Debt / Credit Card Payments", > "value": true > }, > { > "key": "Bills / Gas", > "value": true > } > ] > } > // CURRENT OUTPUT OF VIEW WHEN RUN AS A TEMPORARY VIEW (with group=true) > { > "rows": [ > { > "key": "Dept / Default Charges", > "value": true > }, > { > "key": "Debt / Credit Card Payments", > "value": true > }, > { > "key": "Bills / Gas", > "value": true > } > ] > } > SIMPLE TEST VIEW > function(doc) { > if (doc.split) emit(null,doc.split); > } > OUTPUT OF TEMP VIEW > { > "total_rows": 1, > "offset": 0, > "rows": [ > { > "id": "405b791b64424d12e03c12e6e5002532", > "key": null, > "value": [ > { > "category": "Dept / Default Charges", > "value": -1000 > } > ] > } > ] > } > OUTPUT OF SAME VIEW AFTER SAVE > { > "total_rows": 1, > "offset": 0, > "rows": [ > { > "id": "405b791b64424d12e03c12e6e5002532", > "key": null, > "value": [ > ] > } > ] > } > It seems from the above that couch is for some reason returning the array as empty. > Thanks for your time on IRC already. > Cheers > John -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.