SQL Subquery in 3.0.X

[ttamatt]

OrientDB Version: 3.0.7

Java Version: 1.8

OS: Centos 6.8

FAILED SQL

SELECT `instanceId` AS `instanceId`,@version AS `@version` 
FROM v_instance_testSearchObjA1365535933 WHERE `instanceId` IN  
( SELECT in('e_instance_testSearchObjA1365535933_left_id_right_id_testSearchObjB1365547061').instanceId AS `_ref_instance_ids` 
FROM v_instance_testSearchObjB1365547061 WHERE `name` = 'Jack' )   SKIP 0 LIMIT 200

SUCCESSFUL SQL

SELECT `instanceId` AS `instanceId`,@version AS `@version` 
FROM v_instance_testSearchObjA1365535933 LET $refs =
( SELECT in('e_instance_testSearchObjA1365535933_left_id_right_id_testSearchObjB1365547061').instanceId AS `_ref_instance_ids` 
FROM v_instance_testSearchObjB1365547061 WHERE `name` = 'lightjiao' ) 
WHERE `instanceId` IN  $refs[0].`_ref_instance_ids`  SKIP 0 LIMIT 200

Expected behavior

METADATA	PROPERTIES
@Version	instanceId
3	5b9a089240fc8
3	5b9a089243673

Actual behavior

Empty data

After I tried the latest code pushed to 3.0.x, subquery problem works fine when meet some basic situation with index, like two vertexes and an edge, but somehow it doesn't work well in our situation, can you figure out the reason for us please?

Thanks,
Matt

[luigidellaquila]

Hi @ttamatt

Do you have a chance to replicate the problem on demodb? I'm not sure I have the full picture

Thanks

Luigi

[luigidellaquila]

Hi @ttamatt

This could be something we already fixed here
#8531

Do you have a chance to test latest snapshot and see if also your case is already fixed?
https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/3.0.8-SNAPSHOT/

Thanks

Luigi

[ttamatt]

It seems works fine now, thanks!