You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Kiran (Jira)" <ji...@apache.org> on 2022/02/02 23:34:00 UTC
[jira] [Updated] (SOLR-15974) count(*) query fails if there are more than three fields in the filter clause
[ https://issues.apache.org/jira/browse/SOLR-15974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kiran updated SOLR-15974:
-------------------------
Description:
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}
was:
Error message
{code:java}
java.io.IOException: score is not a valid field for unlimited queries.", {code}
To replicate:
Sample documents:
> count(*) query fails if there are more than three fields in the filter clause
> -----------------------------------------------------------------------------
>
> 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-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org