how to lock column head buttons

KBfriend's profile image KBfriend posted 2 years ago in General Permalink

I clicked a column head in the data tab by mistake, and it run a 'sort by' query.
The table had more than 80M rows, so it leaded to service degradation.
Is there a way to lock column head buttons?

ansgar's profile image ansgar posted 2 years ago Permalink

No, there is no way to block that. But it could make sense to make that configurable, as the sorting dialog still provides a way to do the same. Just without the risk of doing it accidentally:

Description

Code modification/commit 7bea342 from Ansgar Becker <anse@heidisql.com>, 2 years ago, revision 12.2.0.6586
Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026
ansgar's profile image ansgar posted 2 years ago Permalink

Next build has such an option to disable header clicks:

Description

Please login to leave a reply, or register at first.