HeidiSQL/HeidiSQL 12.6

on GitHub

Get it from the download page

3rd party updates:

• Update madExcept exception handler to v5.1.3
• Upgrading to Delphi compiler version 11.3
• Update VirtualTrees component code to release v7.6.5a
• Update vcl-styles-utils from current master branch
• Update SQLite libraries to v3.44.0
• Issue #1841: Update OpenSSL libraries used by libpq-15.dll to v3.1.3
• Update plink executables to v0.79

New stuff:

• Issue #861: New static row id column in all result grids. Uses the session background color, and can be hidden. (see screenshot)
• Issue #750: SQL formatting now with 2 new online formatters: (see screenshot)
  • https://github.com/doctrine/sql-formatter - hosted on heidisql.com
  • https://sqlformat.org/ - Thanks to Andi Albrecht!
• Add context menu on data grid header with "Query exact row count" item, querying SELECT COUNT(*)... on the underlying table
• Support main tabs in a single line, and support tab-scrolling per mouse wheel
• Issue #940: Support removing shortcuts per button in preferences. (see screenshot)
• Issue #1619: Use the same hotkey (Ctrl+S) for saving a table/trigger/... as for saving a query file.

Bugfixes and enhancements:

• Issue #1863: Fixes compatibility to Wine v8.18 again, and probably to more versions
• Grayscale icons on non-active tabs, for a clearer user interface (see screenshot)
• Separate double-click and middle-click options for closing tabs (see screenshot)
• Issue #1795: remove menu items and code for explain analyzer on https://mariadb.org, which is no longer available
• Issue #1854: fixes incorrect table name used in grid updates when comment with valid query exists
• Issue #279: Support serial columns in PosgreSQL, which is different from auto_increment on MySQL
• Issue #872: fix crash when opening a table with columns defined as INVISIBLE, and ensure such columns are selected and visible in the data grid
• Translation fixes: remove various unused strings, fix some wrong spelled strings, add some missing strings
• Issue #1850: too short text in popup text editor, when field contains high UTF-8 characters like emojis
• Add missing PMYSQL_LENGTHS type, and use this for the result of mysql_fetch_lengths(). Fixes an issue broken since 2009 (!)
• Issue #1640: Fix crash in MouseUp event of query tab close button, by closing/freeing the tab and button through a timer event
• Issue #752: Fix SQL export on MySQL 8, overwriting view helper tables caused "xyz is not view"
• Keyboard shortcuts: allow the user to accept duplicate assignments per ignore button. (see screenshot)
• Issue #1826: Fix ON UPDATE part of DEFAULT clause with no parentheses on MySQL 8, which are required only for the initial DEFAULT value.
• Fixes numerous different crashes, found in uploaded crash reports. Thanks to all users reporting these:
  • Fix crash after following a foreign key value
  • Fix sporadic crash "Cannot make a visible window modal" in search/replace dialog
  • Fix crash in various places where we just try to get the current clipboard text
  • CSV scanner: fix crash when selected filename cannot be opened
  • Fix sporadic crashes in various calls to [TWinControl].SetFocus, with the new class helper .TrySetFocus
  • Fix crash in highlighter customizer, as long as no attribute is selected
  • Silence a popular crash in DBtreeFocusChanged, when trying to detect whether the user clicked into a different session
  • Fix EAccessViolation in TMainForm.DBtreeFocusChanged:124
  • Fix crash when trying to stop current query and the helper connection cannot connect for some reason.
  • Silence sporadic EAccessViolation in DBtreeBeforeCellPaint, when reading DbObj.Connection.Parameters
  • Fix EAccessViolation in TDBObject.GetImageIndex:6
  • Fix EAccessViolation in TMainForm.DBtreeGetText:12
  • Catch different EInOutError exception happening in rare cases of ForceDirectories()
  • Fix EAccessViolation in TMainForm.AnyGridGetText:5
  • Fix crash when user clicks Help button on maintenance dialog, in a non-MySQL session
  • Catch additional EReadError crash in RunQueryFile
  • Fix crash in printer dialog, when printer is somehow not available
  • Fix crash after reconnect, when query helpers functions are exapanded
  • MSSQL: Catch OLE exception when provider names cannot be listed
  • Fix crash in TMainForm.DBtreeGetText happening while connecting through SSH tunnel
  • Fix sporadic crash with focused Host tab while connecting to another session
  • Warn the user about potential data loss when loading a (csv) file with encoding set to "auto-detect".

Full Changelog: 12.5...12.6