Re: Simple sql query with where clause doesn't work

[lazarusjohn <la...@gmail.com>]

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.

Re: Simple sql query with where clause doesn't work

[Joel Bernstein <jo...@gmail.com>]

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 <la...@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.
>