Hi Eddy

which version are you using of OrientDB?

can you paste here the explain of the second query?

explain select out.writing from word_language  where in.abbreviation = 'en'
and

*out.writing lucene 'tru*'Enrico*

2015-10-12 10:33 GMT+02:00 Eddy Fosman <[email protected]>:

> I have a class named Word and property "writing " with lucene index. The
> second class name Language with property 'abbreviation' like
> 'en','ja','es'... The edge "word_language" is linked between them.
> I just wonder why this query works perfectly:
>
> select out.writing from word_language  where in.abbreviation = 'en' and
>
> *out in (select from Word where writing lucene 'tru*')*but in this query,
> nothing is returned:
>
> select out.writing from word_language  where in.abbreviation = 'en' and
>
> *out.writing lucene 'tru*'*I could use the first query, but I'm afraid of
> some performance issues. Could anyone tell me the problem of second query?
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "OrientDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to