Seems like this only happend when the value is not a number
curl --data-urlencode 'stmt=select fieldA from collection where field='123'' http://host:port/solr/collection/sql?aggregationMode=facet works. while this one doesnt work: curl --data-urlencode 'stmt=select fieldA from collection where field='abc'' http://host:port/solr/collection/sql?aggregationMode=facet Again, the same message with "no field name specified in query and no default specified via df param". tried this on multiple field types. example of field settings: type=string, indexed=true, stored=true, omitNorms=true, multiValued=false, docValues=true. Note that this collection was indexed as nested documents, but while trying the sql, I'm not using anything related to the nested format (except that the data itself was indexed this way) -- View this message in context: http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498p4324499.html Sent from the Solr - User mailing list archive at Nabble.com.