12.9
Get it from the download page
3rd party updates:
- Upgrade to Delphi 12.1 compiler
- PostgreSQL: Add libpq-17.dll v17.0.2
- Issue #2022: Update libpq-15.dll to v15.0.10
- Issue #2022: Update OpenSSL libraries used by libpq-15.dll to v3.4.0 (64 bit only), taken from https://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries
- Issue #2022: PostgreSQL: update OpenSSL libraries to v1.1.1s, taken from https://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries
- Update SQLite libraries to v3.48.0.0, and SQLite multiple cipher libraries to v2.0.2.0
- Update libmariadb and plugins to current GA release v3.4.3
- Issue #2036: update vcl-styles-utils code to their current master branch state
- Update style file from Delphi 12.1. Related to https://www.heidisql.com/forum.php?t=43616
New stuff:
- Show editor hints for string literals, revealing their character length
- Show editor hints for routine tokens, with routine parameters, comment and body
- Show table columns with datatype in table token hint (screenshot)
- Issue #872: add support for creating and altering INVISIBLE columns in table editor with MariaDB 10.3.3 and MySQL 8.0.23 (screenshot)
- Issue #2066: support MSOLEDBSQL ADO providers with version postfix for MS SQL (screenshot)
- Issue #1975: add preference option to skip dialog for selecting the SQL reformatter (screenshot)
- Issue #1777: basic support for function key parts in MySQL 8.0+ (screenshot)
- Show editor hints for SQL functions, data types, tables and procedures when mouse hovers a token
- Show function description text in hint panel when using the completion proposal
- Issue #2046: support 4 different SSL verification levels on PostgreSQL
- Issue #2035: support new REPLICA MONITOR admin privilege on MariaDB 10.5.9+
- Issue #2009: basic implementation of a data generation tool, in table tools dialog (screenshot)
- Issue #2004: load and display SQLite triggers in database tree and tab
- Issue #619: support spatial columns with an SRID in table editor, on MySQL 8.0+ (screenshot)
- CSV import: add checkbox option for keeping dialog open after successful import, so the user may process multiple files with less clicks (screenshot)
Bugfixes and enhancements:
- Fix incompatible parameters for OnDragDrop event on some VirtualTree's
- Code readability: use named constants for column indexes on table editor
- Issue #1777: indicate functional key part in table editor with a different icon
- Issue #2071:
- drop 32bit mode from installer
- update copyright year in license file
- #1296: remove VC redistributable package (will be replaced by a note on the download page)
- Issue #2071: provide 3 new languages by InnoSetup installer
- Fix non-painted pasted columns in table editor
- Issue #2063 and #2002: repaint database tree after filtering
- Issue #2035: rename REPLICA MONITOR privilege to SLAVE MONITOR, which seems to be the preferred name in MariaDB
- Issue #2003: set no column for auto-sizing, in foreign key list
- Issue #2038: fix empty preview panel on first click in image blob
- Issue #2050: Add new line at end to support comments at the end of a view definition
- Issue #2058: create a more complete functions-postgresql.ini from the documentation on postgresql.org
- Put key icons besides column names in completion proposal
- Issue #2051: fix unused column default value when creating a new grid row, if that default value is a simple integer expression
- Issue #2024: fix slow grid export
- TMySQLConnection.SetOption: find defined name of option constant per RTTI and show it in error message (when setting failed)
- Issue #1426 and issue #1768: minor: do not try to set MARIADB_OPT_TLS_VERSION option with libmysql
- Issue #1426 and issue #1768:
- fix value of MYSQL_OPT_SSL_VERIFY_SERVER_CERT constant, hopefully fixing SEC_E_ALGORITHM_MISMATCH with libmariadb
- disable MYSQL_OPT_SSL_VERIFY_SERVER_CERT if SSL checkbox is not checked, required since libmariadb C Connector 3.4.0
- show colored warnings in log panel for each failing mysql_options() call
- Issue #2041: categorize PostgreSQL's MONEY type from floats into text types, to fix exports and editing localized values including a currency symbol
- Issue #1253: minor code simplification and inline documentation
- Issue #2040: fix new crash through accessing non existent ActiveGrid
- Issue #1253: fix queries for dropping primary or unique key in PG tables
- Issue #2040: when closing a query tab, cancel cell editor if active, preventing crash
- Table editor: fix crash happening through clear indexes button
- Issue #1981: increase contrast for colored text in privilege tree with dark styles
- Attempt to fix DLL hijacking issue with DWrite.dll per manifest
- Issue #2036: disable clickable anchors in message dialogs when current style is dark, to work around unreadable text
- Issue #1992: Escape ampersand in caption of menus and tabs, preventing underlined hotkey generation for names of session, database and tables
- Issue #2031: Cast MySQL's JSON type columns to literals in WHERE clause of grid UPDATEs and DELETEs. Similar to PostgreSQL's colName::text / issue #769
- Issue #922: remove milliseconds from exported date/time values in Excel mode
- Issue #278: prevent connection activity through hovering status bar while a query is running
- Issue #1965: remove unused variable
- Issue #321: leave away name of indexes when creating a table on PostgreSQL
- Issue #2000: disable multiline feature in grids, even when setting "Lines of text in grid rows" is larger than 1. Aims to fix laggy performance in grid with large contents.
- Enable loading first part of JSON columns in grid, enhancing scroll performance
- Issue #2014: code refactor: move ParseSSLSettings into TUser class
- Issue #2014: user manager: parse SSL settings from SHOW CREATE USER, but also keep parsing SHOW GRANTS for backward compatibility
- Issue #2011: pre-select a reasonable collation if the servers default collation is not set or not yet supported by Heidi
- Issue #1907: fix missing assignments in TDBObject.Assign, causing a default AvgRowLen of -1 which slows down the SQL export
- Code cleanup: Make use of TDBConnection.Has(TFeatureOrRequirement) in more MySQL related code
- Issue #2007 and issue #1965: use the previous RowsAffected value after ShowWarnings in grid update
- Issue #2006: enhance foreign key combo editor in grid for long item text, so the items show a hint in mouse-over
- About box: show Delphi version behind compiled date
- Issue #1998: fix non-scaled title text font in completion proposal
- Issue #1991: check if left part of table name up to a dot lives in the database list. If not, assume it is part of the table name.
- CSV import: set default folder and filename in open-file-dialog to the one of the selected file
- Issue #1984: fix undefined and wrong result of TMySQLQuery.TableName when using a table alias
- Move mostly empty log message to debug level
- Issue #2000: restore partly disabled support for multi lined grid rows
- Issue #2070: clear grid selection when jumping to next search result
- Issue #1874: fix using "UnknownTable" when copying PostgreSQL rows in data tab
- Set hint font from underlying SQL editor, to apply a better formatting
- Issue #2053: add debug log lines in all places where a sorting is created or restored
- Issue #2063 and #2002: repaint database tree after filtering
- Fix Delphi error message saying SynEdit's OnDropFiles declaration has an incompatible parameter list