Unable to update data if the query contains a comment.

[valentintraen]

Description

If you execute a SELECT query containing a comment, it will be impossible to modify the data via the interface (by directly editing a value in one of the result columns).

Steps to reproduce

SELECT yourcolumn FROM yourtable

-> green dot at the top left of your result = you can update the data via the UI

SELECT yourcolumn FROM yourtable #comment

-> yellow dot at the top left of your result = you can't update the data via the UI

Expected/Desired Behavior

No change in behavior when a request contains a comment.

CloudBeaver Version

26.1.1

Additional context

No response

[EvgeniaBzzz]

Hi @valentintraen
Thanks for the report. We'll fix it in one of the further releases.

If I remember correctly, you're using MySQL. As a workaround you can use -- comment or /*comment*/.

[mariiachugunova]

Verified for DBeaver CE Version 26.1.4.202607241441 on Windows 11 pro