agensgraph icon indicating copy to clipboard operation
agensgraph copied to clipboard

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

Open watery opened this issue 3 years ago • 0 comments

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

watery avatar Mar 09 '21 11:03 watery