Search in Data tab cannot be interrupted

[expired user #10323]'s profile image [expired user #10323] posted 7 years ago in General Permalink

When clicking on the Data tab of a table, a query is made automatically, with the last entered filter condition. The filter condition may contain predicates which will result in a long running query. There is no way to interrupt the query of the Data tab (the usual button is grayed out). Once predicates were entered, which result in long running query, you end up in a loophole: First, you wait a little, then kill HeidiSQL, then want to rectify the bad predicates by clicking the Data tab, then wait a little, then kill HeidiSQL, …

HeidiSQL should offer to interrupt the query of the Data tab and/or a setting to disable automated search when clicking the Data tab.

ansgar's profile image ansgar posted 7 years ago Permalink

Before you activate the Data tab, you can rightclick the table in the database tree, then click "Clear data tab filter".

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