You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@couchdb.apache.org by "Tony Sun (JIRA)" <ji...@apache.org> on 2015/11/11 20:45:10 UTC
[jira] [Commented] (COUCHDB-2875) Descending=true produces random
sort order for multi-key emit
[ https://issues.apache.org/jira/browse/COUCHDB-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15000965#comment-15000965 ]
Tony Sun commented on COUCHDB-2875:
-----------------------------------
While investigating multi_key_design.js, I noticed that our descending=true was not returning a correctly sorted set of rows when we POST a key value.
Design Doc:
{code: javascript}
{
_id:"_design/test",
language: "javascript",
views: {
all_docs: {
map: "function(doc) { emit(doc.integer, doc.string) }"
},
multi_emit: {
map: "function(doc) {for(var i = 0 ; i < 3 ; i++) { emit(i, doc.integer) ; } }"
},
summate: {
map:"function (doc) {emit(doc.integer, doc.integer)};",
reduce:"function (keys, values) { return sum(values); };"
}
}
}
{code}
CURL POST:
http://localhost:15984/test_suite_db_nnzvwtgj/_design/test/_view/multi_emit?descending=true
{code:javascript}
{"keys":[1]}
{code}
Results:
{code:javascript}
{"total_rows":300,"offset":100,"rows":[
{"id":"10","key":1,"value":10},
{"id":"12","key":1,"value":12},
{"id":"13","key":1,"value":13},
{"id":"14","key":1,"value":14},
{"id":"16","key":1,"value":16},
{"id":"17","key":1,"value":17},
{"id":"18","key":1,"value":18},
{"id":"41","key":1,"value":41},
{"id":"42","key":1,"value":42},
{"id":"43","key":1,"value":43},
{"id":"45","key":1,"value":45},
{"id":"46","key":1,"value":46},
{"id":"47","key":1,"value":47},
{"id":"49","key":1,"value":49},
{"id":"51","key":1,"value":51},
{"id":"52","key":1,"value":52},
{"id":"53","key":1,"value":53},
{"id":"55","key":1,"value":55},
{"id":"56","key":1,"value":56},
{"id":"57","key":1,"value":57},
{"id":"58","key":1,"value":58},
{"id":"54","key":1,"value":54},
{"id":"50","key":1,"value":50},
{"id":"48","key":1,"value":48},
{"id":"44","key":1,"value":44},
{"id":"40","key":1,"value":40},
{"id":"19","key":1,"value":19},
{"id":"15","key":1,"value":15},
{"id":"11","key":1,"value":11},
{"id":"59","key":1,"value":59},
{"id":"62","key":1,"value":62},
{"id":"64","key":1,"value":64},
{"id":"65","key":1,"value":65},
{"id":"66","key":1,"value":66},
{"id":"67","key":1,"value":67},
{"id":"68","key":1,"value":68},
{"id":"69","key":1,"value":69},
{"id":"7","key":1,"value":7},
{"id":"70","key":1,"value":70},
{"id":"71","key":1,"value":71},
{"id":"72","key":1,"value":72},
{"id":"73","key":1,"value":73},
{"id":"74","key":1,"value":74},
{"id":"75","key":1,"value":75},
{"id":"76","key":1,"value":76},
{"id":"77","key":1,"value":77},
{"id":"78","key":1,"value":78},
{"id":"79","key":1,"value":79},
{"id":"8","key":1,"value":8},
{"id":"80","key":1,"value":80},
{"id":"81","key":1,"value":81},
{"id":"82","key":1,"value":82},
{"id":"83","key":1,"value":83},
{"id":"84","key":1,"value":84},
{"id":"85","key":1,"value":85},
{"id":"86","key":1,"value":86},
{"id":"87","key":1,"value":87},
{"id":"88","key":1,"value":88},
{"id":"89","key":1,"value":89},
{"id":"9","key":1,"value":9},
{"id":"90","key":1,"value":90},
{"id":"91","key":1,"value":91},
{"id":"92","key":1,"value":92},
{"id":"93","key":1,"value":93},
{"id":"94","key":1,"value":94},
{"id":"95","key":1,"value":95},
{"id":"96","key":1,"value":96},
{"id":"33","key":1,"value":33},
{"id":"36","key":1,"value":36},
{"id":"37","key":1,"value":37},
{"id":"39","key":1,"value":39},
{"id":"4","key":1,"value":4},
{"id":"6","key":1,"value":6},
{"id":"60","key":1,"value":60},
{"id":"61","key":1,"value":61},
{"id":"5","key":1,"value":5},
{"id":"38","key":1,"value":38},
{"id":"34","key":1,"value":34},
{"id":"25","key":1,"value":25},
{"id":"27","key":1,"value":27},
{"id":"29","key":1,"value":29},
{"id":"3","key":1,"value":3},
{"id":"30","key":1,"value":30},
{"id":"28","key":1,"value":28},
{"id":"24","key":1,"value":24},
{"id":"0","key":1,"value":0},
{"id":"2","key":1,"value":2},
{"id":"20","key":1,"value":20},
{"id":"1","key":1,"value":1},
{"id":"21","key":1,"value":21},
{"id":"22","key":1,"value":22},
{"id":"23","key":1,"value":23},
{"id":"26","key":1,"value":26},
{"id":"31","key":1,"value":31},
{"id":"32","key":1,"value":32},
{"id":"35","key":1,"value":35},
{"id":"63","key":1,"value":63},
{"id":"97","key":1,"value":97},
{"id":"98","key":1,"value":98},
{"id":"99","key":1,"value":99}
]}
{code}
Without a key POST:
{code:javascript}
{"total_rows":300,"offset":0,"rows":[
{"id":"99","key":2,"value":99},
{"id":"98","key":2,"value":98},
{"id":"97","key":2,"value":97},
{"id":"96","key":2,"value":96},
{"id":"95","key":2,"value":95},
{"id":"94","key":2,"value":94},
{"id":"93","key":2,"value":93},
{"id":"92","key":2,"value":92},
{"id":"91","key":2,"value":91},
{"id":"90","key":2,"value":90},
{"id":"9","key":2,"value":9},
{"id":"89","key":2,"value":89},
{"id":"88","key":2,"value":88},
{"id":"87","key":2,"value":87},
{"id":"86","key":2,"value":86},
{"id":"85","key":2,"value":85},
{"id":"84","key":2,"value":84},
{"id":"83","key":2,"value":83},
{"id":"82","key":2,"value":82},
{"id":"81","key":2,"value":81},
{"id":"80","key":2,"value":80},
{"id":"8","key":2,"value":8},
{"id":"79","key":2,"value":79},
{"id":"78","key":2,"value":78},
{"id":"77","key":2,"value":77},
{"id":"76","key":2,"value":76},
{"id":"75","key":2,"value":75},
{"id":"74","key":2,"value":74},
{"id":"73","key":2,"value":73},
{"id":"72","key":2,"value":72},
{"id":"71","key":2,"value":71},
{"id":"70","key":2,"value":70},
{"id":"7","key":2,"value":7},
{"id":"69","key":2,"value":69},
{"id":"68","key":2,"value":68},
{"id":"67","key":2,"value":67},
{"id":"66","key":2,"value":66},
{"id":"65","key":2,"value":65},
{"id":"64","key":2,"value":64},
{"id":"63","key":2,"value":63},
{"id":"62","key":2,"value":62},
{"id":"61","key":2,"value":61},
{"id":"60","key":2,"value":60},
{"id":"6","key":2,"value":6},
{"id":"59","key":2,"value":59},
{"id":"58","key":2,"value":58},
{"id":"57","key":2,"value":57},
{"id":"56","key":2,"value":56},
{"id":"55","key":2,"value":55},
{"id":"54","key":2,"value":54},
{"id":"53","key":2,"value":53},
{"id":"52","key":2,"value":52},
{"id":"51","key":2,"value":51},
{"id":"50","key":2,"value":50},
{"id":"5","key":2,"value":5},
{"id":"49","key":2,"value":49},
{"id":"48","key":2,"value":48},
{"id":"47","key":2,"value":47},
{"id":"46","key":2,"value":46},
{"id":"45","key":2,"value":45},
{"id":"44","key":2,"value":44},
{"id":"43","key":2,"value":43},
{"id":"42","key":2,"value":42},
{"id":"41","key":2,"value":41},
{"id":"40","key":2,"value":40},
{"id":"4","key":2,"value":4},
{"id":"39","key":2,"value":39},
{"id":"38","key":2,"value":38},
{"id":"37","key":2,"value":37},
{"id":"36","key":2,"value":36},
{"id":"35","key":2,"value":35},
{"id":"34","key":2,"value":34},
{"id":"33","key":2,"value":33},
{"id":"32","key":2,"value":32},
{"id":"31","key":2,"value":31},
{"id":"30","key":2,"value":30},
{"id":"3","key":2,"value":3},
{"id":"29","key":2,"value":29},
{"id":"28","key":2,"value":28},
{"id":"27","key":2,"value":27},
{"id":"26","key":2,"value":26},
{"id":"25","key":2,"value":25},
{"id":"24","key":2,"value":24},
{"id":"23","key":2,"value":23},
{"id":"22","key":2,"value":22},
{"id":"21","key":2,"value":21},
{"id":"20","key":2,"value":20},
{"id":"2","key":2,"value":2},
{"id":"19","key":2,"value":19},
{"id":"18","key":2,"value":18},
{"id":"17","key":2,"value":17},
{"id":"16","key":2,"value":16},
{"id":"15","key":2,"value":15},
{"id":"14","key":2,"value":14},
{"id":"13","key":2,"value":13},
{"id":"12","key":2,"value":12},
{"id":"11","key":2,"value":11},
{"id":"10","key":2,"value":10},
{"id":"1","key":2,"value":1},
{"id":"0","key":2,"value":0},
{"id":"99","key":1,"value":99},
{"id":"98","key":1,"value":98},
{"id":"97","key":1,"value":97},
{"id":"96","key":1,"value":96},
{"id":"95","key":1,"value":95},
{"id":"94","key":1,"value":94},
{"id":"93","key":1,"value":93},
{"id":"92","key":1,"value":92},
{"id":"91","key":1,"value":91},
{"id":"90","key":1,"value":90},
{"id":"9","key":1,"value":9},
{"id":"89","key":1,"value":89},
{"id":"88","key":1,"value":88},
{"id":"87","key":1,"value":87},
{"id":"86","key":1,"value":86},
{"id":"85","key":1,"value":85},
{"id":"84","key":1,"value":84},
{"id":"83","key":1,"value":83},
{"id":"82","key":1,"value":82},
{"id":"81","key":1,"value":81},
{"id":"80","key":1,"value":80},
{"id":"8","key":1,"value":8},
{"id":"79","key":1,"value":79},
{"id":"78","key":1,"value":78},
{"id":"77","key":1,"value":77},
{"id":"76","key":1,"value":76},
{"id":"75","key":1,"value":75},
{"id":"74","key":1,"value":74},
{"id":"73","key":1,"value":73},
{"id":"72","key":1,"value":72},
{"id":"71","key":1,"value":71},
{"id":"70","key":1,"value":70},
{"id":"7","key":1,"value":7},
{"id":"69","key":1,"value":69},
{"id":"68","key":1,"value":68},
{"id":"67","key":1,"value":67},
{"id":"66","key":1,"value":66},
{"id":"65","key":1,"value":65},
{"id":"64","key":1,"value":64},
{"id":"63","key":1,"value":63},
{"id":"62","key":1,"value":62},
{"id":"61","key":1,"value":61},
{"id":"60","key":1,"value":60},
{"id":"6","key":1,"value":6},
{"id":"59","key":1,"value":59},
{"id":"58","key":1,"value":58},
{"id":"57","key":1,"value":57},
{"id":"56","key":1,"value":56},
{"id":"55","key":1,"value":55},
{"id":"54","key":1,"value":54},
{"id":"53","key":1,"value":53},
{"id":"52","key":1,"value":52},
{"id":"51","key":1,"value":51},
{"id":"50","key":1,"value":50},
{"id":"5","key":1,"value":5},
{"id":"49","key":1,"value":49},
{"id":"48","key":1,"value":48},
{"id":"47","key":1,"value":47},
{"id":"46","key":1,"value":46},
{"id":"45","key":1,"value":45},
{"id":"44","key":1,"value":44},
{"id":"43","key":1,"value":43},
{"id":"42","key":1,"value":42},
{"id":"41","key":1,"value":41},
{"id":"40","key":1,"value":40},
{"id":"4","key":1,"value":4},
{"id":"39","key":1,"value":39},
{"id":"38","key":1,"value":38},
{"id":"37","key":1,"value":37},
{"id":"36","key":1,"value":36},
{"id":"35","key":1,"value":35},
{"id":"34","key":1,"value":34},
{"id":"33","key":1,"value":33},
{"id":"32","key":1,"value":32},
{"id":"31","key":1,"value":31},
{"id":"30","key":1,"value":30},
{"id":"3","key":1,"value":3},
{"id":"29","key":1,"value":29},
{"id":"28","key":1,"value":28},
{"id":"27","key":1,"value":27},
{"id":"26","key":1,"value":26},
{"id":"25","key":1,"value":25},
{"id":"24","key":1,"value":24},
{"id":"23","key":1,"value":23},
{"id":"22","key":1,"value":22},
{"id":"21","key":1,"value":21},
{"id":"20","key":1,"value":20},
{"id":"2","key":1,"value":2},
{"id":"19","key":1,"value":19},
{"id":"18","key":1,"value":18},
{"id":"17","key":1,"value":17},
{"id":"16","key":1,"value":16},
{"id":"15","key":1,"value":15},
{"id":"14","key":1,"value":14},
{"id":"13","key":1,"value":13},
{"id":"12","key":1,"value":12},
{"id":"11","key":1,"value":11},
{"id":"10","key":1,"value":10},
{"id":"1","key":1,"value":1},
{"id":"0","key":1,"value":0},
{"id":"99","key":0,"value":99},
{"id":"98","key":0,"value":98},
{"id":"97","key":0,"value":97},
{"id":"96","key":0,"value":96},
{"id":"95","key":0,"value":95},
{"id":"94","key":0,"value":94},
{"id":"93","key":0,"value":93},
{"id":"92","key":0,"value":92},
{"id":"91","key":0,"value":91},
{"id":"90","key":0,"value":90},
{"id":"9","key":0,"value":9},
{"id":"89","key":0,"value":89},
{"id":"88","key":0,"value":88},
{"id":"87","key":0,"value":87},
{"id":"86","key":0,"value":86},
{"id":"85","key":0,"value":85},
{"id":"84","key":0,"value":84},
{"id":"83","key":0,"value":83},
{"id":"82","key":0,"value":82},
{"id":"81","key":0,"value":81},
{"id":"80","key":0,"value":80},
{"id":"8","key":0,"value":8},
{"id":"79","key":0,"value":79},
{"id":"78","key":0,"value":78},
{"id":"77","key":0,"value":77},
{"id":"76","key":0,"value":76},
{"id":"75","key":0,"value":75},
{"id":"74","key":0,"value":74},
{"id":"73","key":0,"value":73},
{"id":"72","key":0,"value":72},
{"id":"71","key":0,"value":71},
{"id":"70","key":0,"value":70},
{"id":"7","key":0,"value":7},
{"id":"69","key":0,"value":69},
{"id":"68","key":0,"value":68},
{"id":"67","key":0,"value":67},
{"id":"66","key":0,"value":66},
{"id":"65","key":0,"value":65},
{"id":"64","key":0,"value":64},
{"id":"63","key":0,"value":63},
{"id":"62","key":0,"value":62},
{"id":"61","key":0,"value":61},
{"id":"60","key":0,"value":60},
{"id":"6","key":0,"value":6},
{"id":"59","key":0,"value":59},
{"id":"58","key":0,"value":58},
{"id":"57","key":0,"value":57},
{"id":"56","key":0,"value":56},
{"id":"55","key":0,"value":55},
{"id":"54","key":0,"value":54},
{"id":"53","key":0,"value":53},
{"id":"52","key":0,"value":52},
{"id":"51","key":0,"value":51},
{"id":"50","key":0,"value":50},
{"id":"5","key":0,"value":5},
{"id":"49","key":0,"value":49},
{"id":"48","key":0,"value":48},
{"id":"47","key":0,"value":47},
{"id":"46","key":0,"value":46},
{"id":"45","key":0,"value":45},
{"id":"44","key":0,"value":44},
{"id":"43","key":0,"value":43},
{"id":"42","key":0,"value":42},
{"id":"41","key":0,"value":41},
{"id":"40","key":0,"value":40},
{"id":"4","key":0,"value":4},
{"id":"39","key":0,"value":39},
{"id":"38","key":0,"value":38},
{"id":"37","key":0,"value":37},
{"id":"36","key":0,"value":36},
{"id":"35","key":0,"value":35},
{"id":"34","key":0,"value":34},
{"id":"33","key":0,"value":33},
{"id":"32","key":0,"value":32},
{"id":"31","key":0,"value":31},
{"id":"30","key":0,"value":30},
{"id":"3","key":0,"value":3},
{"id":"29","key":0,"value":29},
{"id":"28","key":0,"value":28},
{"id":"27","key":0,"value":27},
{"id":"26","key":0,"value":26},
{"id":"25","key":0,"value":25},
{"id":"24","key":0,"value":24},
{"id":"23","key":0,"value":23},
{"id":"22","key":0,"value":22},
{"id":"21","key":0,"value":21},
{"id":"20","key":0,"value":20},
{"id":"2","key":0,"value":2},
{"id":"19","key":0,"value":19},
{"id":"18","key":0,"value":18},
{"id":"17","key":0,"value":17},
{"id":"16","key":0,"value":16},
{"id":"15","key":0,"value":15},
{"id":"14","key":0,"value":14},
{"id":"13","key":0,"value":13},
{"id":"12","key":0,"value":12},
{"id":"11","key":0,"value":11},
{"id":"10","key":0,"value":10},
{"id":"1","key":0,"value":1},
{"id":"0","key":0,"value":0}
]}
{code}
> Descending=true produces random sort order for multi-key emit
> -------------------------------------------------------------
>
> Key: COUCHDB-2875
> URL: https://issues.apache.org/jira/browse/COUCHDB-2875
> Project: CouchDB
> Issue Type: Bug
> Components: Database Core
> Reporter: Tony Sun
> Priority: Blocker
> Labels: regression
> Fix For: 2.0.0
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)