Toad Beta Change Log
Notes:
-
Oracle clients: 12cR2 and 18c are the recommended client versions.
- 19c and 21c are not recommended due to memory leaks with LOBs, as well as hangs when cancelling queries against 11gR2 servers.
- 12cR1 and older clients don't handle XMLTYPE natively.
- Toad's no-client option works well, and is a bit faster than using a client, but it has a few limitations such as Tracing/logging, proxy connections, and TCPS. However, LDAP, TNSNames.ora, Oracle Encryption and Data Integrity are all supported in no-client mode. This post has a good discussion about it. Uncheck the "Use Oracle Client" box on the login window to try it.
-
Fonts
- Segoe UI is Toad's new GUI font.
- Consolas is Toad's new Editor (fixed-width) font.
- So nice.
Running Total for 16.2: 60 bugs fixes, 20 enhancements
Beta 16.2.next, To be released 15-Aug-2022
Bug Fixes
- Connections: Set Role/Transaction feature not working in no-client mode, and also not after auto-reconnect
- Query Builder: Join order was inconsistent
- Create Pluggable Database: TNSNames.ora not found in no-client mode
- Schema Browser: Quick Filter selecting item from history when it should not
- Editor: Cursor movement slow when arrow key held down
- Data Grids: Copy/Paste Arabic text into MS Word or Teams missing/misformatting data
Enhancements
- Connections: Added error handling after connection initialization pl/sql block
- Editor Font and Styling: Added "User Words 1" word list for user customization
Beta 16.2.58, Released 10-Aug-2022
Bug Fixes
- Script Execution: A significant memory leak was fixed
- Editor: Caret placement incorrect when attempting to select a line
Enhancements
- Schema Browser: Added Quick Filter match modes (right-click on quick filter to set)
Beta 16.2.54, Released 8-Aug-2022
Bug Fixes
- Alter Table: Wrong column affected on the first click into columns grid
- Session Browser: "Field not found" error after connection lost
- Code Snippets: Access violation after editing snippets with auto-hide
- Describe Objects: F4 not finding package constants
- Run Procedure: "Cannot focus disabled or invisible window" error
- Connections: Improved handling of reconnect when opening Schema Browser, Import Table, Data, Describe, Single Object Compare, Database Browser, SGA Trace, Chained Rows
- utPLSQL Manager: Access violation when closing Toad
- Editor: Wrong colors after restoring Editor Font and Syling defaults
- Alert Log Viewer: opening files too slowly
- Single Object Compare: Access violation if Toad closed while running from SB
Enhancements
- Login: LDAP and TNSNames editor buttons moved to better location
- Dark Mode: Minor enhancements to editor colors
Beta 16.2.43.1663, Released 1-Aug-2022
Bug Fixes
- Login window: Selection changes to another group after delete
- Compare Multiple Tables: Decimal separator incorrect in sync script
- Schema Browser: Object Type incremental search was clumsy
- Schema Browser: Error on Data tab refresh after connection lost
- Schema Browser: SQL error when revoking object privs from mixed-case schema
- Session Browser: "Additional Privs Required" dialog not working
- utPLSQL manager: Context menu flickered while test ran
Enhancements
- Describe Dialogs: Added an option to remember size/position
- Editor: Better variable names when selecting SQL from PL/SQL, then CTRL+Enter to run
- Editor: All tabs now marked Deleted/Modified at same time when files change on disk
- Login Window: Added a confirmation prompt when unchecking the save passwords option
- Schema Browser: Clone User - added a "Show SQL" button
Beta 16.2.34.1649, Released 25-Jul-2022
Bug Fixes
- Options: Windows -> Create Table settings getting mixed up with Create Queue Table
- Schema Browser: Object Type incremental search treating 2nd letter as 1st
- Schema Browser: Team Coding icons missing for sequences
- Schema Browser: Font size change resulted in wrong spacing between objects
- Schema Browser: Create Insert for selected rows - bogus "no data found" message
Enhancements
- Automation Designer: Didn't handle large ToadActions.dat well.
- Connections: No-Client mode now supports LDAP
- Compiling: Added option to check to see if package in use before compiling
- Data Grids: Options -> Data Grids -> Visual -> Edit -> Simple. Dialog was worked to prevent accidental coloring of header background color
- Data Grids: Copy/Paste to MS Teams now pastes in a nice table format
- File Compare: Added shortcuts for next/prev diff
Beta 16.2.22, Released 18-Jul-2022
Bug Fixes
- Export Dataset: Access violation if exporting to folder that can't be written to
- Generate Schema/DB Script, Compare Schema/DB: SOS files now saved as text. Also, files can be specified in parameter files in Automation Designer
- Schema Browser: Refresh LHS not working for Funcs, Procs, Packages, Types
- Schema Browser: Popup menu for Types can get lost/broken
- Toad Script Runner: Can't connect with EZConnect syntax
Enhancements
- Toad Script Runner: Added color schemas like Toad (configured separately)
Beta 16.2.12.1608, Released 12-Jul-2022
Bug Fixes
- Export Dataset: SQL Loader format - Null date fields should not have dbl-quote
- Export DDL: Materialized views always show as NOLOGGING
Beta 16.2.7.1608, Released 5-Jul-2022
Bug Fixes
- Connections: LDAP not working with 21c client
- Connection Colors: Window border colors sometimes disappear
- Data Grids: Cascade of errors when pasting invalid number
- Data Generation: Failure when FK field names differ between tables
- DBMS Output: Not returning complete text when output contains multibytes chars
- Describe window: Can get stuck in an "Empty" state
- Editor: Variables dialog sometimes stays on top of other apps
- Export Dataset: Excel Instance - Excel staying behind Toad after export
- Export Dataset: SQL Loader format - can't set string delimiter to null
- Export Dataset: Access violation when exporting to location where file cannot be saved
- File Compare: Access violation when trying to save results
- Login Window: Duplicated entries if connections added manually in lower case
- Options: Decimal and Thousand settings not retained
- Query Builder: Fixed bad column sizing
- QSR: Connection Error when launched from Toad's Project Manager
- Schema Browser: Triggers not updating after enable/disable
- Schema Browser: Filter/Sort dialog adding parens when not needed
- Schema Browser: Object Types not displayed correctly when Team Coding enabled
- Script Execution: SQL Keywords not accepted as script arguments
- Script Execution: Memory leak when processing comments
- Team Coding: Global filter exclusions getting merged
- TNSNames Editor: Not available from menu in no-client mode
- Workspaces: Connection not restored if Automation Designer open
Enhancements
- GUI font changed to Segoe UI.
- Editor font changed to Consolas.
- HTML Schema Doc, Schema Compare, Schema Script: SOS filters now saved as text, files can be now specified in automation
The change log for Toad version 16.1 is here