Which version of Solr are you working with? Solr 6.5 has different SQL engine the 6.0 through 6.4. Also what are field types you are working with in the where clause?
Here is SQL query from the test cases in 6.4: select id, Field_i, Str_s from Collection1 where Text_t='XXXX' order by Field_i desc" This shows a where clause with on text field. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Apr 7, 2017 at 3:05 PM, lazarusjohn <lazarusj...@gmail.com> wrote: > Did you find answer I getting same error when I use text instead of number > in > Where clause - Please let me know. > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/Simple-sql-query-with-where-clause-doesn-t- > work-tp4324498p4328991.html > Sent from the Solr - User mailing list archive at Nabble.com. >
