Recent Filter Bug?

ghoppermaster's profile image ghoppermaster posted 8 years ago in General Permalink

Hi,

Thanks once again for your efforts!

Just noticed that HeidiSQL seems to hang/crash under the following circumstance:

(Let's imagine a simple table of 'Users' with columns: 'userId, companyId, email')

  1. Select the 'Users' table then select the 'Data' tab.
  2. Filter the table by the 'companyId' column.
  3. Delete the 'companyId' column.
  4. Select another table then reselect 'Users' table.
  5. It seems* to want to use the recent filter that contains the now missing column 'companyId' and the application hangs. Have to restart application. Same thing happens after restart.
  6. Solve the issue by adding the 'companyId' column back in and creating a new filter without 'companyId' ... then delete 'companyId'.

I tried looking for a 'clear filters' button but didn't see anything obvious, apologies if I missed something glaringly obvious! I'm new to HeidiSQL so just finding my way around coming from MS SQL Server Management Studio environment.

If there isn't a clear filters function, perhaps they can be cleared when the table schema changes? I don't know if that's too drastic of a 'catch all', but will leave it to your expert hands.

Thanks for your time, please let me know if I can help with more information.

ansgar's profile image ansgar posted 8 years ago Permalink

See this thread for a description of how to disable a filter before using the data tab.

ghoppermaster's profile image ghoppermaster posted 8 years ago Permalink

Hi,

Thanks for your fast response and patience with a new user.

Cheers! :)

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