HeidiSQL 12.11 with vector support on MariaDB, and quick action "Select top 1000 rows"

Get it from the download page

3rd party updates:

• Update plink executables to v0.83. See https://www.chiark.greenend.org.uk/~sgtatham/putty/
• Update MariaDB Connector/C to v3.4.5. See https://mariadb.com/kb/en/mariadb-connector-c-3-4-5-release-notes/
• Update SQLite libraries to v3.50.1. See https://www.sqlite.org/
• Update SQLite multiple cipher libraries to v2.1.3. See https://github.com/utelle/SQLite3MultipleCiphers/releases/

New stuff:

• Issue #604: add context menu item "Select top 1000 rows"
• Issue #2175: if asShowRowId option is enabled, show also the index of columns in their header, through the OnAdvancedHeaderDraw/ownerdraw event
• Issue #2168: select rows from table to export by its primary key columns, so PostgreSQL does not apply a random sorting
• Issue #2155: paint session background and icon in session drop-down of SQL export dialog
• Issue #2107: add "invert check" menu item on table tools tree
• Issue #2068: support MariaDB's new VECTOR index in table designer, without M and DISTANCE settings yet
• Issue #2068: support MariaDB's new VECTOR data type in table designer, categorize as binary
• Issue #2083: add menu item "Copy all lines" for copying visible and initialized nodes from any VirtualTree instance as CSV data
• Issue #1975: add "keep asking" checkbox to reformat dialog
• Issue #646: forget setting for "Favorite objects only" on each connection start
• Issue #2064: support UTF-8 BOM encoding when loading and saving editor files

Bugfixes and enhancements:

• Issue #1253: fix index creation on PostgreSQL tables, use separate CREATE INDEX queries
• Issue #2187: Fixed EAccessViolation when closing editor while using non-default theme
• Create helper table with the servers' default engine when exporting a view. See https://www.heidisql.com/forum.php?t=44125
• Issue #2186: fix wrong number of rows shown in grid export dialog when post filter is active
• Issue #2118: activate legacy-stdio-prompts mode in plink SSH tunnel, to fix non prompted passphrase since plink 0.82
• Issue #604: sync number of rows to query with the per-page data grid setting
• Issue #604: support multiple tables and views selected on database tab, in new "Select top 1000 rows" feature
• Issue #2172: fix wrong comment
• Issue #2172: prompt for password again, when connection has timeout or broke
• Issue #2159: fix memory leak
• Issue #2159: SQLite: export separated table indexes, and export views and triggers
• Issue #2168: turn off synchronize_seqscans variable in PostgreSQL mode, to be sure SELECT's show a stable row sorting. See https://www.postgresql.org/docs/8.3/runtime-config-compatible.html#GUC-SYNCHRONIZE-SEQSCANS
• Issue #1853: try to fix column definition changes on MS SQL wrt collation quoting and default value
• Issue #2155: high DPI fix for painting icons in SQL export target drop-down
• Issue #2156: unescape generated column expression when loading from IS.COLUMNS
• Keep retrieving exact row count on data tab header after activated via context menu, until another table has focus
• Display number or rows in data tab header for views. See https://www.heidisql.com/forum.php?t=44057
• Issue #214: when refreshing, ask user if he wants to discard modifications in table/view/routine/... editors
• Prefer Boolean over Bool type in owned code
• Issue #2139: fix missing AND's in REQUIRE clause, and move REQUIRE clause from GRANT to ALTER USER query, as MySQL does not support that in GRANT since v8.x
• Issue #2133: revert broken characters and encoding of apphelpers unit
• implementation of Unicode logic for password encryption
• Issue #2132: fix crash when saving an sql file previously loaded with auto-detected encoding
• Issue #2123: prevent crash in libpq when disconnecting an already disconnected connection
• Issue #2128: fix wrong encoding of connection string for PQconnectdb()
• Issue #2123: fix reconnect mechanism in TPGConnection.Ping()
• Issue #2119: optimize calculation of status bar panel widths
• Issue #1986: do not set CLIENT_SSL flag with libmariadb, which seems to cause a "bad handshake" in mysql_real_connect()
• Issue #2103: fix latin1 charset used with libmysql v8.x which reports "utf8mb4" by mysql_character_set_name()
• Issue #2101: attempt to reactivate progress bar in status bar when running through Wine, now with a safety check for IsWindow()
• Update default functions-mysql.ini with predefined line breaks and much more help content
• Update functions-mysql8.ini with predefined line breaks and much more help content
• Enable padding in multiline tooltips with a derived THintWindow class
• Reduce web page openings to once after successful nightly update
• Wrap long lines in data type hints. See https://www.heidisql.com/forum.php?t=43881
• Simplify and optimize functions generator for MariaDB, and update functions-mariadb.ini with predefined line breaks
• Issue #2095: fix wrong/no control characters used when changing format to Excel csv via file-save dialog
• Issue #2083: use empty field delimiter and tab separator for new copy-lines feature
• Issue #2085: tell TStringStream.Create not to free its TEncoding object after usage, as we use application-lifetime-available encoding instances
• Issue #2084: show numeric values in variables tab locally formatted in a tooltip
• Show type of exception happening through AppSettings.ExportSettings
• Issue #835: move prompt for overwriting output file from save-dialog to later when exporting is started, catching cases where the previous filename is used
• Issue #2079: work with the "default" set of SQLite encryption parameters, not the transient ones
• Prevent connection activity through hovering table token while user query is running. Similar to issue #278