Skip to content

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

Description

@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

Metadata

Metadata

Assignees

Labels

invalidThis doesn't seem rightquestionFurther information is requestedwontfixThis will not be worked on

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions