[BUG] Updating the table causes the query to refresh

[brucejxz]

Describe the bug

In Discover, adding, moving or removing fields from the table causes the query to refresh. As does changing the query language.

I don't think this is very intuitive. Let's say you come back to a query you initially performed a few minutes earlier and decide that it would be useful to add another field to the table. The query refreshes, and it's probable that the documents you were looking at before are no longer returned by the refreshed query.

Or let's say you've just started searching and decided there are 4 or 5 columns you want to add to the table. Each column that is added causes a separate query to be sent. This seems wasteful, particularly on a large index.

To Reproduce

1. Go to Discover
2. Add, move and remove columns in the table or change the query language
3. Each of the above actions causes the query to refresh

Expected behavior

The query should not refresh. The user can click refresh if they want that.

OpenSearch Version
2.19.0

Dashboards Version
2.19.0

Plugins

N/A

Screenshots

updating-table-refreshes-query.mp4

Host/Environment (please complete the following information):

• OS: MacOS
• Chrome 133.0.6943.126

Additional context

N/A