[ 
https://issues.apache.org/jira/browse/SOLR-9499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gus Heck updated SOLR-9499:
---------------------------
    Attachment: SOLR-9499.patch

Patch to solve the problem described initially. Allows for sorting on the 
original (non-aliased) name of the field, similar to normal select. Broader 
issue that sort spec parsing is inconsistent with what's normally available for 
select (i.e. functions, etc) left for another time.

> Streaming Expression Cannot sort on aliased field 
> --------------------------------------------------
>
>                 Key: SOLR-9499
>                 URL: https://issues.apache.org/jira/browse/SOLR-9499
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: search
>    Affects Versions: 6.2
>         Environment: 6.2.0_RC1
>            Reporter: Gus Heck
>            Priority: Minor
>         Attachments: SOLR-9499.patch
>
>
> an expression such as:
> {code}
> search(test, rows=999999, q=table:article_p, 
> fl="yi_pw,id,article:article_id", sort="article asc") 
> or
> search(test, rows=999999, q=table:article_p, 
> fl="yi_pw,id,article:article_id", sort="article_id asc") 
> {code}
> results in: 
> {code}
> {"result-set":{"docs":[
> {"EXCEPTION":"Fields in the sort spec must be included in the field 
> list:article","EOF":true}]}}
> or
> {"result-set":{"docs":[
> {"EXCEPTION":"Fields in the sort spec must be included in the field 
> list:article_id","EOF":true}]}}
> {code}
> and 
> {code}
> {"result-set":{"docs":[
> {"EXCEPTION":"Fields in the sort spec must be included in the field 
> list:article:article_id","EOF":true}]}}
> {code}
> yeilds 
> {code}
> {"result-set":{"docs":[
> {"EXCEPTION":"java.util.concurrent.ExecutionException: java.io.IOException: 
> --> http://10.1.3.9:8983/solr/test_shard1_replica1/:sort param could not be 
> parsed as a query, and is not a field that exists in the index: 
> article:article_id","EOF":true,"RESPONSE_TIME":5}]}}
> {code}
> If I sort by id instead, it all works fine. 



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

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

Reply via email to