In the meantime, I found that:
create index myidx ON Agent (label) FULLTEXT

works if the label property has *already* been set to use CI collating, I 
did it in Java by doing something like this:
OrientGraphNoTx _g = new OrientGraphFactory("remote:localhost/graph").
getNoTx();
OrientVertexType vertexType = _g.createVertexType(
                "Agent",
                OrientVertexType.CLASS_NAME);
        vertexType.createProperty("label", OType.STRING).setCollate("CI");

You can query it like so:
SELECT FROM index:myidx where key = ?



On Friday, April 11, 2014 10:32:50 AM UTC-4, Andrey Lomakin wrote:
>
> Yes,
> This syntax is correct.
>
>
> On Fri, Apr 11, 2014 at 4:51 PM, Riccardo Tasso 
> <[email protected]<javascript:>
> > wrote:
>
>> Anyway the syntax is correct?
>> Please add this part to the index documentation, I didn't find anything!
>>
>> Riccardo
>>
>> Il giorno venerdì 11 aprile 2014 14:55:24 UTC+2, Andrey Lomakin ha 
>> scritto:
>>>
>>> If current release scope will not be changed of course.
>>>
>>>
>>> On Fri, Apr 11, 2014 at 3:55 PM, Andrey Lomakin <[email protected]>wrote:
>>>
>>>> According to our estimations we need 4 weeks.
>>>>  
>>>>
>>>> On Fri, Apr 11, 2014 at 3:38 PM, Riccardo Tasso 
>>>> <[email protected]>wrote:
>>>>
>>>>> I'm sorry, I can't try at this moment, when the 1.7.0 version is 
>>>>> expected?
>>>>>
>>>>> Riccardo
>>>>>
>>>>> Il giorno venerdì 11 aprile 2014 13:52:50 UTC+2, Andrey Lomakin ha 
>>>>> scritto:
>>>>>>
>>>>>> Hi,
>>>>>> I have fixed it yesterday.
>>>>>> Could you try ?
>>>>>>
>>>>>>
>>>>>> On Fri, Apr 11, 2014 at 1:59 PM, Riccardo Tasso <[email protected]
>>>>>> > wrote:
>>>>>>
>>>>>>>
>>>>>>> 2014-04-11 12:32 GMT+02:00 Luca Garulli <[email protected]>:
>>>>>>>
>>>>>>>  Have you tried to set the collate "CI" against the indexed field?
>>>>>>>>
>>>>>>>
>>>>>>> Hi Luca, thanks first of all.
>>>>>>>
>>>>>>>  Do you mean something like: create index myidx ON Agent (label 
>>>>>>> COLLATE CI) FULLTEXT  ?
>>>>>>> It gives me the following exception:
>>>>>>> Error: 
>>>>>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: 
>>>>>>> Error on parsing command at position #27: Illegal field name format, 
>>>>>>> should 
>>>>>>> be '<property> [by key|value]' but was 'label COLLATE CI'
>>>>>>>  
>>>>>>> Riccardo
>>>>>>>
>>>>>>> -- 
>>>>>>>
>>>>>>> --- 
>>>>>>> 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.
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> Best regards,
>>>>>> Andrey Lomakin.
>>>>>>
>>>>>> Orient Technologies
>>>>>> the Company behind OrientDB
>>>>>>
>>>>>>   -- 
>>>>>
>>>>> --- 
>>>>> 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.
>>>>>
>>>>
>>>>
>>>>
>>>> -- 
>>>> Best regards,
>>>> Andrey Lomakin.
>>>>
>>>> Orient Technologies
>>>> the Company behind OrientDB
>>>>
>>>>  
>>>
>>>
>>> -- 
>>> Best regards,
>>> Andrey Lomakin.
>>>
>>> Orient Technologies
>>> the Company behind OrientDB
>>>
>>>   -- 
>>
>> --- 
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Best regards,
> Andrey Lomakin.
>
> Orient Technologies
> the Company behind OrientDB
>
> 

-- 

--- 
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