Skip to content

AgensGraph crashes on list comprehension with sum() inside expression #793

@zihaozeng0021

Description

@zihaozeng0021

Configuration

AgensGraph Version: bitnine/agensgraph:latest (pulled 2025-12-27)

Operating System: WSL2 – Ubuntu 24.04.1 LTS

Installation Method: Docker (bitnine/agensgraph:latest)


Steps to reproduce

  1. Start AgensGraph via Docker
docker run -d \
  --name agensgraph \
  -p 5432:5432 \
  -e POSTGRES_PASSWORD=agensgraph \
  bitnine/agensgraph:latest
  1. Connect with psql
docker exec -it agensgraph psql -U postgres
  1. Run the following query

Set up

CREATE GRAPH test;

SET graph_path = test;

The buggy query:

postgres=# RETURN [x IN [1,2,3] | sum(x)];
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!?>

Expected behaviour

The server should not terminate. It should either:

  • return a valid result, or
  • return a clean syntax/semantic error (e.g., “aggregations not allowed here”), without dropping the connection.

Actual behaviour

psql loses the connection because the server terminates while processing the quer

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions