[ https://issues.apache.org/jira/browse/SOLR-15974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kiran updated SOLR-15974: ------------------------- Summary: IOException when running count(*) query (was: count(*) query fails if there are more than two fields in the filter clause) > 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 > 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-unsubscr...@solr.apache.org For additional commands, e-mail: issues-h...@solr.apache.org