Return-Path: Delivered-To: apmail-couchdb-dev-archive@www.apache.org Received: (qmail 80903 invoked from network); 6 Nov 2010 21:30:16 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 Nov 2010 21:30:16 -0000 Received: (qmail 42260 invoked by uid 500); 6 Nov 2010 21:30:47 -0000 Delivered-To: apmail-couchdb-dev-archive@couchdb.apache.org Received: (qmail 42053 invoked by uid 500); 6 Nov 2010 21:30:47 -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 42044 invoked by uid 99); 6 Nov 2010 21:30:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 06 Nov 2010 21:30:47 +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; Sat, 06 Nov 2010 21:30:44 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id oA6LUMWV025541 for ; Sat, 6 Nov 2010 21:30:23 GMT Message-ID: <9754956.58331289079022667.JavaMail.jira@thor> Date: Sat, 6 Nov 2010 17:30:22 -0400 (EDT) From: "postmaster@blackrock.com (JIRA)" To: dev@couchdb.apache.org Subject: [jira] Commented: (COUCHDB-937) inclusive_end does not work as expected In-Reply-To: <25721146.54641289060283623.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/COUCHDB-937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12929215#action_12929215 ] postmaster@blackrock.com commented on COUCHDB-937: -------------------------------------------------- Please note that the address: dev@couchdb.apache.org will cease working on December 1, 2010. Please update your contact address to the same address @blackrock.com. Thank you. THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY, AND MAY BE PRIVILEGED. If this message was misdirected, BlackRock, Inc. and its subsidiaries, ("BlackRock") does not waive any confidentiality or privilege. If you are not the intended recipient, please notify us immediately and destroy the message without disclosing its contents to anyone. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. The views and opinions expressed in this e-mail message are the author's own and may not reflect the views and opinions of BlackRock, unless the author is authorized by BlackRock to express such views or opinions on its behalf. All email sent to or from this address is subject to electronic storage and review by BlackRock. Although BlackRock operates anti-virus programs, it does not accept responsibility for any damage whatsoever caused by viruses being passed. > inclusive_end does not work as expected > --------------------------------------- > > Key: COUCHDB-937 > URL: https://issues.apache.org/jira/browse/COUCHDB-937 > Project: CouchDB > Issue Type: Bug > Affects Versions: 1.0.1 > Environment: x86 64bit Arch Linux 2.6.35 > Reporter: Robert Newson > > On behalf of Marco Monteiro; > I expected both of the following queries to return the result of the first one. > The difference betwen the two queries is the inclusive_end argument. > ruby-1.9.2-p0 > db.view("calculate/work_duration_by_project_id_and_start_time", :group_level=>2, :startkey => ["0da7979149f2d71f1f5c2361c400c8f2", "2000"], :endkey => ["0da7979149f2d71f1f5c2361c400c8f2", "2011"], :inclusive_end=>true)["rows"].each do |r| puts r end; nil > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2000-03-01 00:00:00"], "value"=>12340} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-19 23:00:00"], "value"=>8400} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-24 23:00:00"], "value"=>12900} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-28 23:00:00"], "value"=>70975} > => nil > ruby-1.9.2-p0 > db.view("calculate/work_duration_by_project_id_and_start_time", :group_level=>2, :startkey => ["0da7979149f2d71f1f5c2361c400c8f2", "2000"], :endkey => ["0da7979149f2d71f1f5c2361c400c8f2", "2011"], :inclusive_end=>false)["rows"].each do |r| puts r end; nil > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2000-03-01 00:00:00"], "value"=>12340} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-19 23:00:00"], "value"=>8400} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-24 23:00:00"], "value"=>12900} > {"key"=>["0da7979149f2d71f1f5c2361c400c8f2", "2010-10-28 23:00:00"], "value"=>70975} > {"key"=>["0da7979149f2d71f1f5c2361c40c11d5", "2010-10-28 23:00:00"], "value"=>7275} > {"key"=>["0da7979149f2d71f1f5c2361c40c6920", "2010-10-28 23:00:00"], "value"=>16975} > {"key"=>["0da7979149f2d71f1f5c2361c40c73ee", "2010-10-28 23:00:00"], "value"=>24100} > {"key"=>["0da7979149f2d71f1f5c2361c40c7ddb", "2010-10-28 23:00:00"], "value"=>7275} > {"key"=>["5465fdb28f9aae885dba76e4860010d4", "2000-03-01 00:00:00"], "value"=>600} > {"key"=>["5465fdb28f9aae885dba76e4860010d4", "2010-10-27 23:00:00"], "value"=>7200} > {"key"=>["5465fdb28f9aae885dba76e486001d07", "2000-03-01 00:00:00"], "value"=>1420} > {"key"=>["5465fdb28f9aae885dba76e4860020b4", "2000-03-01 00:00:00"], "value"=>1420} > {"key"=>["5465fdb28f9aae885dba76e4860021c8", "2000-03-01 00:00:00"], "value"=>600} > => nil > All other agruments being equal, I expect a query with inclusive_end set to true to never return less rows than one with inclusive_end set to false. > Am I missing something? > I have checked the request made by the CouchRest library (this could be a CouchRest bug), and the request url is as expected. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.