-
Notifications
You must be signed in to change notification settings - Fork 464
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/