You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@couchdb.apache.org by "Paul Joseph Davis (JIRA)" <ji...@apache.org> on 2008/09/23 21:29:44 UTC
[jira] Created: (COUCHDB-124) Adding first and last sort keys
Adding first and last sort keys
-------------------------------
Key: COUCHDB-124
URL: https://issues.apache.org/jira/browse/COUCHDB-124
Project: CouchDB
Issue Type: Improvement
Components: HTTP Interface
Reporter: Paul Joseph Davis
We should add values to the view query that are guranteed to be sorted first or last.
Simple example, given an emitted key of something like [doc.tag, doc.descr] currently to get the data for a specific tag we would use something like:
startkey=['tag_name']&endkey=['tag_name', 'ZZZZZZ'] which is a bit hackish at best.
Perhaps startkey=['tag_name',_first_]&endkey=['tag_name',_last_]
Obviously _first_ and _last_ are crappy. And _first_ would even be optional. But hopefully that conveys the idea.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (COUCHDB-124) Adding first and last sort keys
Posted by "Chris Anderson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/COUCHDB-124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12635245#action_12635245 ]
Chris Anderson commented on COUCHDB-124:
----------------------------------------
We discussed this on IRC - there's not a good reason to add this. See http://wiki.apache.org/couchdb/ViewCollation for full documentation of the JSON sort order.
In the case of the example given, there is no need for the 'ZZZZ' string, this is equivalent and not hackish.
startkey=["tag_name"]&endkey=["tag_name", {}]
of course, this doesn't help with the case of
startkey="_design/"&endkey="_design/ZZZZZZZZZ"
which we see frequently. But there's no way a "special" value can help with a string range, because we can't allow the special value *inside* the string without opening a whole can of worms. If you didn't want to be hackish while defining a string range you could use a super-high unicode character.
startkey="_design/"&endkey="_design/\u9999"
> Adding first and last sort keys
> -------------------------------
>
> Key: COUCHDB-124
> URL: https://issues.apache.org/jira/browse/COUCHDB-124
> Project: CouchDB
> Issue Type: Improvement
> Components: HTTP Interface
> Reporter: Paul Joseph Davis
>
> We should add values to the view query that are guranteed to be sorted first or last.
> Simple example, given an emitted key of something like [doc.tag, doc.descr] currently to get the data for a specific tag we would use something like:
> startkey=['tag_name']&endkey=['tag_name', 'ZZZZZZ'] which is a bit hackish at best.
> Perhaps startkey=['tag_name',_first_]&endkey=['tag_name',_last_]
> Obviously _first_ and _last_ are crappy. And _first_ would even be optional. But hopefully that conveys the idea.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (COUCHDB-124) Adding first and last sort keys
Posted by "Gilbert B Garza (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/COUCHDB-124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12635215#action_12635215 ]
Gilbert B Garza commented on COUCHDB-124:
-----------------------------------------
I think this is a great idea. Perhaps something along the lines of _null could work, since its meaning could be interpreted by its context.
> Adding first and last sort keys
> -------------------------------
>
> Key: COUCHDB-124
> URL: https://issues.apache.org/jira/browse/COUCHDB-124
> Project: CouchDB
> Issue Type: Improvement
> Components: HTTP Interface
> Reporter: Paul Joseph Davis
>
> We should add values to the view query that are guranteed to be sorted first or last.
> Simple example, given an emitted key of something like [doc.tag, doc.descr] currently to get the data for a specific tag we would use something like:
> startkey=['tag_name']&endkey=['tag_name', 'ZZZZZZ'] which is a bit hackish at best.
> Perhaps startkey=['tag_name',_first_]&endkey=['tag_name',_last_]
> Obviously _first_ and _last_ are crappy. And _first_ would even be optional. But hopefully that conveys the idea.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (COUCHDB-124) Adding first and last sort keys
Posted by "Chris Anderson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/COUCHDB-124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Anderson closed COUCHDB-124.
----------------------------------
Resolution: Won't Fix
> Adding first and last sort keys
> -------------------------------
>
> Key: COUCHDB-124
> URL: https://issues.apache.org/jira/browse/COUCHDB-124
> Project: CouchDB
> Issue Type: Improvement
> Components: HTTP Interface
> Reporter: Paul Joseph Davis
>
> We should add values to the view query that are guranteed to be sorted first or last.
> Simple example, given an emitted key of something like [doc.tag, doc.descr] currently to get the data for a specific tag we would use something like:
> startkey=['tag_name']&endkey=['tag_name', 'ZZZZZZ'] which is a bit hackish at best.
> Perhaps startkey=['tag_name',_first_]&endkey=['tag_name',_last_]
> Obviously _first_ and _last_ are crappy. And _first_ would even be optional. But hopefully that conveys the idea.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.