starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 13:46:02 +03:00

[GH-ISSUE #3689] Autocomplete GraphQL query returns empty proposals randomly #1298

New issue

Closed

opened 2026-03-07 21:02:11 +03:00 by kerem · 7 comments

kerem commented

2026-03-07 21:02:11 +03:00

Owner

Originally created by @leonardoflores-shiphero on GitHub (Aug 21, 2025).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/3689

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/

Originally created by @leonardoflores-shiphero on GitHub (Aug 21, 2025). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/3689 ### 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: ```sql 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: ```json { "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](https://github.com/user-attachments/files/21922307/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/

kerem

2026-03-07 21:02:11 +03:00

closed this issue
added the
xf:sql editor

wait for response
labels

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Aug 25, 2025):

Hi @leonardoflores-shiphero
Thank you for the detailed description 💙
This is a cursor position issue.

You can try to switch on a semantic completion engine. It provides more accurate suggestions, while the current one is mostly based on the position in a query.

Main menu → Preferences → SQL editor → Completion engine

If you prefer current (legacy) engine, as a workaround, you can retype the last symbol (dot in your case) - this will resend the request with the correct position and you'll get a list of proposals.

Please let us know if you experience the same unwanted behavior on semantic engine.

@EvgeniaBzzz commented on GitHub (Aug 25, 2025): Hi @leonardoflores-shiphero Thank you for the detailed description 💙 This is a cursor position issue. You can try to switch on a **semantic completion engine**. It provides more accurate suggestions, while the current one is mostly based on the position in a query. > Main menu → Preferences → SQL editor → Completion engine If you prefer current (legacy) engine, as a workaround, you can retype the last symbol (dot in your case) - this will resend the request with the correct position and you'll get a list of proposals. Please let us know if you experience the same unwanted behavior on semantic engine.

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@leonardoflores-shiphero commented on GitHub (Aug 25, 2025):

Hi @EvgeniaBzzz ,

Thank you for your reply.

Can I do this in CloudBeaver AWS? I wasn’t able to find this configuration in the administration panel or in my profile settings.

Maybe it’s stored in a JSON file inside the container, but I’m not sure where to find it.

@leonardoflores-shiphero commented on GitHub (Aug 25, 2025): Hi @EvgeniaBzzz , Thank you for your reply. Can I do this in CloudBeaver AWS? I wasn’t able to find this configuration in the administration panel or in my profile settings. <img width="926" height="579" alt="Image" src="https://github.com/user-attachments/assets/f3cf0c23-48e6-4254-890b-3ad793ea5b29" /> <img width="718" height="863" alt="Image" src="https://github.com/user-attachments/assets/e837f1d3-5839-4460-b27a-86c29dea994f" /> Maybe it’s stored in a JSON file inside the container, but I’m not sure where to find it.

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Aug 26, 2025):

Sorry for the confusion 😃
For the AWS product, semantic autocomplete will be available in version 25.2.0, which will be released in two weeks.

@EvgeniaBzzz commented on GitHub (Aug 26, 2025): Sorry for the confusion 😃 For the AWS product, semantic autocomplete will be available in version 25.2.0, which will be released in two weeks.

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Sep 9, 2025):

Hi @leonardoflores-shiphero
Version 25.2.0 with new autocompletion engine is now available. Please check it out and let me know if it'll resolve your problem.

@EvgeniaBzzz commented on GitHub (Sep 9, 2025): Hi @leonardoflores-shiphero Version 25.2.0 with new autocompletion engine is now available. Please check it out and let me know if it'll resolve your problem.

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Oct 16, 2025):

@leonardoflores-shiphero
Any news here?

@EvgeniaBzzz commented on GitHub (Oct 16, 2025): @leonardoflores-shiphero Any news here?

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@leonardoflores-shiphero commented on GitHub (Oct 16, 2025):

Hi @EvgeniaBzzz,
Last week we upgraded to the latest version and everything is working perfectly.
Thank you very much for your support and effort to resolve this issue.
We really appreciate the CloudBeaver team’s quick response and commitment.

@leonardoflores-shiphero commented on GitHub (Oct 16, 2025): Hi @EvgeniaBzzz, Last week we upgraded to the latest version and everything is working perfectly. Thank you very much for your support and effort to resolve this issue. We really appreciate the CloudBeaver team’s quick response and commitment.

kerem commented

2026-03-07 21:02:13 +03:00

Author

Owner

@EvgeniaBzzz commented on GitHub (Oct 16, 2025):

That’s wonderful to hear!
We really appreciate your kind words and are glad everything’s running smoothly now.
Enjoy your DB magic with CloudBeaver! 🦫

@EvgeniaBzzz commented on GitHub (Oct 16, 2025): That’s wonderful to hear! We really appreciate your kind words and are glad everything’s running smoothly now. Enjoy your DB magic with CloudBeaver! 🦫

kerem referenced this issue

2026-03-07 21:08:43 +03:00

[PR #1298] [MERGED] CB-2873 ssh creds saving doesnt work when database creds arent saved #2393