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