search

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.33k stars 148 forks source link

[AgensBrowser] [undefined] Internal Server Error on cypher query but works from CLI #529

Open watery opened 3 years ago

watery commented 3 years ago

The query

match (p:source)-[r*2..2]->(s:source_type) return *

produces [undefined] Internal Server Error in AgensBrowser, while on the CLI client it works:

postgres=# match (p:source)-[r*2..2]->(s:source_type) return *;
                      p                      |                           r                           |                     s
---------------------------------------------+-------------------------------------------------------+--------------------------------------------
 source[13.4]{"name": "client-products-ecc"} | [type[14.3][13.4,10.5]{},depends[12.1][10.5,10.1]{}]  | source_type[10.1]{"name": "clients-list"}
 source[13.4]{"name": "client-products-ecc"} | [type[14.3][13.4,10.5]{},depends[12.2][10.5,10.2]{}]  | source_type[10.2]{"name": "products-list"}
 source[13.5]{"name": "products-crm"}        | [type[14.4][13.5,10.3]{},depends[12.11][10.3,10.2]{}] | source_type[10.2]{"name": "products-list"}
(3 rows)

The issue seems to be related to the edges, because asking to return vertexes only doesn't give any error (but of course no relation between nodes is shown in the browser):

match (p:source)-[r*2..2]->(s:source_type)

AgensBrowser 1.0 using sorrell/agensbrowser-alpine Docker image.

AgensGraph 2.1.3 using turicas/agensgraph-docker Docker Image