Autocomplete not working after update connection.

[anilsahoo20]

Please note that security bugs or issues should be reported to [email protected].

Describe the bug

When we update the connection from one database to other database, the autocomplete is not working.

To Reproduce

Steps to reproduce the behavior:

1. Open query tool
2. Type something, autocomplete will work
3. Now update the connection
4. try typing something
5. autocomplete not working

Expected behavior

It should work.

Error message

data: null
errormsg: "Transaction ID not found in the session."
info: "DATAGRID_TRANSACTION_REQUIRED"
result: null
success: 0

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: OSX Ventura
• Version: 8.8
• Mode: Desktop
• Browser (if running in server mode): [e.g. chrome, safari]
• Package type: [e.g. RPM, DEB, Python, Container, etc.]

Additional context

Add any other context about the problem here.

[pravesh-sharma]

Found below issue:

If autocomplete is off and ctrl+space is used to trigger autocomplete it can not be done after updating the connection.
If autocomplete is enabled in that case everything works fine.

[adityatoshniwal]

Hi @pravesh-sharma,
I checked again and API is being called with correct txn id, which was fixed.

[pravesh-sharma]

Hi @pravesh-sharma, I checked again and API is being called with correct txn id, which was fixed.

Okay. What I mentioned seems to be another issue will create a separate one for it.

[pravesh-sharma]

Issue fixed. Tested on snapshot build.

Env:
OS - macOS Sonoma 14.5
Mode - Desktop