IN keyword issue in Orient 3.0.8

[milankyada]

OrientDB Version: 3.0.8

Java Version: 1.8.0_171

OS: Ubuntu 14.04.5 LTS

Expected behavior

Query should return same result as returning in OrientDB 2.2.35 but it is returning empty resultset

Actual behavior

select from Company where outE('is_a')[type="Tenant"].inV()['@Rid'] in [#28:9,#28:8,#28:7] limit 5
This query is working fine with OrientDB 2.2.35 but the same query is not returning same result with OrientDB 3.0.8

Steps to reproduce

CREATE CLASS Company EXTENDS V
CREATE PROPERTY Company.name string
Insert into Company(name) values("webix pvt. ltd."),("diversity pvt. ltd.")

CREATE CLASS Tenant EXTENDS V
CREATE PROPERTY Tenant.name string
Insert into Tenant(name) values("DotNet"),("pdev")

CREATE CLASS is_a EXTENDS E
CREATE EDGE is_a FROM #18:0 TO #22:0
CREATE EDGE is_a FROM #18:0 TO #23:0
CREATE EDGE is_a FROM #19:0 TO #22:0
CREATE EDGE is_a FROM #19:0 TO #23:0

select from Company where outE('is_a')[type="Tenant"].inV()["@rid"] in [#22:0,#23:0] 

[luigidellaquila]

Hi @milankyada

Thank you for reporting, I'd say it's a bug, I'll check it asap and let you know

Thanks

Luigi

[luigidellaquila]

Hi @milankyada

You have a few problems here, some can be considered bugs, others are conceptual:

• graph operators (out(), outE(), in() and so on) return collections, so does outE('is_a')[type="Tenant"].inV()["@rid"], so you cannot use IN operator; you have to use CONTAINSANY instead:

select from Company where outE('is_a')[type="Tenant"].inV()["@rid"] CONTAINSANY [#22:0,#23:0] 

• outE('is_a')[type="Tenant"] returns nothing, just because you don't have a type attribute on your edges. Perhaps you want to extract only Tenant vertices? In this case you have to do as follows:
  outE('is_a').inV()[@class = "Tenant"] or, more easily out('is_a')[@class = "Tenant"]

• the following still returns nothing:

select from Company where out('is_a')["@rid"] CONTAINSANY [#22:0,#23:0] 

and the problem here seems to be a bug concerning "@Rid" used in square brackets. The following works fine instead:

select from Company where out('is_a').@rid CONTAINSANY [#22:0,#23:0] 

I'm checking this last bug now

Thanks

Luigi

[luigidellaquila]

Hi @milankyada

I just pushed a fix for the problem with square bracket selection

Thanks

Luigi

[milankyada]

Thank you @luigidellaquila
I'll be waiting for next release.