Skip to content

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

Closed

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

Activity

  1. lvca commented on Sep 20, 2023

    @lvca
    Member

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

  2. self-assigned this
    on Sep 20, 2023
  3. added
    invalidThis doesn't seem right
    questionFurther information is requested
    wontfixThis will not be worked on
    on Sep 20, 2023
  4. added this to the 23.9.1 milestone on Sep 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

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

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions