Runs on macOS 13 Ventura and later.
Credential profiles: one saved login shared by any number of connections.
Import RDS instances and Aurora clusters from AWS as connections.
Updates download in the background and install when you quit.
A rebuilt welcome window with Favorites, Recent, nested groups and drag and drop.
Find and Replace in the SQL editor, a Run button with more ways to run, and partitions in the sidebar.
Added
- Delete for a Kafka topic, and
DROP TOPICin the Kafka query editor. (#2899 by @datlechin) - Delete for a DynamoDB table. (#2899 by @datlechin)
- Credential profiles, one username and password shared by any number of connections. (#2853, #2876 by @datlechin)
- Profiles pane in Settings, listing credential profiles and SSH servers with how many connections use each. (#2876 by @datlechin)
- Credentials picker on a connection's Authentication section, with Save These as a Profile…. (#2876 by @datlechin)
- Credential Profiles toggle in Settings > Sync, and credential profiles in exported connection bundles. (#2879 by @datlechin)
- Download and install updates automatically in Settings > General. (#2865 by @datlechin)
- Last checked beside Check for Updates… in Settings > General. (#2865 by @datlechin)
- A line on the welcome window naming the version TablePro updated from, with a link to what changed. (#2816 by @datlechin)
- What's New window, from Help > What's New and from Settings > General. (#2865 by @datlechin)
- Update install mode and check frequency in the anonymous usage heartbeat. (#2816 by @datlechin)
- SQL Server alias, table and CLR types in the sidebar's Types section, each with a rebuilt
CREATE TYPEstatement. (#2856 by @datlechin) - OceanBase MySQL-mode connection type on the MySQL driver. (#1748, #2741 by @J2TeamNNL)
- Server mode for a SQLite Remote Database File, editing a database on an SSH server in place. (#2831, #2835 by @datlechin)
- System Databases and Schemas for the sidebar tree, in View Options and Settings > General. (#2832, #2834 by @datlechin)
- Partitions nested under their parent table in the sidebar, with the bound and a count on the parent. (#2523, #2937 by @datlechin)
- Partitions for the sidebar tree, in View Options and Settings > General. (#2523, #2937 by @datlechin)
- Partitions for MySQL, MariaDB and Oracle tables, which were listed nowhere before. (#2523, #2937 by @datlechin)
- Favorites, Recent, sorting, drag and drop into groups, inline rename and tag search in the welcome window. (#2849 by @datlechin)
- File > New Group…, File > Rename and View > Sort Connections By for the welcome window. (#2849 by @datlechin)
- Favorites, Recent, nested groups, sorting and tag search tokens in the iOS connection list. (#2849 by @datlechin)
- File > Import > Import from AWS… for RDS instances and Aurora clusters, imported as connections. (#2852, #2857 by @datlechin)
- Per-table row filter, with an optional separate target filter, and row limit in data Compare & Sync. (#2537, #2854 by @datlechin)
- Row grid for data Compare & Sync with every column shown and each differing value marked. (#2537, #2854 by @datlechin)
- Acknowledgements entries for the four tree-sitter grammars the SQL editor ships. (#2878 by @datlechin)
- Edit > Find > Find and Replace… (
Cmd+Option+F) and Use Selection for Find (Cmd+E) in the SQL editor. (#2893 by @datlechin) - Run split button in the query editor with Run All Statements, Run Without Limit, Clear Query and Clear Results. (#2892 by @datlechin)
- Stop in the query editor while a query is running. (#2892 by @datlechin)
- Query > Clear Query and Query > Clear Results. (#2892 by @datlechin)
- Result chooser in the status bar, naming the result on screen and offering Pin, Unpin, Close and Close Others. (#2892 by @datlechin)
- A reason on a dimmed Run, Explain, Format or Favorite saying why it cannot run. (#2892 by @datlechin)
- Formatted JSON inspection and per-element editing for PostgreSQL
jsonb[]andjson[]columns. (#2897, #2903 by @datlechin) - New Schema… and Edit Schema… for PostgreSQL, with owner, comment, privileges and a statement preview. (#2908, #2917 by @datlechin)
- Array element editor in the row inspector. (#2903 by @datlechin)
- Keyword case in Settings > Editor: completed keywords and functions follow the case you type. (#2833, #2902 by @datlechin)
- View > Focus submenu: Object List
Ctrl+Option+Cmd+L, Editor+E, Results+R, Inspector+I, Assistant+A. (#2904, #2916 by @datlechin) - Network Encryption on the Oracle connection form, matching
SQLNET.ENCRYPTION_CLIENT. (#2919, #2935 by @datlechin) - No Database Selected in the sidebar for a MySQL, MariaDB, TiDB or OceanBase connection with no database open. (#2950 by @datlechin)
- Favorite databases synced through iCloud.
Changed
- Pairing approval in a window of its own when no window can host it as a sheet. (#2933 by @datlechin)
- System disclosure chevron on the row inspector's value and default menus. (#2928 by @datlechin)
- Minimum macOS lowered to 13.0 (Ventura). (#2874 by @datlechin)
- Toggle Filters on
Cmd+Shift+F, leavingCmd+Option+Fto Find and Replace. (#2893 by @datlechin) - The editor's find panel keeps the mode it was left in instead of reverting to Find each time it opens. (#2893 by @datlechin)
- Duplicate Connection shares a linked credential profile instead of copying its password. (#2876 by @datlechin)
- Zoom In and Zoom Out (
Cmd+=,Cmd+-) in place of Increase and Decrease Text Size, zooming diagrams too. (#2847 by @datlechin) - Updates download in the background and install when you quit, instead of asking each time. (#2813 by @datlechin)
- New versions roll out over 36 hours instead of reaching everyone at once. (#2815 by @datlechin)
- A scheduled update renames Check for Updates… to Update Available… instead of interrupting. (#2865 by @datlechin)
- The update window shows the release highlights, with the full changelog one click away. (#2815 by @datlechin)
- Data grid top row held across a refresh, matched by primary key. (#2825 by @datlechin)
- Data grid scroll reset to the first row on sort, filter and page change. (#2825 by @datlechin)
- Schema picker lists system schemas last, in place of its Show System Schemas toggle. (#2832, #2834 by @datlechin)
- Welcome window at a fixed size, remembering where it sits on screen. (#2868 by @datlechin)
- Welcome window list moved with the arrow keys instead of
Ctrl+J,Ctrl+K,Ctrl+HandCtrl+L. (#2849 by @datlechin) - Connection switcher lists Favorites, Recent and groups at every depth. (#2849 by @datlechin)
- Connection rows without colored dots, on the Mac and on iOS. (#2849 by @datlechin)
- SQL Server sessions open with the ANSI SET profile the server requires, matching every other client. (#2855 by @datlechin)
- Compared columns in data Compare & Sync chosen per table, and saved with each table's key, filter and row limit. (#2537, #2854 by @datlechin)
- Query editor command bar with one control size, the container picker leading and the commands trailing. (#2892 by @datlechin)
- Approval cards name the statement and the connection, with Reject in place of Cancel. (#2936 by @datlechin)
- Scripts with their own
BEGINorSTART TRANSACTIONrun without a second transaction wrapped around them. (#2949 by @datlechin)
Fixed
- Filters cleared on a table coming back the next time that table is read.
- Oracle login hanging until the server gave up when it declined the network encryption negotiation. (#2919, #2935 by @datlechin)
- Oracle login timeout that never fired, leaving the connecting spinner up past its deadline. (#2919, #2935 by @datlechin)
- Crash from an Oracle server sending a marker packet, or an accept packet under 32 bytes, during login. (#2919, #2935 by @datlechin)
- Crash on launch when a pairing deep link opens the approval sheet. (#2930, #2933 by @datlechin)
Cmd+Returninserting the highlighted completion instead of running the query while the autocomplete list is open. (#2940 by @datlechin)- Wrong table dropped, truncated or opened from a PostgreSQL partition that lives in another schema. (#2523, #2937 by @datlechin)
- A PostgreSQL partition missing from the object list when its parent table is not readable. (#2523, #2937 by @datlechin)
- A PostgreSQL foreign-table partition listed twice, under Foreign Tables and under its parent. (#2523, #2937 by @datlechin)
- PostgreSQL Copy To failing on enum, composite and PostGIS columns, and dropping type lengths and precision. (#2934, #2943 by @datlechin)
Returnin the raw SQL filter accepting a suggestion nobody selected instead of applying the filter. (#2927 by @filipac)Returnon a filter value replacing what was typed with the first suggestion. (#2927 by @filipac)- Filter autocomplete opening a full column list where the editor's stays shut. (#2927 by @filipac)
- No autocomplete after an opening backtick or double quote, in the editor and the grid filter field. (#2923 by @datlechin)
- No type list after a PostgreSQL
::cast until a character was typed. (#2925 by @datlechin) - Twelve pull-down menus VoiceOver read without a name, the result chooser and the sidebar's schema picker among them. (#2929 by @datlechin)
- Autocomplete popup never opening again after a completion request came back with nothing. (#2915, #2921 by @datlechin)
- Completion popup opening by itself over an editor whose popup had already been dismissed. (#2921 by @datlechin)
- Escape and
Ctrl+Spacedoing nothing after a completion request came back with nothing. (#2921 by @datlechin) - Nested Elasticsearch fields showing as null in the grid, and filters on those leaves matching nothing. (#2905 by @digows)
- Typesense object array columns misaligning when an element omitted the field. (#2922 by @datlechin)
- Two disclosure chevrons on the connection form's Tags row. (#2928 by @datlechin)
- Add tags not opening the tag menu when the words themselves are clicked. (#2928 by @datlechin)
Escnot leaving Vim's Insert mode in the SQL editor. (#2914, #2918 by @datlechin)- Vim mode inert until the editor is refocused when it is turned on while the editor already has focus. (#2918 by @datlechin)
- A find bar open in one window swallowing
Escin every other window. (#2918 by @datlechin) Tabaccepting an AI suggestion instead of the selected item in the autocomplete list. (#2918 by @datlechin)- Drop Schema and Drop Database skipping Safe Mode's confirmation and Touch ID, and writing no audit record. (#2917 by @datlechin)
- New Database offered on a read-only connection, and running without Safe Mode's confirmation. (#2917 by @datlechin)
- Drop Schema failing on Redshift, CockroachDB and PGlite, which offered it with nothing behind it. (#2917 by @datlechin)
- Missing
CREATE SCHEMAsteps when duplicating a Redshift or CockroachDB database with more than one schema. (#2917 by @datlechin) - Drop Schema promising to delete dependent objects on engines with no
CASCADE, such as SQL Server and BigQuery. (#2917 by @datlechin) - Recent Tables entries left pointing at tables in a dropped schema. (#2917 by @datlechin)
Tabstopping at the sidebar, leaving the editor, data grid, inspector and assistant unreachable from the keyboard. (#2904, #2916 by @datlechin)- Clear Selection enabled on a window with nothing to clear. (#2916 by @datlechin)
- PostgreSQL
box[]cell split into fragments by the element editor, which read it with a comma. (#2913 by @datlechin) - Empty PostgreSQL
jsonbobject copied to another engine as an empty array. (Copy Objects) (#2911 by @datlechin) - Boolean dropdown on a PostgreSQL
bit(8)[]column, and no element editor onnumeric(10,2)[]. (#2910 by @datlechin) - Two chevrons on the row inspector's
SETfield. (#2909 by @datlechin) - Unicode whitespace dropped from a PostgreSQL array element when a sibling element was edited. (#2903 by @datlechin)
- Stale error banner over a pinned result after clearing the results of a failed query. (#2892 by @datlechin)
DROP TABLEandTRUNCATE TABLEgenerated for Elasticsearch, Kafka, Weaviate and etcd, which have no SQL. (#2884, #2896 by @datlechin)- Empty Elasticsearch and Weaviate exports, which asked the engine for
SELECT * FROM. (#2899 by @datlechin) - Drop Table and Truncate Table offered on every iOS engine, including Redis keys. (#2899 by @datlechin)
- Delete and Truncate offered on engines that have no statement for them. (#2896 by @datlechin)
- Truncate on a Redis database emptying whichever database the connection was on. (#2896 by @datlechin)
- Base64 text instead of the request in the Typesense drop and truncate confirmation. (#2896 by @datlechin)
- Imported connections pointing at an SSH profile that is not on the importing Mac. (#2879 by @datlechin)
- Syntax highlighting falling a second or two behind while typing quickly in the SQL editor. (#2880 by @datlechin)
- Beep and a question-mark badge when pressing
Ctrl+Cmd+Jin the SQL editor. (#2877 by @datlechin) - Connections still reaching an SSH profile's old host and username after the profile was edited. (#2872 by @datlechin)
- SSH profile edits made on another Mac never reaching the connections that use it. (#2872 by @datlechin)
- Deleting an SSH profile leaving the connections that used it without a tunnel. (#2872 by @datlechin)
- SSH profile secrets left in the keychain when the profile was deleted on another Mac. (#2872 by @datlechin)
- An SSH profile editor reporting a save or a delete that never reached disk. (#2872 by @datlechin)
- Clearing a connection's password, or an inline SSH password or key passphrase, leaving the old one stored. (#2872 by @datlechin)
- Backups and restores running with no password when it comes from a password source or
~/.pgpass. (#2872 by @datlechin) - Password source failures during a backup or restore reported as a database authentication failure. (#2872 by @datlechin)
- SqlPackage password-exposure warning skipped on a restore, and on a connection using a password source or
~/.pgpass. (#2872 by @datlechin) - Saved passwords deleted from iCloud Keychain when TablePro for iPhone launched before its connections loaded. (#2872 by @datlechin)
- Stutter when scrolling a very long line in the SQL editor. (#2861 by @datlechin)
- Row inspector edits missing from the grid cell and gone from the inspector on reselect. (#2851, #2858 by @datlechin)
- Detached JSON cell editor writing into another record after a column filter or a sort moved the rows. (#2869 by @datlechin)
- NULL written into every selected row when a field they disagree on was cleared in the row inspector. (#2867 by @datlechin)
- Row inspector showing the discarded values after Discard Changes. (#2867 by @datlechin)
- One undo step per character when typing in a row inspector field. (#2871 by @datlechin)
- Text typed into a detached row inspector value window silently dropped once another row was selected. (#2870 by @datlechin)
- Row inspector's JSON view showing the row as it was while a detached value window was still writing it. (#2870 by @datlechin)
- Empty Procedures and Functions lists on every SQL Server connection. (#2855 by @datlechin)
- SQL Server rows that could not be saved on a table with a filtered index or an index on a computed column. (#2855 by @datlechin)
- SQL Server CLR and extended procedures and functions missing from the Procedures and Functions lists. (#2855 by @datlechin)
- SQL Server routines labelled encrypted when the account simply cannot read their source. (#2855 by @datlechin)
- SQL Server version detection on a patched server, which left
CREATE OR ALTERunused since 2016. (#2855 by @datlechin) - SQL editor jumping back while scrolling sideways near the start of a long line. (#2841, #2848 by @datlechin)
- Data sync scripts missing every UPDATE and DELETE. (#2537, #2854 by @datlechin)
- Data sync statements written to the source schema instead of the target. (#2854 by @datlechin)
- Numeric-looking text such as
007written unquoted by data sync, and key matches that hit extra rows. (#2854 by @datlechin) - Data sync pairing arbitrary rows on a key that is not unique. (#2854 by @datlechin)
- Data sync inserts failing on SQL Server identity and PostgreSQL
GENERATED ALWAYScolumns. (#2854 by @datlechin) - Text columns compared as timestamps, and keys that differ only in case never synced. (#2854 by @datlechin)
- Data sync scripts including tables never compared, or rows that changed after comparing. (#2854 by @datlechin)
- Structure sync scripts written from a schema that changed after it was compared. (#2859 by @datlechin)
- Apply unavailable for a second sync in the same Compare & Sync window. (#2854 by @datlechin)
- Choosing a source, target, mode or option during Apply cancelling the running sync. (#2854 by @datlechin)
- Apply offered for a target switched to Read-Only after it was picked. (#2854 by @datlechin)
- Compare & Sync reporting nothing written after a sync had written to the target. (#2854 by @datlechin)
- Rolled-back data sync on MyISAM tables reported as leaving the target unchanged. (#2854 by @datlechin)
- Cancelling a repeated data comparison clearing the previous results. (#2854 by @datlechin)
- Table whose data comparison failed stuck included with no way to exclude it. (#2854 by @datlechin)
- SSH settings dropped from a Mac connection after syncing from the iPhone app, turning off its tunnel or remote file. (#2846 by @datlechin)
- Remote database file path and access mode dropped when a connection was exported, shared as a link, or imported. (#2845 by @datlechin)
- Remote database file connections hanging for minutes when SSH dropped silently, with Cancel doing nothing. (#2843 by @datlechin)
- Stutter when scrolling a long line while Find highlights many matches. (#2862 by @datlechin)
- Remote database file reaching the previous server after the connection's host, port, or user was changed. (#2843 by @datlechin)
- Favoriting, moving or reordering a connection reverting a Safe Mode level changed in its window. (#2849 by @datlechin)
- Connections in groups nested more than three levels deep missing from the welcome window. (#2849 by @datlechin)
- Linked folder and Team Library connections to two databases on one host treated as one connection. (#2849 by @datlechin)
- Slow typing and scrolling in a very long line with word wrap on. (#2863 by @datlechin)
- New, duplicated and moved connections placed at the top of their group. (#2849 by @datlechin)
- Password sources skipped after an older connection store was renumbered. (#2849 by @datlechin)
- Connections from a cancelled New Group sheet moved into the next group created. (#2849 by @datlechin)
- Search in the welcome window hiding matches inside collapsed groups. (#2849 by @datlechin)
- Memory spike when dragging selected text in an editor that holds a very long line. (#2864 by @datlechin)
- Blank line added to text dragged from an editor for every extra cursor in the document. (#2864 by @datlechin)
- Connection switcher showing a dropped connection as connected and checking the wrong one in a second window. (#2849 by @datlechin)
- Welcome window changes that failed to save shown as saved. (#2849 by @datlechin)
- Linked folder connection losing its SSH, SSL and Safe Mode settings on connect. (#2849 by @datlechin)
- iOS connection edit resetting the order, color, query timeout and extra tags. (#2849 by @datlechin)
- iOS group delete leaving its subgroups behind, and tag counts reading only the first tag. (#2849 by @datlechin)
- iOS sync overwriting a connection edited while the sync ran. (#2849 by @datlechin)
- iOS Duplicate losing the password, SSH secrets, client certificates and file access. (#2849 by @datlechin)
- Update preferences overwritten by the app at every launch instead of following the setting. (#2813 by @datlechin)
- No automatic update checks on a fresh install, and a permission prompt on the second launch. (#2865 by @datlechin)
- No automatic update checks at all with the usage heartbeat off and Reopen Last Session chosen. (#2865 by @datlechin)
- Architecture error shown when a plugin actually needs a newer version of TablePro. (#2814 by @datlechin)
- Sidebar, completion and other windows missing a change to a table, view, routine, trigger, type, schema or database. (#2819, #2821 by @datlechin)
- Saving a staged Drop or Truncate running the selected query tab's statement again. (#2821 by @datlechin)
- Dropped tables left staged after a partly failed save, and drops staged in another database unstaged on refresh. (#2821 by @datlechin)
- Table tab showing another database's rows after a database switch on PostgreSQL, Redshift and CockroachDB. (#2820 by @datlechin)
- Wrong approximate row count for a PostgreSQL or PGlite table outside the current schema. (#2822 by @datlechin)
- Queued queries running on a reopened connection, or stalling it, after a disconnect. (#2824 by @datlechin)
- Redis keys read from the wrong database when switching databases while a load was running. (#2824 by @datlechin)
- "This tab is on" error on a table tab for the previous database when it reloads during a database switch. (#2824 by @datlechin)
- Table on another database opening empty with no error while the connection switches database. (#2824 by @datlechin)
- Reopen Closed Tab removing the closed tab without reopening it when its connection's window already had tabs. (#2829 by @datlechin)
- Unchecked and soloed filter rows dropped from a table's saved filters after switching tabs. (#2827 by @datlechin)
- Table opened in another database from a link, MCP or AppleScript bound to the current schema. (#2828 by @datlechin)
- Recent table opened before connecting reopening a same-named table in another schema, and listed twice. (#2828 by @datlechin)
- AI and Copilot schema context listing a table with the columns of a same-named table in another schema. (#2830 by @datlechin)
- Inline cell editor left open over a different row after a refresh. (#2825 by @datlechin)
- Row selected by Back or Forward dropped once the table finished loading. (#2825 by @datlechin)
- Data grid jumping to the top on a later reload after a page change failed. (#2825 by @datlechin)
- System databases such as
mysqlmissing from the database switcher, the tab database picker and Open Quickly. (#2832, #2834 by @datlechin) - SQL Server and ClickHouse system databases listed as user databases once the database switcher finished loading. (#2834 by @datlechin)
- Cmd+scroll not zooming the ER diagram or the query plan diagram. (#2840 by @datlechin)
- Oracle system schemas such as
SYSandXDBlisted with user schemas. (#2839 by @datlechin) - Dameng
SYSDBAschema hidden from the sidebar and listed under System. (#2839 by @datlechin) - TiDB's
INFORMATION_SCHEMAandPERFORMANCE_SCHEMAlisted as user databases on a MySQL or MariaDB connection. (#2838 by @datlechin) - SQL Server database size and table count showing the current database's numbers, and no size at 2 GB or more. (#2837 by @datlechin)
- ClickHouse databases with no tables missing from the database switcher and database statistics. (#2836 by @datlechin)
- Stale write-ahead log replayed over a freshly fetched copy of a remote SQLite database. (#2842 by @datlechin)
- Remote database copy reused after a commit that did not grow its write-ahead log. (#2842 by @datlechin)
- Killed remote
VACUUM INTOsnapshot reported as a successful copy. (#2842 by @datlechin) - Interrupted remote snapshot files left on the server. (#2842 by @datlechin)
- Local working copies of remote databases kept forever. (#2842 by @datlechin)
- Clicks, drags and the hand pointer landing on the wrong table or plan step once a diagram is zoomed. (#2844 by @datlechin)
- ER diagram table held at the edge of the view sliding away from the pointer, or auto-pan not starting when zoomed out. (#2850 by @datlechin)
- ER diagram scrolling on its own after a table drag was interrupted by a tab or connection switch. (#2850 by @datlechin)
- Fit to Window on an ER diagram fitting empty space left behind by a dragged table. (#2850 by @datlechin)
- Query plan mode, selected step, zoom and scroll lost on a mode or tab switch, or zoom carried over to another plan. (#2850 by @datlechin)
- Zoom Out on a diagram at 5% jumping to 1%. (#2850 by @datlechin)
- An AWS profile backed by IAM Identity Center, or an assume-role chain rooted on one, failing to authenticate. (#2857 by @datlechin)
- AWS SSO sign-in leaving the
awsCLI unable to refresh its own token. (#2857 by @datlechin) - AWS SSO, STS and RDS unreachable in the China, GovCloud and secret partitions. (#2857 by @datlechin)
- Auto-uppercase keywords leaving
ADD,MERGE,CALL,COMMENTand 17 more in the case they were typed. (#2912 by @datlechin) - Autocomplete committing a different column between launches when two scored the same. (#2907 by @datlechin)
- MongoDB autocomplete inserting
$MATCHandDB, which the server rejects. (#2902 by @datlechin) - ClickHouse autocomplete offering 18 function names the server rejects,
TOSTRINGandUNIQamong them. (#2902 by @datlechin) - Completion inserted beside a non-ASCII prefix instead of replacing it:
SELECT 名becameSELECT 名名前. (#2902 by @datlechin) - Caret landing after the closing parenthesis when accepting a function in the filter panel's Raw SQL field. (#2902 by @datlechin)
- Run and Reject did nothing on every approval card but the first when a turn proposed several tool calls. (#2936 by @datlechin)
- Return answered an arbitrary approval card when more than one was waiting. (#2936 by @datlechin)
- A reply still arriving was lost when its window closed, its connection dropped, or its session ended. (#2936 by @datlechin)
- The assistant keeping a provider and its open stream for the session after a window closed over an approval card. (#2936 by @datlechin)
- Data race on the server version of a PostgreSQL, Redshift or CockroachDB connection while it closes. (#2947 by @datlechin)
- Structure sync scripts refused for tables that had not changed since they were compared. (#2946 by @datlechin)
- MySQL and MariaDB indexes listed in a different order each time a table's structure loads. (#2946 by @datlechin)
START TRANSACTION READ WRITEsyntax error on MySQL and MariaDB 5.5 when saving, importing or running several statements. (#2949 by @datlechin)- A batch whose transaction failed to start reported as a failed commit of its first statement. (#2949 by @datlechin)
- No tables listed for a MySQL server that answers
information_schemawith nothing or an error. (#2950 by @datlechin) - Tables and routines of the previous database, or none, shown with no error when a newly opened database fails to load. (#2950 by @datlechin)
- PostgreSQL columns copied to another engine losing length, precision, scale and fractional seconds. (#2951 by @datlechin)
- Copying an Oracle
NUMBERwith a negative or oversized scale to another engine failing. (#2951 by @datlechin) - Copying
CHARtext with accented characters into ClickHouse failing. (#2951 by @datlechin) - Copying a table to MySQL, SQL Server or Oracle failing when a key, foreign key or index is too wide for it. (#2951 by @datlechin)
- Column collation dropped by PostgreSQL Copy To, table DDL, column type changes and column reorder scripts. (#2952 by @datlechin)
- PostgreSQL Copy To failing on a column default that passes a sequence to a function or casts it to a type. (#2952 by @datlechin)
- Compare & Sync rewriting a column's collation while collation differences are ignored. (#2952 by @datlechin)
- PostgreSQL expression indexes missing from the Indexes tab and Copy To, or shown without their expression keys. (#2953 by @datlechin)
- PostgreSQL
INCLUDEcolumns shown, copied and recreated as index key columns. (#2953 by @datlechin) - PostgreSQL Copy To failing on a
gin_trgm_opsindex, or a partial index naming a type or function in another schema. (#2953 by @datlechin) - PostgreSQL Copy To and index renames losing an index's operator classes, collation, sort order and storage parameters. (#2953 by @datlechin)
- PostgreSQL SP-GiST, HNSW, IVFFlat and BLOOM indexes shown as BTREE on the Indexes tab and rebuilt as B-tree by an index edit. (#2953 by @datlechin)
- Compare & Sync treating two PostgreSQL indexes that differ only in type as the same index. (#2953 by @datlechin)
- SQL Server clustered indexes recreated as nonclustered by Copy To or an index edit. (#2953 by @datlechin)
- ClickHouse data-skipping indexes dropped by an index edit on the Indexes tab. (#2953 by @datlechin)
- Copy To from Redshift, Snowflake or BigQuery creating indexes from table keys and failing on a second table in one schema. (#2953 by @datlechin)
Removed
- CodeEditSymbols, a dependency the editor linked and never called, from the app and from Acknowledgements. (#2873 by @datlechin)
Ctrl+Cmd+Jfrom the editor's reserved shortcuts. (#2877 by @datlechin)- Result tab strip above the query results, and the "Query" heading above the editor. (#2892 by @datlechin)
- Trash button that cleared the query and the results under one name. (#2892 by @datlechin)
- Auto-uppercase keywords in Settings > Editor, replaced by Keyword case. (#2902 by @datlechin)
Escapeshortcut for Clear Selection in Settings > Keyboard. (#2918 by @datlechin)
Security
- Oracle login continuing in clear text when the server picked an encryption algorithm but sent no key material. (#2919, #2935 by @datlechin)
- Pairing approval never showed the address the one-time code is delivered to. (#2930, #2933 by @datlechin)
- A pairing link whose connection allowlist failed to parse widened the request to every connection. (#2930, #2933 by @datlechin)
- Sparkle 2.10.0, carrying installer fixes for a symlink attack and a privilege escalation under root. (#2865 by @datlechin)
- SQLite denies the
fts3_tokenizerfunction, which could crash the app from a crafted query on any connection. (#2835 by @datlechin) - The AI assistant refuses statements that read or write files or run server code (ATTACH, LOAD, VACUUM INTO). (#2831, #2835 by @datlechin)
- Remote
VACUUM INTOsnapshot created world-readable beside a database with stricter permissions. (#2842 by @datlechin) - AWS SSO access token cached world-readable in
~/.aws/sso/cache. (#2857 by @datlechin) - The AI assistant could write to a connection other than its own, with that connection's Safe Mode skipped. (#2936 by @datlechin)
- The AI assistant could read the schema and DDL of any saved connection by id, including one with AI access turned off. (#2936 by @datlechin)