startkey and endkey don't work with ~ or %7E
--------------------------------------------
Key: COUCHDB-324
URL: https://issues.apache.org/jira/browse/COUCHDB-324
Project: CouchDB
Issue Type: Bug
Environment: svn -r763553
Reporter: Brian Candler
The following range queries don't work as expected
startkey="a"&endkey="a~"
startkey="a"&endkey="a%7E"
(Aside: I was hoping to use "foo" to "foo~" as a reasonably clean way of
querying "any key beginning with foo")
The following testcase shows this for "a~", since query doesn't encode it.
However I wasn't sure how to test for "a%7E" cleanly.
--- /home/brian/svn/couchdb/share/www/script/test/view_collation.js
2009-03-20 12:50:46.000000000 +0000
+++ view_collation.js 2009-04-09 11:23:20.000000000 +0100
@@ -109,4 +109,11 @@
endkey : "b", endkey_docid: "b",
inclusive_end:false}).rows;
T(rows[rows.length-1].key == "aa")
+
+ // startkey and endkey with ~ (currently query doesn't encode this,
+ // but really we should test both a~ and a%7E)
+ var rows = db.query(queryFun, null, {startkey: "a", endkey: "a~"}).rows;
+ T(rows.length == 3); // a, A, aa
+ var rows = db.query(queryFun, null, {startkey: "a~", endkey: "b"}).rows;
+ T(rows.length == 1 && rows[0].key == "b");
};
Here are the actual results obtained using curl:
$ curl -X POST -d '{"map":"function(doc) { emit(doc.foo, null); }"}'
'http://127.0.0.1:5984/test_suite_db/_temp_view?startkey="a"&endkey="a~";'
{"total_rows":26,"offset":7,"rows":[
{"id":"7","key":"a","value":null},
{"id":"8","key":"A","value":null}
]}
$ curl -X POST -d '{"map":"function(doc) { emit(doc.foo, null); }"}'
'http://127.0.0.1:5984/test_suite_db/_temp_view?startkey="a"&endkey="a%7E";'
{"total_rows":26,"offset":7,"rows":[
{"id":"7","key":"a","value":null},
{"id":"8","key":"A","value":null}
]}
But what I was expecting was the same as range "a" to "az":
$ curl -X POST -d '{"map":"function(doc) { emit(doc.foo, null); }"}'
'http://127.0.0.1:5984/test_suite_db/_temp_view?startkey="a"&endkey="az";'
{"total_rows":26,"offset":7,"rows":[
{"id":"7","key":"a","value":null},
{"id":"8","key":"A","value":null},
{"id":"9","key":"aa","value":null}
]}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
