Return-Path: Delivered-To: apmail-couchdb-dev-archive@www.apache.org Received: (qmail 18304 invoked from network); 27 Oct 2010 10:11:52 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 27 Oct 2010 10:11:52 -0000 Received: (qmail 69776 invoked by uid 500); 27 Oct 2010 10:11:52 -0000 Delivered-To: apmail-couchdb-dev-archive@couchdb.apache.org Received: (qmail 69683 invoked by uid 500); 27 Oct 2010 10:11:51 -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 69674 invoked by uid 99); 27 Oct 2010 10:11:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Oct 2010 10:11:50 +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; Wed, 27 Oct 2010 10:11:48 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o9RABQkR008655 for ; Wed, 27 Oct 2010 10:11:26 GMT Message-ID: <26718051.97261288174286320.JavaMail.jira@thor> Date: Wed, 27 Oct 2010 06:11:26 -0400 (EDT) From: "Yurgen Ude (JIRA)" To: dev@couchdb.apache.org Subject: [jira] Updated: (COUCHDB-927) Problem with item list starting with startkey (result in broken paginating) In-Reply-To: <15622110.96561288171761032.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-927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yurgen Ude updated COUCHDB-927: ------------------------------- Description: Problem with item list starting with startkey like: /_design/user/_view/by_msisdn?limit=21&startkey=1234987650 for view: function(doc) { if (doc.type == 'user' && doc.status != 'DELETED') { emit(doc.msisdn, doc.username); } } returns wrong data (expected started item goes on 20th place; key "1234987650" is unique): {"total_rows":313,"offset":176,"rows":[ {"id":"06382895fa04ebc1618bbf262723e264","key":2222244444.0,"value":"222224"}, {"id":"05c9f0b2e72d0fd6ecc0723cef7edcc6","key":"0011223344","value":"0011223344@example.com"}, {"id":"7aecd68c97189e19834f0f2686db22f1","key":"0123498765","value":null}, {"id":"51be2572858a1dbb030afe81de3f57cc","key":"0561278349","value":null}, {"id":"13af15d83d9bc51d27c5850086d08262","key":"1","value":null}, {"id":"35157fdf1dd0b7d63e0f73d7667b04d4","key":"1010101010","value":null}, {"id":"bbcf936f323981a6b0e31b8548825ae4","key":"1111111111","value":null}, {"id":"06382895fa04ebc1618bbf262745b6b0","key":"111222","value":"1@test.com"}, {"id":"06382895fa04ebc1618bbf26273ae339","key":"115599","value":"115599"}, {"id":"06382895fa04ebc1618bbf26273afd2d","key":"115599","value":"115599"}, {"id":"06382895fa04ebc1618bbf262737707b","key":"123123","value":"123123"}, {"id":"5c1381758c7312744e151616e8713bc9","key":"12321","value":null}, {"id":"a5335d12ded0cafa8c79d57e5f7a3fc4","key":"1233333333","value":null}, {"id":"c69915beeddfd7da574e9664e8cbe4a3","key":"1234321234","value":null}, {"id":"451b103e577d917bd7898c1635aea383","key":"1234444444","value":null}, {"id":"06382895fa04ebc1618bbf262724a848","key":"123456789","value":"1243583343"}, {"id":"84ca288485191c0cc91086a44eda284d","key":"1234567894","value":null}, {"id":"b2f531889f23bf9be83fa96578d5cbe4","key":"1234777777","value":null}, {"id":"c29945eae127f3edb797bb641810433b","key":"1234987605","value":null}, {"id":"b3032d33041f9c8eb8a726f2defa1321","key":"1234987650","value":null}, {"id":"ed3f4e78c624edcabca52d70219b1959","key":"1234987656","value":null} ]} was: Problem with item list starting with startkey like: /_design/user/_view/by_msisdn?limit=21&startkey=1234987650 for view: function(doc) { if (doc.type == 'user' && doc.status != 'DELETED') { emit(doc.msisdn, doc.username); } } returns wrong data (expected started item goes on 20th place; key "1234987650" is unique): {"total_rows":313,"offset":176,"rows":[ {"id":"06382895fa04ebc1618bbf262723e264","key":2222244444.0,"value":"222224"}, {"id":"05c9f0b2e72d0fd6ecc0723cef7edcc6","key":"0011223344","value":"0011223344@example.com"}, {"id":"7aecd68c97189e19834f0f2686db22f1","key":"0123498765","value":null}, {"id":"51be2572858a1dbb030afe81de3f57cc","key":"0561278349","value":null}, {"id":"13af15d83d9bc51d27c5850086d08262","key":"1","value":null}, {"id":"35157fdf1dd0b7d63e0f73d7667b04d4","key":"1010101010","value":null}, {"id":"bbcf936f323981a6b0e31b8548825ae4","key":"1111111111","value":null}, {"id":"06382895fa04ebc1618bbf262745b6b0","key":"111222","value":"eugene.rastorguev@oxagile.com"}, {"id":"06382895fa04ebc1618bbf26273ae339","key":"115599","value":"115599"}, {"id":"06382895fa04ebc1618bbf26273afd2d","key":"115599","value":"115599"}, {"id":"06382895fa04ebc1618bbf262737707b","key":"123123","value":"123123"}, {"id":"5c1381758c7312744e151616e8713bc9","key":"12321","value":null}, {"id":"a5335d12ded0cafa8c79d57e5f7a3fc4","key":"1233333333","value":null}, {"id":"c69915beeddfd7da574e9664e8cbe4a3","key":"1234321234","value":null}, {"id":"451b103e577d917bd7898c1635aea383","key":"1234444444","value":null}, {"id":"06382895fa04ebc1618bbf262724a848","key":"123456789","value":"1243583343"}, {"id":"84ca288485191c0cc91086a44eda284d","key":"1234567894","value":null}, {"id":"b2f531889f23bf9be83fa96578d5cbe4","key":"1234777777","value":null}, {"id":"c29945eae127f3edb797bb641810433b","key":"1234987605","value":null}, {"id":"b3032d33041f9c8eb8a726f2defa1321","key":"1234987650","value":null}, {"id":"ed3f4e78c624edcabca52d70219b1959","key":"1234987656","value":null} ]} > Problem with item list starting with startkey (result in broken paginating) > --------------------------------------------------------------------------- > > Key: COUCHDB-927 > URL: https://issues.apache.org/jira/browse/COUCHDB-927 > Project: CouchDB > Issue Type: Bug > Affects Versions: 0.11 > Reporter: Yurgen Ude > > Problem with item list starting with startkey like: > /_design/user/_view/by_msisdn?limit=21&startkey=1234987650 > for view: > function(doc) { > if (doc.type == 'user' && doc.status != 'DELETED') { > emit(doc.msisdn, doc.username); > } > } > returns wrong data (expected started item goes on 20th place; key "1234987650" is unique): > {"total_rows":313,"offset":176,"rows":[ > {"id":"06382895fa04ebc1618bbf262723e264","key":2222244444.0,"value":"222224"}, > {"id":"05c9f0b2e72d0fd6ecc0723cef7edcc6","key":"0011223344","value":"0011223344@example.com"}, > {"id":"7aecd68c97189e19834f0f2686db22f1","key":"0123498765","value":null}, > {"id":"51be2572858a1dbb030afe81de3f57cc","key":"0561278349","value":null}, > {"id":"13af15d83d9bc51d27c5850086d08262","key":"1","value":null}, > {"id":"35157fdf1dd0b7d63e0f73d7667b04d4","key":"1010101010","value":null}, > {"id":"bbcf936f323981a6b0e31b8548825ae4","key":"1111111111","value":null}, > {"id":"06382895fa04ebc1618bbf262745b6b0","key":"111222","value":"1@test.com"}, > {"id":"06382895fa04ebc1618bbf26273ae339","key":"115599","value":"115599"}, > {"id":"06382895fa04ebc1618bbf26273afd2d","key":"115599","value":"115599"}, > {"id":"06382895fa04ebc1618bbf262737707b","key":"123123","value":"123123"}, > {"id":"5c1381758c7312744e151616e8713bc9","key":"12321","value":null}, > {"id":"a5335d12ded0cafa8c79d57e5f7a3fc4","key":"1233333333","value":null}, > {"id":"c69915beeddfd7da574e9664e8cbe4a3","key":"1234321234","value":null}, > {"id":"451b103e577d917bd7898c1635aea383","key":"1234444444","value":null}, > {"id":"06382895fa04ebc1618bbf262724a848","key":"123456789","value":"1243583343"}, > {"id":"84ca288485191c0cc91086a44eda284d","key":"1234567894","value":null}, > {"id":"b2f531889f23bf9be83fa96578d5cbe4","key":"1234777777","value":null}, > {"id":"c29945eae127f3edb797bb641810433b","key":"1234987605","value":null}, > {"id":"b3032d33041f9c8eb8a726f2defa1321","key":"1234987650","value":null}, > {"id":"ed3f4e78c624edcabca52d70219b1959","key":"1234987656","value":null} > ]} > -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.