Can you post the schema also?
Did Supertable extends other classes?
Di you have also a class Cpv?
2015-10-06 10:42 GMT+02:00 syshex <sys...@gmail.com>:
> Hi Enrico
>
> Raw from studio for the explain query you requested:
>
> {
> "result": [
> {
> "@type": "d",
> "@version": 0,
> "limit": -1,
> "luceneIndex": true,
> "fullySortedByIndex": false,
> "Cpv_description_totalHits": 30,
> "evaluated": 30,
> "score": 1,
> "documentAnalyzedCompatibleClass": 30,
> "involvedIndexes": [
> "Supertable.description"
> ],
> "totalHits": 30,
> "indexIsUsedInOrderBy": false,
> "current": "#25:12",
> "fetchingFromTargetElapsed": 15,
> "documentReads": 30,
> "user": "#5:0",
> "recordReads": 30,
> "elapsed": 18.605516,
> "resultType": "collection",
> "resultSize": 0,
> "@fieldTypes":
> "evaluated=l,score=f,documentAnalyzedCompatibleClass=l,involvedIndexes=e,current=x,fetchingFromTargetElapsed=l,documentReads=l,user=x,recordReads=l,elapsed=f"
> }
> ],
> "notification": "Query executed in 0.034 sec. Returned 1 record(s)"
> }
>
> Hope this helps
> Rui
>
> On Monday, October 5, 2015 at 8:28:33 PM UTC+1, Enrico Risa wrote:
>>
>> Hi syshex
>>
>> can you paste here the result of
>>
>> explain SELECT * FROM Supertable WHERE description LUCENE "limpeza*"
>>
>> 2015-10-05 20:07 GMT+02:00 syshex <sys...@gmail.com>:
>>
>>> Hi everyone.
>>>
>>> I've got a table named Supertable with a String field called
>>> description.
>>>
>>> Created a Lucene index on it, like so :
>>>
>>> create index Supertable.description on Supertable (description)
>>> FULLTEXT ENGINE LUCENE
>>>
>>> return from studio was that the index was created, with 1150 indexed.
>>>
>>> If I query the index directly, like so :
>>>
>>> SELECT * FROM index:Supertable.description WHERE key LUCENE "limpeza*"
>>>
>>> I get 20 results back, with key = "limpeza*" and the rid of the
>>> corresponding V .
>>>
>>> If I select like this :
>>>
>>> SELECT * FROM Supertable WHERE description LUCENE "limpeza*"
>>>
>>> I get 0 results back.
>>>
>>> Is this a bug or what?
>>>
>>> Thanks for your time
>>>
>>> --
>>>
>>> ---
>>> 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 orient-databa...@googlegroups.com.
>>> 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 orient-database+unsubscr...@googlegroups.com.
> 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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
