ArcadeDB Version: ArcadeDB Server v23.1.1 (build aa687e4/1673895089679/main)

JDK Version: OpenJDK (zsrc11.54.25-jdk11.0.14.1) [I think]

OS: Windows 11 Home (21H2)

Expected behavior

Running queries creates new nodes.

Actual behavior

Running CREATE queries doesn't create new nodes BUT does correctly update the schema (checked through the web Arcade Studio).

Related behaviour

• Inside my project, read queries work and correctly show output
• In Arcade Studio, CREATE queries work

Steps to reproduce

Requirements

1. Have a golang project
2. Run ArcadeDB with the Postgres plug-in
3. Have a graph database called test
4. Install the pq package referenced in the ArcadeDB docs

Steps

1. Open new database connection newDb, err := sql.Open("postgres", "user=root password=xxx dbname=test sslmode=disable")
2. Type your write cypher script cypher := "{cypher} CREATE (n:Foo) RETURN n;"
3. Run the query newDb.Exec(cypher) or newDb.Query(cypher)

Further notes

Maybe this is something simple like enclosing the queries in transactions or comiting? However, I also tried:

1. Running a :commit query after, did not change anything
2. Suffixing :commit to the query itself, did not change anything
3. Trying to run newDb.Begin() fails because of some weird error. I guess this is because somehow that doesn't work with cypher queries or a graph database?