Cypher queries broken in 22.1.3

ArcadeDB Version: 22.1.3

JDK Version: what is included in official docker image

OS: Debian 11

Expected behavior

I create a database with two vertices with labels "First" and "Second".
Following query should return both nodes:
MATCH (a),(b) WHERE a.label = "First" AND b.label = "Second" RETURN a,b

NOTE: this worked in 21.10.1

Actual behavior

Query returns empty array for vertices

Steps to reproduce

CREATE (p:Person {label:"First"}) return p
CREATE (p:Person {label:"Second"}) return p
MATCH (a),(b) WHERE a.label = "First" AND b.label = "Second" RETURN a,b

ADDITION: CURL commans used

curl -X POST -H "Content-Type: application/json" \
  -d '{"command": "CREATE (n:Person {label:\"First\"}) return n", "language": "cypher", "serializer": "graph"}' \
  http://localhost:2480/api/v1/command/kukakukin --user "root:rootroot"

curl -X POST -H "Content-Type: application/json" \
  -d '{"command": "CREATE (n:Person {label:\"Second\"}) return n", "language": "cypher", "serializer": "graph"}' \
   http://localhost:2480/api/v1/command/kukakukin --user "root:rootroot"

curl -X POST -H "Content-Type: application/json" \
  -d '{"command": "MATCH (a),(b) WHERE a.label = \"First\" AND b.label = \"Second\" RETURN a,b", "language": "cypher", "serializer": "graph"}' \
   http://localhost:2480/api/v1/command/kukakukin --user "root:rootroot"

result:
{"result":{"vertices":[],"records":[],"edges":[]},"user":"root","version":"22.1.3 (build 440ab28fffef33b043815beebe78fb7e65a0a664/1643746379060/main)"}

@artturimatias

@artturimatias I created this test case and works:

@Test
public void testIssue314() throws ExecutionException, InterruptedException {
  final ArcadeGraph graph = ArcadeGraph.open("./target/testcypher");
  try {

    graph.getDatabase().getSchema().getOrCreateVertexType("Person");

    ResultSet p1 = graph.cypher("CREATE (p:Person {label:\"First\"}) return p").execute();
    Assertions.assertTrue(p1.hasNext());
    RID p1RID = p1.next().getIdentity().get();

    ResultSet p2 = graph.cypher("CREATE (p:Person {label:\"Second\"}) return p").execute();
    Assertions.assertTrue(p2.hasNext());
    RID p2RID = p2.next().getIdentity().get();

    final ArcadeCypher query = graph.cypher("MATCH (a),(b) WHERE a.label = \"First\" AND b.label = \"Second\" RETURN a,b");
    final ResultSet result = query.execute();

    Assertions.assertTrue(result.hasNext());
    final Result row = result.next();
    Assertions.assertNotNull(row.getProperty("a"));
    Assertions.assertEquals(p1RID, ((Result) row.getProperty("a")).getIdentity().get());
    Assertions.assertNotNull(row.getProperty("b"));
    Assertions.assertEquals(p2RID, ((Result) row.getProperty("b")).getIdentity().get());

  } finally {
    graph.drop();
  }
}

I guess it must be in the HTTP layer. Checking it.

The issue seems in the serializer. If you omit the serializer = graph works. This is a nice workaround for now, looking for the cause.

This also explains why visualiser in ArcadeDb Studio does not work with Cypher queries.

Fixed issue with cypher resultsets

Fixed in the main branch, it will be released with 22.2.1.

chore(deps): bump https://github.com/macisamuele/language-formatters-…

Fixed issue with cypher resultsets

chore(deps): bump https://github.com/macisamuele/language-formatters-…

chore(deps): bump the github-actions group across 1 directory with 8 …

Navigation Menu

Repository navigation

Cypher queries broken in 22.1.3 #314

ArcadeDB Version: 22.1.3

JDK Version: what is included in official docker image

OS: Debian 11

Expected behavior

Actual behavior

Steps to reproduce

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Cypher queries broken in 22.1.3 #314

Description

ArcadeDB Version: 22.1.3

JDK Version: what is included in official docker image

OS: Debian 11

Expected behavior

Actual behavior

Steps to reproduce

Activity

lvca commented on Feb 4, 2022

lvca commented on Feb 4, 2022

lvca commented on Feb 4, 2022

artturimatias commented on Feb 4, 2022

lvca commented on Feb 4, 2022

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions