You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@lucene.apache.org by "Joel Bernstein (JIRA)" <ji...@apache.org> on 2016/02/08 00:07:39 UTC

[jira] [Commented] (SOLR-8654) SQL: Unlimited SELECT without an ORDER BY should sort by _version_ desc

    [ https://issues.apache.org/jira/browse/SOLR-8654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15136508#comment-15136508 ] 

Joel Bernstein commented on SOLR-8654:
--------------------------------------

The _version_ is stripped from the result set by the SelectStream in this patch. So there is no sign that the version number is even involved. The documentation will need to be updated to reflect that the _version_ must have docValues set to true in the schema. 

> SQL: Unlimited SELECT without an ORDER BY should sort by _version_ desc
> -----------------------------------------------------------------------
>
>                 Key: SOLR-8654
>                 URL: https://issues.apache.org/jira/browse/SOLR-8654
>             Project: Solr
>          Issue Type: Improvement
>    Affects Versions: 6.0
>            Reporter: Joel Bernstein
>            Assignee: Joel Bernstein
>         Attachments: SOLR-8654.patch
>
>
> Currently unlimited SELECT statements will throw an exception if an ORDER BY clause is not provided. This is because unlimited selects are handled by the /export handler which requires a sort. Rather then throw an exception we can just order by the _version_ number. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org