couchdb - 使用 startkey、endkey 和数组键进行搜索

Question

我有一个 View ，它返回多个带有数组键的元素。
示例:

{"total_rows":4,"offset":0,"rows":[
    {"id":"","key":[15,"2"],"value":1,"doc":{},
    {"id":"","key":[20,"2"],"value":1,"doc":{},
    {"id":"","key":[20,"3"],"value":1,"doc":{},
    {"id":"","key":[20,"4"],"value":1,"doc":{}
]}

我正在尝试搜索这些元素。因此，如果我执行以下请求:

/database/_design/element/_view/all/?
  startkey=[15, "2"]&
  endkey=[20, "3"]&
  include_docs=true&reduce=false

实例:http://jchris.couchone.com/keyhuh/_design/Record/_view/by_CreationDate_and_BoreholeName?startkey=[1267686720,%22sp4%22]&endkey=[1267686725,%22sp4\u9999%22]&include_docs=true&reduce=false

这个不行。它返回所有不符合数组第二个元素的记录，甚至是最后一条记录。

奇怪的是，它仅适用于字符串。
示例:

{"total_rows":4,"offset":0,"rows":[
    {"id":"","key":["15","2"],"value":1,"doc":{},
    {"id":"","key":["20","2"],"value":1,"doc":{},
    {"id":"","key":["20","3"],"value":1,"doc":{},
    {"id":"","key":["20","4"],"value":1,"doc":{}
]}

如果我执行以下请求:

/database/_design/element/_view/all/?
  startkey=["15", "2"]&
  endkey=["20", "3"]&
  include_docs=true&
  reduce=false

实例:http://jchris.couchone.com/keyhuh/_design/Record/_view/by_Client_and_BoreholeName?startkey=[%22Test1%22,%22sp4%22]&endkey=[%22Test1%22,%22sp4\u9999%22]&include_docs=true&reduce=false

在这里它会很好地工作，并且只返回前三个元素。

我在 couchdb 搜索带有整数和字符串的数组时遗漏了一些东西吗？还是我遇到了错误？

注意:它与 CouchDB 0.10 和 0.11 的作用相同。

Answer 1

这看起来是错误的，并且可能有一些原因。您可以与我们分享您的代码吗？如果数据不是专有的，您可以将数据库复制到 http://jchris.couchone.com/keyhuh我会看一下那里的全部内容。

...

感谢您发布实时数据。这是被破坏的查询吗？

http://jchris.couchone.com/keyhuh/_design/Record/_view/by_Client_and_BoreholeName?startkey=[%22Test1%22,%22sp4%22]&endkey=[%22Test1%22,%22sp4\u9999%22]&reduce=false

因为这对我来说看起来不错。我错过了什么？