I believe the NOT should be working. But the joins won't work correctly. Apache Calcite, which is parsing the query, is attempting to do the joins but there are no test cases with joins at all. The official docs should say that joins are not supported.
Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Oct 16, 2018 at 4:09 AM deniz <denizdurmu...@gmail.com> wrote: > okay, found a work around for string fields for NOT queries > > This query does not filters for NOT: > > curl --data-urlencode "stmt=select id, name from collection where NOT (name > = 'defaultmail')" 'http://server:port/solr/collection/sql' > > but after adding sth trivial i.e id > 0 o the where clause as > > curl --data-urlencode "stmt=select id, name from collection where id > 0 > AND > NOT (name > = 'defaultmail')" 'http://server:port/solr/collection/sql' > > i am not seeing any name field with 'defaultmail' in the response. > > I am not sure if this is a bug or just a wrong syntax while using NOT in > the > where clause as a single criteria though > > > > > > > ----- > Zeki ama calismiyor... Calissa yapar... > -- > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html >
