Transitive(?) index

[xzf...@gmail.com]

Hello,

The basic CREATE INDEX statement is:



CREATE INDEX <name> [ON <class-name> (prop-names)] <type> 

e.g. 

CREATE INDEX simpleidx myclass.prop1 NOTUNIQUE

Now let's imagine that prop1 is a property which is a LINK to another class, which has a STRING property prop2 .

Can I create a transitive(? if this is the appropriate term) index like this:

CREATE INDEX transidx myclass.prop1.prop2 NOTUNIQUE

When I try to run something like that in the shell, it 
does not complain but I am afraid it just reads 'prop1.prop2' as 
a name of a non-existing property with a dot in the middle. 

Dots should really not be allowed in prop names (but they are).

Thanks!
Dmitri

[alessand...@gmail.com]

Hi, 

which version of OrientDb are you using ?

Kind regards,

Alessandro

[DmitriR]

Hi Alessandro -  It's 2.1.2

Thanks

Dmitri

--

---
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/vbclPQZQnAU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[alessand...@gmail.com]

Hi,

when I try the following command "CREATE INDEX transidx ON myclass.prop1.prop2 NOTUNIQUE"

I get an OCommandExecutionException: Class myclass.prop1.prop2 not found

Alessandro