can't understand query error

[apache]

can't understand query error

[emotionbug]

@david-m-m Ok. I'll rechecking it.

[joefagan]

Please supply all the code you used to create the graph including the query that failed, so as to help reproduce the error.

Please confirm AGE extension version with

SELECT extname, extversion FROM pg_extension WHERE extname='age';

It could be an AGViewer but more likely an AGE issue so you may have to ask in a couple of places.
You can email [email protected] or [email protected]
You may have to subscribe to see responses at https://lists.apache.org/[email protected] or https://lists.apache.org/[email protected]

[emotionbug]

Are you use docker?

[david-m-m]

I'm not sure why this has been closed.
Just for completeness here are the steps to reproduce:

1. Run docker containers

$ docker run -it -e POSTGRES_PASSWORD=svcTree --expose 5432 sorrell/apache-age
$ docker run -ti --expose 3001 bitnine/agviewer

Both running latest tag (as of this week, 2021-11-22)

2. Create graph and some data

SELECT * FROM create_graph('test');
SELECT * FROM cypher('test', $$ CREATE (john:Person {name: 'John'}) $$) as (r agtype);
SELECT * FROM cypher('test', $$ CREATE (j:Person {name: 'Jack'}) $$) as (r agtype);
SELECT * from cypher('test', $$ MATCH (a:Person),(b:Person) WHERE a.name='John' AND b.name='Jack' CREATE (a)-[r:Friend]->(b) RETURN type(r) $$) as (r agtype);

3. Open age-viewer in your browser and connect to database and graph
4. Click on "Node Label -> Person" (Query: SELECT * from cypher('test', $$ MATCH (V:Person) RETURN V $$) as (V agtype); )
   This one works and just shows the two nodes (no relation)
5. Click on "Edge Label -> Friend" (Query: SELECT * from cypher('test', $$ MATCH (V)-[R:Friend]-(V2) RETURN V,R,V2 $$) as (V agtype, R agtype, V2 agtype); )
   This one results in the error.
6. Update the relation (set a property):
   SELECT * from cypher('test', $$ MATCH (a:Person)-[r:Friend]->(b:Person) WHERE a.name='John' AND b.name='Jack' SET r.type='close' RETURN r $$) as (r agtype);
7. Click on "Friend" again: Voilà, graph shows including relation.

[david-m-m]

@emotionbug last comment FYI

[emotionbug]

The problem was already solved, but docker didn't update. So, I updated yesterday. Remove any remaining images locally and try again

[david-m-m]

Thanks a lot @emotionbug
The updated Docker image works just fine. 👍