Toad Beta Change Log
Toad Beta 24.2.222.4504, Released 3-Sept-2024
Bug Fixes
- Font Dialog: On scaled displays, resulting font size can be larger than expected
- Editor: Code Insight not showing fields of implicit cursor record
- Editor: Code Insight: fixed misc bugs caused by recent fixes to other problems
- Editor: "Load Object at Caret" does not respect Package/Type load as pair option
- Fast Report: Toolbar buttons disappearing on scaled displays on Windows Server 2019
- Editor: "Replace all" misses selected text if "from cursor" is chosen
- utPLSQL: Does not support multi-schema install
Enhancements
- Connection Colors: Can now be auto-suggested based on rules which you can define
- Schema Browser: When dropping indexes, ORA-02429 is raised if the index is used to enforce a PK or Unique constraint. Now the "Drop Index" confirmation has an option to drop the constraint if this occurs, preventing the error and dropping both constraint and index.
- Schema Browser: Filter for ROLES now includes an option to exclude Oracle-Maintained roles.
- Font Dialog: Now filterable and remembers recent selections
- Administer Tablespaces: Space manager setup fails in no-client mode
Toad Beta 24.2.208.4458, 26-Aug-2024
Bug Fixes
- Trace File Browser: Trace files with "CursorDiagnosticNodes" section cause errors
- Schema Browser: ORA-01791 error displayed when expanding Unified Audit Policies node when Schema Browser is in treeview mode
- Compare Data: CHAR datatypes not synchronizing correctly when tables are in different databases
- SFTP: Private key file with passphrase caused "The password is incorrect" error
Enhancements
- Options: Advanced options added to Options->Editor->Behavior to help handle Editor text rendering problems on scaled displays
- Connections: In Options -> Oracle -> Connections, you can now specify that Toad disconnects after a period of inactivity within Toad (to prevent connections from being lost, which can lead to freezes/locks)
Toad Beta 24.2.195.4406, Released 19-Aug-2024
Bug Fixes
- Editor: Find Next doesn't advance to next matching text if dialog is opened with matching text already selected
- Connections: Toad unnecessarily polling LDAP for list of TNS entries when connection is made
Enhancements
- Create Constraint: A warning is now displayed if you are about to create a circular foreign key constraint
Toad Beta 24.2.185.4369, Released 14-Aug-2024
Bug Fixes
- Connections: "NET: Invalid Arguments" error when connecting to 23ai or fully patched 19c DB with Crypto or Encryption parameters set in server side SQLNet.Ora
- Compare Databases: List Index Out of Bounds if attempt to preview differences too quickly
Toad Beta 24.2.182.4361, Released 12-Aug-2024
Bug Fixes
- Datagrids: DB Object popup editor showing wrong columns and access violation
- No-client mode: "Drop type" gives "drop materialized view" message when running scripts
- Schema Browser: List Index Out of Bounds error if attempt to enable/disable constraint that was dropped
- Schema Browser: "Show column ID in grid" option caused lag on views, m-views, and a-views with lots of columns
- Data Grids: "Pin" icon in Editor showing wrong state
- Schema Browser: RHS tabs too short on scaled displays
- Docking panels: Selected dock label fuzzy on scaled displays
Enhancements
- Automation Designer: Improved action placement when double-clicking in palette
Toad Beta 24.2.167.4299, Released 5-Aug-2024
Bug Fixes
- Data Grids: Fuzzy text on while editing varchar2 fields on scaled displays
- Editor: Code Insight not prioritizing ref. integrity suggestions if columns have different names
- Editor: Toad hangs selecting text with $ characters when brace highlighting set to "innermost pair in scope"
- Editor: CONNECT command not working in script execution with no-client mode
- Login Window: TNSNames, LDAP, SQLNet buttons fuzzy on scaled displays
- No-client mode: Not finding tnsnames.ora from Project Manger, Support Bundle, TNSNames Editor
- Options: Temporary folder now defaults to %TEMP% (same location, but now variable can be specified incase it changes)
- Team Coding: Filenames with non-ascii characters not handled properly with Git
Enhancements
- Editor: Shift+Right-click on DB Object name now shows Schema Browser popup menu
Other
- RExec is no longer supported in Toad as it is an insecure protocol. Use SSH instead.
Toad Beta 24.2.150.4235, Released 29-July-2024
Bug Fixes
- Code Insight: Some of the icons are incorrect
- CodeXpert.ini rewritten each time Toad starts
- Connections: First auto-exec action executing silently. Others, non-silently
- DBMS Output: ORA-20005 occurs with some old Oracle client versions
- Export Dataset: Substitution variables not substituted if SQL contains comments or trailing whitespace before sub variable
- Export/Import Utility Wizards: Error thrown if parameter file's folder doesn't exist (Toad should create it)
- HTML DB Documentation: Custom fields from login window not included in output
- Login Window: Import prompting for overwrite if same login present but with different "Connect as"
- Login Window: Import not auto-checking "save password", even after prompt to do so
- Options: The following files were being created even when empty: Connections.Ini, ConnectionActions.ini, ToadMail.ini, ToadMonitors.ini, SProjManFilterHist.xml, Networkconnections.dat
- Master-Detail Browser: Dialog to migrate to another schema showing "Current Schema" more than once
- Script Manager: "Could not convert variant" error when sending script to TSR
Enhancements
- Editor: Code Insight has new option to include matches that contain the partially typed text (not just start with it). Options page improved also
- Editor: Breakpoints panel rewritten for consistency across the various debugger types
- DB Health Scan: Information/Statistical items no longer count as pass/fail. Also, pass/fail is now per check, not per failure
Toad Beta 24.2.134.4180, Released 22-July-2024
Bug Fixes
- Data Grids: Invalid filter values raised error instead of "nice" message
- DBMS Output: ORA-02005 thrown with some Oracle clients
- DB Health Check: Format error in check for items which cannot extend due to lack of room in tablespace
- DB Health Scan: Check/Uncheck all does nothing
- Editor: Edit command caused ORA-00904 if table named used as alias
- Editor: Desktop layout incorrect after dragging tabs
- Editor: Access violation after closing hex tab
- Editor: FmtPlus.opt file sharing error due to too frequent file access
- Editor: Code Insight not showing after subquery in FROM clause
- Editor: Code Insight not showing join suggestions in subquery
- Import Wizard: List Index out of Bounds if opening small parameter file
- JDWP Debugger: Access violation when connection closed and breakpoint exists
- Rebuild Multiple Objects; Field BYTES not found for partitioned tables
- Schema Browser: Stray text remnants after disabling "Show PK" option for materialized views
- Team Coding: Admin window disabled after TC Installation
Enhancements
- SQL Firewall: Misc enhancements and bug fixes
- Schema Browser: Custom queries and filters can now be stored globally by table name (Configurable in Options|Schema Browser|Data Tab)
Toad Beta 24.2.111.4104, Released 15-July-2024
Bug Fixes
- Create Constraint: Error on "move column down" if nothing selected
- Editor: "New tab" icon colored wrong in dark mode with some tab styles
- Formatting: Fmtplus.opt file sharing error when SQL formatted for internal use
- Grid: Popup text editor saving files with uppercase TXT extension
- Login Window: Grid reloading and jumping to wrong row after display of TNS Editor
- Recover Documents: Access violation if grid filtered, then recover recent
- Schema Browser: Error when selecting a file item in Favorites
- Schema Browser: Wrong icon for disabled constraint
Enhancements
- Compare Schemas: When types differ because one as been altered, we'll now use ALTER TYPE to alter the other if possible (rather than CREATE OR REPLACE, which fails if dependents exist)
- Editor: Caret width is now configurable in Options|Editor|Display
- Oracle 23ai: SQL Firewall window added under Administer menu (DB Admin module required)
- Workspace: Added cancel button to stop the loading of a workspace
Toad Beta 24.2.92.4041, Released 8-July-2024
Bug Fixes
- Database Browser: Can't connect as externally authenticated user
- Login Window: LDAP dropdown not loading after switch from client to no-client mode
- Session Browser: Vertical splitter not retaining position when switching to other windows and back to SessB.
- Team Coding: Get Last Version failed due to extension mismatch
- Window Menu: Wrong window shown as active
Enhancements
- Oracle 23ai: Added support for Tablespace Shrink functionality in Schema Browser
Toad Beta 24.2.79.4007, Released 24-June-2024
Bug Fixes
- Create Table: Window locks up when dragging from grid
- Connections: Access violation if no Oracle clients present and login attempted with expired password
- Data Grids: ANYDATA access violation
- Editor: "Display full path as tab hints" stops working Link
- Editor: Inline parameter assistance copy/paste bad behavior Link
- Login window: "Invalid Oracle Home" when testing connections and no clients installed
- Schema Compare: Evolved types not handled properly in sync script
- Session Browser: Access violation when opening if "Format Statement" unchecked
- Session Browser: Test Filter causes access violation
- Single Record Viewer: Options dialog not opening
- Single Object Compare: Sometimes missing SYNC script
Enhancements
- Application Logging: Support bundle now automatically included
- Connections: Added Connection Timeout setting (for when connection is being established or reconnected) Only available in no-client mode.
- Master Detail Browser: Added "Current Schema" option to make MD files portable across different schemas with same tables Link
- Schema Browser: Data tab filter now uses date format specified in options Link
- Schema Browser: Display both Base and Log tables for materialized view logs Link
- Session Browser: Rt-click: Styles added to main grid/tree
Toad Beta 24.2.61.3952, Released 17-June-2024
Bug Fixes
- Data Grids: Column headers not always wide enough on scaled displays
- Session Browser: Access Violation when opened if "Format Statements" unchecked
- Startup: If "Allow multiple copies of Toad" unchecked and 2nd Toad started with command line parameters, parameters not passed to 1st Toad
- Startup: Toad not remembering display if closed while maximized
Enhancements
- Application Logging: Support bundle now automatically included in Logs folder
- Data Grids: Now crisp and sharp on scaled displays
- Oracle 23ai: Respect Bigfile tablespace default
- Oracle 23ai: ORA-41900 handled like ORA-00942
- Project Manager: Filter added Link
Toad Beta 24.2.51.3922, Released 10-June-2024
Bug Fixes
- Automation Designer: Export Dataset actions erroneously throwing "Parameters out of sync" message Link
- Editor: Grid not allowing edits if OCI Array Buffer Size set to Manual. Link
- Main Form: Size/Position not always restored correctly Link
- Session Browser: RHS refresh delay is annoying Link
Enhancements
- Editor: Added ability to fold all regions at any level Link
- Editor: Added some "copy to clipboard" options for Explain Plan Link
- Oracle 23ai: Added support for Logical Partition Tracking. Note, this requires the READ privilege on the table SYS.TABLOGICPART$. Hopefully Oracle will give us some standard USER/ALL/DBA views for this data soon.
- Oracle 23ai: Added ability to open pluggable databases in Hybrid Read Only mode
- Oracle 23ai: Added support for hybrid partitioned tables with interval and auto list partitioning
- Oracle 23ai: Added ability to rename LOBs w/o moving them
- Oracle 23ai: Added support for concurrent refreshes in MVs
- utPLSQL: Version 3.1.1.14 now supported
Toad Beta 24.2.31.3856, Released 3-June-2024
Bug Fixes
- Alter Unified Audit Policy: "Disable" not working
- Add/Edit Login: TNS dropdown not loaded unless TNS_ADMIN specified Link
- Blob Viewer: Viewing PNG data as PDF caused Toad to freeze Link
- Compare Databases: Revoke Role above the comment for that role Link
- Export DDL: Not Null constraints missing from script for object tables
- Misc Internal SQL: Not always using
SYS.with data dictionary view names - Schema Browser: SQL error when listing DOMAINS
Enhancements
- Compare Databases: Added preview panel
- Manage User Settings: Added ability to restore individual settings from backup
- Oracle 23ai: Added support for read only users
- Oracle 23ai: Added support for enable/disable dictionary protection
- Oracle 23ai: Added support for individual columns in Unified Audit Policies
- Oracle 23ai: Added support for VECTOR datatypes
- Oracle 23ai: Added support for VECTOR indexes
- Oracle 23ai: Added support for staging tables
- Schema Browser: Added option to adjust node heights Link
- Team Coding: Added "Locked by" field in SB RHS and Editor
- Team Coding: Added option to use OS User or login schema as lock user Link
Toad Beta 24.2.15.3785 Released 28-May-2024
Bug Fixes
- Error on startup if color themes enabled
Toad Beta 24.2.11.3771 Released 28-May-2024
Bug Fixes
- Code Analysis: Access violation if window closed too quickly
- Editor: Errors thrown if attempting to step into Java Source while debugging with JDWP
- Export DDL: private synonyms excluded when getting script for multiple users
- Export DDL: Object Table Substitution clause left out of table scripts
- Schema Browser: SQL error when clicking system tablespace
- Session Browser: Blinks on refresh
- Workspaces: Describe Objects window focused after loading workspace
Enhancements
- New version numbering system: Year.Release.Build.Internal
- Database Compare: Added preview panel for differences
- Manage User Settings: Added ability to recover specific items from backup
- Schema Browser: Added icons to indicate Unified Audit Policy enablement Link
- Schema Browser: Added ability to enable/disable Unified Audit Policies Link
- Single Record View: Table name is now displayed when launched from Editor Link
The change log for Toad version 17.1 is here