Skip to content

Autocomplete GraphQL query returns empty proposals randomly #3689

@leonardoflores-shiphero

Description

Description

When using autocomplete in CloudBeaver with a Redshift Serverless connection, sometimes the GraphQL query sqlCompletionProposals returns valid results, and other times it returns an empty list, even for the same query and position.

Steps to reproduce

1 - Connect to Redshift Serverless.
2 - Open SQL Editor and copy/paste a query such as:

SELECT p.
FROM events.public.products p
INNER JOIN app_core.bins b
  ON p.attributes.location_id = b.id
WHERE p.event = 'picked'
  AND p.warehouse_id = 61516

3 - Trigger autocomplete after typing p. or b. in SELECT clause (do this a few times to trigger several requests)
4 - Inspect the GraphQL request querySqlCompletionProposals.

Expected/Desired Behavior

Expected behavior

Autocomplete should consistently return column suggestions for the given table alias.

Actual Behavior

Sometimes works → response contains a full list of proposals (columns like id, account_id, warehouse_id, etc.).

Sometimes fails → response contains an empty list of proposals:

{
  "data": {
    "proposals": []
  }
}

Additional Information

Database: Redshift Serverless
Issue reproduces randomly, not tied to a specific alias or query.
Example queries and GraphQL requests attached below.

Examples:
querySqlCompletitionProposals_examples.json

CloudBeaver Version

CloudBeaver AWS Server - 25.1.0.202506100925

Additional context

Query manager database/URL: jdbc:postgresql://127.0.0.1:5432/cloudbeaver
Product name: CloudBeaver AWS Server
Security manager database/URL: jdbc:postgresql://127.0.0.1:5432/cloudbeaver
Query manager database/Driver: postgres-jdbc
Product version: 25.1.0.202506100925
Security manager database/Driver: postgres-jdbc
Query manager database/Product name: PostgreSQL
Security manager database/Product name: PostgreSQL
Query manager database/Product version: 16.8 (Debian 16.8-1.pgdg120+1)
Security manager database/Product version: 16.8 (Debian 16.8-1.pgdg120+1)
OS: Linux 6.8.0-1029-aws (amd64)
Memory available: 80Mb/1936Mb
Java version: 21.0.7 by Eclipse Adoptium (64bit)
JVM parameters: server/plugins/org.jkiss.dbeaver.launcher_1.0.30.202506100925.jar -product io.cloudbeaver.product.aws.product -data -web-config conf/cloudbeaver.conf -nl en -registryMultiLanguage
Deployment type: DOCKER
Install path: /opt/cloudbeaver/server
Workspace path: file:/opt/cloudbeaver/workspace/

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions