oha, it works again.. but why ?? 

i changed my import with DIH, again back and it works fine like bevore...

but whats the reaseon for this behavior ? 

thats the query wich worked not:
query="select i.id, i.shop_id, i.name, ... 
FROM items_de.shop_items as i 
JOIN base.shops s ON s.id = i.shop_id 
WHERE s.is_active = 1 AND is_deleted=0" 

i changed the query to this:
select i.id, i.shop_id, i.name, ...
FROM items_de.shop_items as i, base.shops as s 
WHERE s.id=i.shop_id AND s.is_active=1 AND is_deleted=0"

so, why did request handler handle the first query ???? 
very strange for me, because the JOIN is the same like the WHERE-thing in
the second query !? 


-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/aaaah-No-response-No-Result-tp757948p758883.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to