[
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
