[
https://issues.apache.org/jira/browse/SOLR-9499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15482187#comment-15482187
]
Gus Heck commented on SOLR-9499:
--------------------------------
I'm wondering if the code for this should be using SortSpecParsing (at least
when using /select)... right now it simply splits on ',' which also fails on
functions that contain commas (which work just fine in fl again, but not in
sort). Of course the difficulty with that is that SortSpecParsing wants either
an IndexSchema or a Request...
This may also be pushing beyond intentions for streaming, but the docs seem to
suggest that qt=/export is subject to /export restrictions and qt=/select is
not restricted...
bq. The /export handler is not used by default because it has stricter
requirements then the /select handler so it's not as easy to get started
working with. To read more about the /export handler requirements review the
section Exporting Result Sets.
> 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
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
