HeidiSQL 12.7 with support for descending indexes, filter boxes in table tools, JSONL export, and more

Get it from the download page

3rd party updates:

• Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8
• Update regular expression library to v1.181 2023.11.22, supporting \K pattern to set the begin of a reported match.
• Update InnoSetup compiler to v6.2.2
• Update VirtualTrees component code to release v8.0.3 (major version update)
• Issue #1888: Update plink executables to v0.81
• Update madExcept exception handler to v5.1.4
• Issue #1905: Update OpenSSL libraries used by libpq-15.dll to v3.1.5
• Update SQLite libraries to v3.45.3 from 2024-04-15

New stuff:

• Issue #1879: add drop down menu to "Apply filter" button, with an option to overwrite the current filter based on the different input text
• Issue #1512: add basic support for indexes with descending column direction
• Issue #1429: add "SQL INSERT IGNORE" output format to grid export dialog
• Issue #178: add database and table filter boxes above tree view on table tools dialog
• Issue #1917: Support additional UCA collations introduced in MariaDB 10.10.1.
• Issue #1927: display column comments in completion proposal, give that third column more space to the left and italic style
• Table editor: when user runs into the cryptic "constraint is incorrectly formed" message, append a more meaningful line from SHOW ENGINE INNODB STATUS.
• Support naming result tabs per "-- name: xyz" comment. See https://www.heidisql.com/forum.php?t=10493
• Reorder components in grid export dialog, and convert format radio buttons to combobox. Makes the dialog more wide than high, creating space for wider labels and more format options.
• Issue #1930: Grid export: implement JSON Lines format.
• Issue #139: Alternating row background colors in table columns list and most other main tabs, if activated by user.

Bugfixes and enhancements:

• Enhance readability of focused text in result grid using dark styles. TreeOptions.PaintOptions.toGhostedIfUnfocused grays out text otherwise.
• Fix crash in SynCompletionProposalChange, happening when scrolling very fast to the top of the list
• Fix crash in f_() function with invalid format specifiers from some translation. Happened in Japanese recently.
• Issue #1870: support VARCHAR columns with a length of 0, in temporary fake tables for exporting views
• Detect Windows 11 in about dialog, and remove functions only required for the no longer supported Windows Store version
• Fix activated SSH tunnel for a network type which does not support that, after changing the network type from an explicit SSH-tunnel-type to a TCP/IP version.
• Search replace: ignore numbers in static row id column
• Installer: add newly available translations for Hungarian and Bulgarian
• Add item in Tools main menu for resetting panels to their default dimensions. Useful for quite a few people who move their app window between screens with different resolutions.
• Static row id: always use the color of the session the result belongs to
• Performance: call TimerHostUptimeTimer event every 20 seconds only, instead of each second
• SQL export dialog: cut long file list down to 20 latest items
• Issue #520: Fix crash in sort columns dialog when removing the last column, with a non-default theme
• After reformatting SQL code, unify new lines to Windows line feeds, so the selection's end in SynMemo is correct
• Fix retrieving MySQL events from the current database on older servers, work around MySQL bug 41907. See https://bugs.mysql.com/bug.php?id=41907#c360194
• Make pressed state of favorites button more noticeable, by using the gray-scale icon in unpressed state
• Fix emptied "SHOW WARNINGS" pool due to queried @max_error_count in warning dialog. See https://www.heidisql.com/forum.php?t=41753
• Issue #1899: fix wrong column number on column selector above data grid
• Issue #1906: provide a new preference option to turn on color icons on inactive tabs again
• Issue #1910: Fix CURRENT_TIMESTAMP default text detection as an expression, not as an ordinary string literal, on MySQL 8.0.14+.
• Issue #1887: restore old scroll offset in data grid, when refreshing result or paging to the next rows
• Issue #1918: Remove leading timestamp from log message when copying to new query tab.
• Host tab: use session name as tab caption, and show host name as mouse-over hint. See https://www.heidisql.com/forum.php?t=41399
• Hopefully fix slow loading tabs.
• Issue #1923: Fix completion proposal not showing columns of a table alias when table name contains the word "join".
• Issue #355: Fix non-working scrolling with a horizontal mouse wheel in grids, by preferring TWMScroll.Pos over TScrollInfo.nTrackPos (always 0).
• Add functions-mysql8.ini with some newer functions in it, and search for version specific ini file when connecting. See https://www.heidisql.com/forum.php?t=41892
• Fix too small foreign columns dropdown, scale controls on TSetEditorLink DPI aware
• Issue #1247: Fix invalid SQL code for dropping foreign key constraint in PostgreSQL mode.
• Issue #1586: include "COLLATE xyz" clause when applying collation and user checked the "Convert data" option, so the columns do not get the default collation of the new charset
• Issue #1934: fix empty column list in completion proposal when user input starts with a quote character
• Issue #1933: Update list with known MySQL 8 keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series
• Issue #1939: Fix empty CREATE TABLE code and "List index out of bounds" message in log, due to accessing TTableKey.Collations[x] without being initialized
• Issue #321: Fix SQL code in TTableKey.SQLCode for PostgreSQL
• Issue #1940: In TSecureShellCmd.Connect, include parallel happened errors in any success dialog. Also, log errors to the log panel when both pipes have content.
• Issue #1942: Reset FClipboardHasNull marker before pasting text which was copied outside the application.
• Issue #1943: Set DbTree.DefaultNodeHeight in FormShow rather than in FormCreate, to respect DPI settings.
• Issue #1931: Support CITEXT columns in Postgres and categorize as text type, so these show up in foreign values pulldown editor of data grid.
• Issue #1868: Reset sort order of data tab grid as well, when user clicks "Clear data tab filter".
• Issue #1936: Fix EAbstractError when closing text editor
• Issue #1947: don't change case of detected column names, in CSV parser