You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
WHERE [property] = [nested select query] does not work #1245
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
lvca commentedon Sep 20, 2023
It's actually correct using the IN, because the select returns a collection.
build(deps): bump actions/setup-node from 4.3.0 to 4.4.0 [skip ci]
chore(deps): bump org.apache.maven.plugins:maven-javadoc-plugin from …
chore(deps): bump org.apache.maven.plugins:maven-assembly-plugin from…
chore(deps-dev): bump testcontainers from 11.12.0 to 11.13.0 in /e2e-…
chore(deps-dev): bump testcontainers from 11.12.0 to 11.13.0 in /e2e-…
chore(deps): update asyncpg requirement from >=0.29.0 to >=0.31.0 in …
build(deps): bump actions/setup-node from 4.3.0 to 4.4.0 [skip ci]
chore(deps): bump org.apache.maven.plugins:maven-javadoc-plugin from …
chore(deps): bump org.apache.maven.plugins:maven-assembly-plugin from…
chore(deps-dev): bump testcontainers from 11.12.0 to 11.13.0 in /e2e-…
chore(deps-dev): bump testcontainers from 11.12.0 to 11.13.0 in /e2e-…
chore(deps): update asyncpg requirement from >=0.29.0 to >=0.31.0 in …
chore(deps): bump actions/setup-java from 5.7.0 to 6.0.0 [skip ci]