You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Andy Tran (JIRA)" <ji...@apache.org> on 2017/03/10 19:13:04 UTC

[jira] [Updated] (SOLR-10267) Solr SQL throws an error for collections with uppercase chars in name

     [ https://issues.apache.org/jira/browse/SOLR-10267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy Tran updated SOLR-10267:
-----------------------------
    Description: 
Team, I did some tests on a local Solr v6.3 instance where the curl works for `default` but fails for `BestBuy` collection:

~> curl --data-urlencode 'stmt=SELECT count(*) FROM BestBuy' http://localhost:8983/solr/BestBuy/sql?aggregationMode=facet
{"result-set":{"docs":[
{"EXCEPTION":"org.apache.solr.common.SolrException: Collection not found: bestbuy","EOF":true,"RESPONSE_TIME":0}]}}


~> curl --data-urlencode 'stmt=SELECT count(*) FROM default' http://localhost:8983/solr/default/sql?aggregationMode=facet
{"result-set":{"docs":[
{"count(*)":224736},
{"EOF":true,"RESPONSE_TIME":5}]}}

Can someone confirm this bug and remedy?  Thanks.

  was:
Team, I did some tests on a local Solr v6.3 instance where the curl works for `default` but fails for `BestBuy` collection:

`
~> curl --data-urlencode 'stmt=SELECT count(*) FROM BestBuy' http://localhost:8983/solr/BestBuy/sql?aggregationMode=facet
{"result-set":{"docs":[
{"EXCEPTION":"org.apache.solr.common.SolrException: Collection not found: bestbuy","EOF":true,"RESPONSE_TIME":0}]}}


~> curl --data-urlencode 'stmt=SELECT count(*) FROM default' http://localhost:8983/solr/default/sql?aggregationMode=facet
{"result-set":{"docs":[
{"count(*)":224736},
{"EOF":true,"RESPONSE_TIME":5}]}}
`
Can someone confirm this bug and remedy?  Thanks.


> Solr SQL throws an error for collections with uppercase chars in name
> ---------------------------------------------------------------------
>
>                 Key: SOLR-10267
>                 URL: https://issues.apache.org/jira/browse/SOLR-10267
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>    Affects Versions: 6.3
>            Reporter: Andy Tran
>
> Team, I did some tests on a local Solr v6.3 instance where the curl works for `default` but fails for `BestBuy` collection:
> ~> curl --data-urlencode 'stmt=SELECT count(*) FROM BestBuy' http://localhost:8983/solr/BestBuy/sql?aggregationMode=facet
> {"result-set":{"docs":[
> {"EXCEPTION":"org.apache.solr.common.SolrException: Collection not found: bestbuy","EOF":true,"RESPONSE_TIME":0}]}}
> ~> curl --data-urlencode 'stmt=SELECT count(*) FROM default' http://localhost:8983/solr/default/sql?aggregationMode=facet
> {"result-set":{"docs":[
> {"count(*)":224736},
> {"EOF":true,"RESPONSE_TIME":5}]}}
> Can someone confirm this bug and remedy?  Thanks.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org