Fulltext index in lowercase

[Riccardo Tasso]

Hi, I'm experimenting the fulltext index which is an interesting function for OrientDB.

The containsText operator works as expected, if a fulltext index is created, but it's case sensitive.

Is there a way to create a fulltext index which is case insensitive?

Thanks,

   Riccardo

[Luca Garulli]

Hi Riccardo,

Have you tried to set the collate "CI" against the indexed field?

Lvc@

PS: why you are not at Codemotion event in Rome today?! :-)

--

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

[Riccardo Tasso]

2014-04-11 12:32 GMT+02:00 Luca Garulli <l.ga...@gmail.com>:

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

[Andrey Lomakin]

Hi,

I have fixed it yesterday.

Could you try ?

--

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

--

Best regards,
Andrey Lomakin.

Orient Technologies
the Company behind OrientDB

[Riccardo Tasso]

I'm sorry, I can't try at this moment, when the 1.7.0 version is expected?

Riccardo

[Andrey Lomakin]

According to our estimations we need 4 weeks.

[Andrey Lomakin]

If current release scope will not be changed of course.

[Riccardo Tasso]

Anyway the syntax is correct?

Please add this part to the index documentation, I didn't find anything!

Riccardo

[Andrey Lomakin]

Yes,

This syntax is correct.

[Justin Harris]

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

[Hung Tran]

Hi,

I cannot find any method with name setCollate in the source code at version 1.6.0, any help?

My Best,

Hung Tran

[Riccardo Tasso]

2014-04-11 20:43 GMT+02:00 Justin Harris <justin...@gmail.com>:

works if the label property has already been set to use CI collating, I did it in Java by doing something like this

Thanks, can I do it with a console command?

Cheers,

   Riccardo

[Riccardo Tasso]

2014-04-14 9:15 GMT+02:00 Riccardo Tasso <riccard...@gmail.com>:

Thanks, can I do it with a console command?

Yes, it is done by:

ALTER PROPERTY MyClass.my_property COLLATE ci

Thanks for the suggesion, it seems to work.

Riccardo

[Riccardo Tasso]

Hi, I can't decide if I found a bug. When I change the collate for a field, also the fields with the same name of the super-classes change collate. I understood that for a hierarchy of classes the field is the same, but this behaviour seems to me a bit unexpected.

In attachment you'll find the test-case.

Cheers,

   Riccardo

[Justin Harris]

Hey Hung,

I'm using the latest as of now, 1.7-rc2.

Justin Harris | via Android

You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/ZgGgeaRSMK8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Luca Garulli]

Hi Riccardo,

good question. In OO the underlying property should overwrite the base one, but this could drives to problems and unexpected behaviors. But if this is what you need the collate shouldn't be propagated to the sub-field because it should be managed as an overriding of the base field.

May you open an new issue attaching this test case?

Lvc@

[Riccardo Tasso]

This is not a problem for my use case, anyway this is the issue: https://github.com/orientechnologies/orientdb/issues/2225

Riccardo