Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
8.10
Description
Error message
java.io.IOException: score is not a valid field for unlimited queries.",
To replicate:
Sample documents:
{ "name_s":"Foo", "cities_ss":["SFO", "NYC"], "userid_i":1, "id":"1"}, { "name_s":"Bar", "cities_ss":["SEA", "NYC"], "userid_i":2, "id":"2"}] }
Query:
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')
fails with
{ "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 } ] } }
where as if I only use two filters
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')
passes
{ "result-set": { "docs": [ { "QUERY_COUNT": 1 }, { "EOF": true, "RESPONSE_TIME": 940 } ] } }