[GitHub] [couchdb] mhsadri007 opened a new issue #3321: keys quey does not work in partitioned DB

[GitBox <gi...@apache.org>]

mhsadri007 opened a new issue #3321:
URL: https://github.com/apache/couchdb/issues/3321


   [NOTE]: # ( ^^ Provide a general summary of the issue in the title above. ^^ )
   
   ## Description
   
   Hi, I'm using CouchDB 3.1.1 to store both partitioned and non-partitioned data in separate databases. When querying a custom view with **key** parameter, CouchDB works perfectly on both databases but when I try to use **keys** instead of **key** to query a reduce view on partitioned database, I get the following response (assuming the special characters in URL are escaped perfectly or a web browser (FF) used to query the DB)
   
   ## Steps to Reproduce
   
   ```
   curl http://admin:PassWord@127.0.0.1:5984/PartitionedDB/_partition/user01/_design/folder_count/_view/folder_count?keys=["0","2"]&group=true
   {"rows":[]}
   ```
   
   ```
   curl http://admin:PassWord@127.0.0.1:5984/PartitionedDB/_partition/user01/_design/folder_count/_view/folder_count?key="0"
   {"rows":[ {"key":null,"value":3} ]}
   ```
   
   While that view is not empty:
   
   ```
   curl http://admin:PassWord@127.0.0.1:5984/PartitionedDB/_partition/user01/_design/folder_count/_view/folder_count?group=true
   {"rows":[
   {"key":"0","value":3},
   {"key":"1","value":12},
   {"key":"2","value":1},
   {"key":"3","value":3},
   {"key":"31","value":1},
   {"key":"311","value":3}
   ]}
   ```
   
   
   ## Expected Behaviour
   
   Should display the result as the multiple keys query parameter does in non-partitioned DB
   
   ## Your Environment
   
   OS: Windows 7 64bit
   CouchDB 3.1.1 
   
   ```
   curl http://127.0.0.1:5984
   {"couchdb":"Welcome","version":"3.1.1","git_sha":"ce596c65d","uuid":"f89258d2cbb860f8181311e52dedc5fd","features":["access-ready","partitioned","pluggable-storage-engines","reshard","scheduler"],"vendor":{"name":"The Apache Software Foundation"}}
   ```
   
   * CouchDB version used: 3.1.1
   * Browser name and version: Firefox 81.0 64-bit
   * Operating system and version: Windows 7 64-bit
   
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org