You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Timothy Potter (Jira)" <ji...@apache.org> on 2022/02/02 23:38:00 UTC
[jira] [Assigned] (SOLR-15974) IOException when running count(*) query
[ https://issues.apache.org/jira/browse/SOLR-15974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Timothy Potter reassigned SOLR-15974:
-------------------------------------
Assignee: Timothy Potter
> IOException when running count(*) query
> ---------------------------------------
>
> Key: SOLR-15974
> URL: https://issues.apache.org/jira/browse/SOLR-15974
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Parallel SQL
> Affects Versions: 8.10
> Reporter: Kiran
> Assignee: Timothy Potter
> Priority: Major
>
> Error message
> {code:java}
> java.io.IOException: score is not a valid field for unlimited queries.", {code}
> To replicate:
> Sample documents:
> {code:java}
> {
> "name_s":"Foo",
> "cities_ss":["SFO",
> "NYC"],
> "userid_i":1,
> "id":"1"},
> {
> "name_s":"Bar",
> "cities_ss":["SEA",
> "NYC"],
> "userid_i":2,
> "id":"2"}]
> } {code}
> Query:
>
> {code:java}
> http://localhost:8983/solr/sql_test/sql?qt=/sql&stmt=select count(*) as QUERY_COUNT from sql_test WHERE (userid_i='1') AND (id='1') AND (name_s='Foo'){code}
> fails with
> {code:java}
> {
> "result-set": {
> "docs": [
> {
> "EXCEPTION": "Failed to execute sqlQuery 'select count(*) as QUERY_COUNT from sql_test WHERE (userid_i='1') AND (id='1') AND (name_s='Foo')' against JDBC connection 'jdbc:calcitesolr:'.\nCaused by: Error while executing SQL \"select count(*) as QUERY_COUNT from sql_test WHERE (userid_i='1') AND (id='1') AND (name_s='Foo')\": java.io.IOException: score is not a valid field for unlimited queries.",
> "EOF": true,
> "RESPONSE_TIME": 951
> }
> ]
> }
> }
> {code}
> where as if I only use two filters
> {code:java}
> http://localhost:8983/solr/sql_test/sql?qt=/sql&stmt=select count(*) as QUERY_COUNT from sql_test WHERE (userid_i='1') AND (id='1') {code}
> passes
>
> {code:java}
> {
> "result-set": {
> "docs": [
> {
> "QUERY_COUNT": 1
> },
> {
> "EOF": true,
> "RESPONSE_TIME": 940
> }
> ]
> }
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org