CONTAINSANY bug with subquery

[creisle]

OrientDB Version: 3.0.22

Java Version:

openjdk version "1.8.0_191"
OpenJDK Runtime Environment (build 1.8.0_191-b12)
OpenJDK 64-Bit Server VM (build 25.191-b12, mixed mode

OS: centos07

Expected behavior

The query should always return the same results. Should not change if there is no index

Actual behavior

Unless the index is added the query does not return any results

Steps to reproduce

create class Main extends V
create property Main.linksetprop linkset V

create vertex V set name = 'bob' /* 9:0 */
create vertex V set name = 'dudley' /* 9:1 */
create vertex V set name = 'alice' /* 10:0 */
create vertex V set name = 'marc' /* 11:0 */
create vertex V set name = 'harry' /* 12:0 */

create vertex Main set linksetprop = [#9:0, #10:0]
create vertex Main set linksetprop = [#9:0, #11:0]
create vertex Main set linksetprop = [#9:0, #12:0]

select * from Main where linksetprop containsany [#9:0]  /* 3 results*/

select * from V where name = 'bob' /* 1 result (9:0) */

select * from Main where linksetprop containsany (select * from V where name = 'bob')  /* no results */

create index Main.linksetprop on Main (linksetprop) NOTUNIQUE

select * from Main where linksetprop containsany (select * from V where name = 'bob')  /* 3 results */

[luigidellaquila]

Hi @creisle

Thank you very much for reporting, I'll check it ASAP and let you know

Thanks

Luigi

[luigidellaquila]

Hi @creisle

I just pushed a fix for this problem, it will be released with v 3.0.25

Thanks

Luigi