WHERE [property] = [nested select query] does not work

[vic0824]

ArcadeDB Version:

ArcadeDB Server v23.7.1 (build 3213507/1692051585396/main)

OS and JDK Version:

Windows 10 10.0 - OpenJDK 64-Bit Server VM 11.0.20.1 (Corretto-11.0.20.9.1)

Expected behavior

It should be possible to execute a query that selects a record based on a property being equal to result of a nested select

Actual behavior

a query that selects a record based on a property being equal to result of a nested select returns zero records.
The same query rewritten with "IN" instead of "=" works.

Steps to reproduce

Execute the attached testNestedQueryResultInWhereClause test case and verify that the following assertion error is thrown:
Exception in thread "main" org.opentest4j.AssertionFailedError: expected: <true> but was: <false>
testNestedQueryResultInWhereClause.zip

[lvca]

It's actually correct using the IN, because the select returns a collection.