Softpedia >Windows >Internet >Servers >Database Utils >SQLDetective >  Changelog

SQLDetective Changelog

What's new in SQLDetective 5.1.1 Build 361

Sep 23, 2020
  • IMPROVEMENTS:
  • Object Navigator:
  • Connected sessions in the Object Navigator are now colored according to the selected database type.
  • If a database connection password expires soon or has already expired, both cases are now indicated in
  • the “Change password” window.
  • Find Objects:
  • Removed Public schemas from the system schema list, so the Public schemas now remain visible when
  • the “Hide system schemas” check box is enabled.
  • Compare Schemas:
  • Optimized the memory usage for schema comparison with a large number of objects in each.
  • Profile Wizard:
  • Introduced the support for INACTIVE_ACCOUNT_TIME in the Profile Wizard and DDL.
  • Synonym Wizard:
  • The object name is now automatically specified in the Synonym Wizard if the synonym is created from the
  • Synonyms’ sub-folder.
  • Export and Import Wizards:
  • Improved the layout of the UI elements in the Export and Import Wizards.
  • Tray Notifications:
  • Users are now reminded about the upcoming subscription renewal.
  • BUGS FIXED:
  • Core:
  • When the corresponding options are enabled for the current database type, the user is now prompted to
  • confirm the execution of the following statements:
  • GRANT, ADMINISTER KEY MANAGEMENT in the SQL Editor.
  • PURGE in the Object Navigator.
  • GRANT, REVOKE in the Object Privileges module.
  • SQL Editor:
  • Formatting of scripts copied from the SQL Editor is now preserved when pasted in editors that support
  • RTF format.
  • If a session is disconnected while running a long query, the error message “Session <session_name> is
  • busy” now shows a relevant session name.
  • Select statements starting with parenthesis are now correctly executed in the “Data Output” tab.
  • Modifying the vertical toolbar of the SQL Execution History by adding and/or removing icons in the Icon
  • Dictionary now works correctly.
  • Executing the same statement several times no longer opens multiple pages in the Data Output tab.
  • Stored Program Editor:
  • Undoing all changes in a stored object reverts the object’s state back to non-modified.
  • SQL Editor / Stored Program Editor:
  • The code editor no longer flickers on moving the caret when a long script is open and the option “Cursor
  • beyond EOL” is disabled.
  • Object Navigator:
  • Clicking “Create” from the Object Tree now correctly opens the relevant object wizard for triggers, clusters,
  • and collections.
  • Dataset Manager:
  • Filters created for a table no longer appear in the filter list of another table with a similar table name.
  • Code Insight:
  • The Code Insight window is now shown correctly from the first time when the “Include ‘Code Assistant’
  • data” option is enabled.
  • Code suggestions shown in the Code Insight window are no longer corrupted and scrolling the window no
  • longer causes an access violation error.
  • Query by Example:
  • The “Ignore case” option now works correctly for the CLOB columns.
  • Code Analyzer:
  • The rule “Specify full column list” now shows correct code analysis results.
  • Rename Object:
  • An index name that does not match its table name is no longer included in the script when the table is
  • renamed.
  • Find and Replace:
  • When searching for a selected text occurrence, the search scope is no longer changed to “Selected text”.
  • Object Wizards:
  • Fixed the highlighting of the nodes in the object tree.
  • Export Wizard:
  • The Export Wizard’s window is now restored correctly after restarting the application without the database
  • connection.
  • If the “Change Owner To” option is empty when exporting a script, the original object owner is specified in
  • the output file.
  • Constraint / Table Wizard:
  • When the check box “Exclude users with no objects from the Schema list” is selected, users with no
  • objects are no longer shown in the list of constraints.
  • Table Wizard:
  • The confirmation message is now shown on trying to truncate a partition from the wizard.
  • Job / View / Materialized View Wizards:
  • Pressing the tab key no longer removes the cursor from the SQL statement editor.
  • Online Support Desk:
  • The “Reply to message” toolbar button is no longer active when an empty folder is selected.

New in SQLDetective 5.0.1 Build 182 (Jun 13, 2019)

  • IMPROVEMENTS:
  • SQL Editor:
  • Improved the workflow of the automatic determination of the execution plan.
  • Database Monitor
  • Queries now run in a sequence, not in parallel threads.
  • PL/SQL Debugger:
  • Added the ability to view global variables.
  • BUGS FIXED:
  • Code Editors:
  • The cursor, when moved using the Ctrl+arrow keys combinations, no longer breaks on pointing to the dollar and number signs.
  • PL/SQL Debugger:
  • The error message “Unhandled exception occurred. Debugger will be terminated.” no longer appears after an Oracle exception error is raised. Unexpected error messages no longer appear if a breakpoint is set to an illegal line. Variables are now automatically applied to the script during its execution.
  • SQL Editor:
  • Fixed the work of the “Bytes per character” option when it is set to “Autodetect”.
  • Object Navigator:
  • The error “Invalid SQL statement” no longer occurs on trying to expand the Editions node.
  • Database Monitor:
  • Slow SQL statements for blocked and blocking sessions now run faster in Oracle Databases 11.2. The fix also affects the Session Navigator.
  • DDL for Scheduled Jobs
  • Replaced single quotes with double quotes in the attribute statement event_condition => ‘TAB.USER_DATA.EVENT_TYPE = ‘‘JOB_OVER_MAX_DUR’‘’. DDL now generates with a correct attribute value RAISE_EVENTS => JOB_OVER_MAX_DUR.
  • Installer/Updater:
  • Fixed the installation procedure on a 32-bit Windows OS.
  • Profiler Wizard:
  • The settings to set/modify password parameters in the Profile Wizard are no longer missing.
  • Scenes:
  • An access violation error no longer occurs on trying to save the default scene after reconnecting a session.
  • Preferences:
  • Fixed local sorting of numeric columns when the “Display Numbers” option is set to “Numeric”.

New in SQLDetective 5.0.1 Build 159 (Apr 30, 2019)

  • IMPROVEMENTS:
  • Object Navigator:
  • Added the ability to customize the behavior of Ctrl+Click for database objects.
  • Added new options to “Preferences > Code Editor > Ctrl+click on an object”:
  • “Located it in Object Navigator”
  • “Opens it in Object Wizard”
  • “Opens it in Describe Object”
  • Preferences:
  • Increased the object name length to 128 characters.
  • BUGS FIXED:
  • Core:
  • Fixed fetching of LONG fields and extraction of DDL triggers and views.
  • Query Dataset:
  • The error “Out of system resources” no longer occurs on trying to run SQLDetective in trial mode when
  • “Query All Records” is enabled.
  • Dataset/Datagrid:
  • Unicode symbols are no longer broken on inserting/updating LONG fields.
  • Code Analyzer:
  • A naming rule violation is now triggered for sequences in PL/SQL.
  • A naming rule violation is now triggered for sequences on changing the NEXTVAL/CURRVAL keywords
  • case.

New in SQLDetective 5.0.1 Build 148 (Apr 18, 2019)

  • Technical debt metrics:
  • Calculate the price of fixing structural and logical imperfections detected by the code analyzer.
  • DB connections export:
  • Export existing database connections to an XML file in a click and keep them for further reuse.
  • Oracle Client and Microsoft Package:
  • Automatically check environment for the mandatory configurations and instantly connect to an Oracle DB.
  • And more:
  • Extract DDL for multiple objects directly into the code editor
  • Exclude system database objects from Call Trees
  • Easily switch between Oracle Homes in the redesigned DB Connection window
  • Instantly connect to a database from the startup window

New in SQLDetective 4.7.2 Build 281 (Mar 20, 2019)

  • Improvements:
  • Core:
  • It is now possible to protect data in a database from being modified. The protection is disabled by default.
  • Sped up work of the Export and Import Wizards, Object List, Object Navigator, Query Builder, Schema Analyzer, Schema Compiler, Schema Extractor, and Object Wizards when the “Exclude users with no objects from the Schema list” option is enabled. The option is disabled by default.
  • Applied new End User License Agreement.
  • UI/UX:
  • It is now possible to apply column autofit to the datasets and datagrids all over the application:
  • The autofit is now applied not only after opening, but also after refresh, filtering, sorting.
  • The autofit options were moved from the “Dataset Editors” page in Preferences to “Workspace”.
  • It is now possible to define the column width reduction in pixels.
  • A new option “Remember filter, sorting and column customization in datagrids with Dataset Manager” was added to Preferences. When enabled, filtering, sorting and changes made to columns in the Dataset Manager are saved and restored on the next application startup.
  • A new option “Automatically save modified scene” was added to “Preferences > General > Object Navigator” allowing you to automatically restore dataset customizations on the application startup. The option is enabled by default.
  • SQL Editor:
  • Optimized DBMS output retrieval.
  • It is now possible to save content from all the editor tabs to files. This functionality was also added to the Stored Program Editor.
  • Object Navigator:
  • Names of highlighted nodes are now written in white on the blue background.
  • Sped up algorithm of pop-up menu validation in the ContentSelector.
  • Sped up the process of populating a Database Object Tree, and added counting of the total number of DB objects in the background.
  • Query By Example:
  • Last used filters and sorting are now saved automatically under unique names. By default SQLDetective can save up to 16 filters. You can reduce the maximum number of auto saved filters at “View > Preferences > General > Workspace”.
  • Database Monitor:
  • Added the ability to switch between standard and pastel color schemes in diagrams. To use standard colors, disable “Use pastel colors in diagrams” at “Preferences > Database Monitor”.
  • Extract DDL:
  • It is now possible to select DBMS_METADATA for DLL extraction in the following Object Wizards: Consumer Group, Policy Group, Policy, Context, DB Link, Directory, Profiler, Resource Plan, Role, User, Rollback Segment, Synonym, Table, and Tablespace Wizards.
  • Session Navigator:
  • In the Module column, full names are now shown for all Conquest products.
  • Preferences:
  • Improved the layout of the “Workspace” page.
  • Online Support Desk (=OSD):
  • Improved look&feel of the “OSD – New Message” window.
  • Bugs fixed:
  • Core:
  • An access violation no longer occurs if there are broken StartMenuInternet keys in the registry.
  • SQL Editor:
  • Loading “heavy” queries no longer causes the application to stop working.
  • Date and time on the Explain Plan tab are shown correctly now.
  • The option “Open a new dataset for each query executed in a bundle” now works correctly.
  • Execution history is now saved correctly after executing scripts with unicode characters.
  • An error about insufficient access rights no longer occurs for non-DBA users trying to view statistics.
  • 125 or higher DPI is now correctly applied to the SQL Editor.
  • An unknown error no longer occurs on trying to copy data from the SQL Editor to Microsoft Excel.
  • It is now possible to break statement execution that was run without a DB connection.
  • Modifying the SQL Editor toolbar no longer moves the “Query all records” check box to the beginning of the toolbar.
  • The “Error” tab is now activated after execution of more than one error statement.
  • The error “ORA-00933: SQL command not properly ended” no longer occurs on trying to create JAVA objects.
  • An error “ORA-01008: not all variables bound” no longer occurs when a variable contains regional symbols.
  • Object Navigator:
  • An access violation no longer occurs on trying to open the Data tab for some tables.
  • Sorting of tabs is now correctly restored after the application restart.
  • When the same object is open in several tabs at once, these tabs no longer get synchronized.
  • Expanding/collapsing a node in the ObjectSelector no longer highlights this node and, consequently, does not update data in the ContentSelector.
  • An error “You cannot access field data beyond Eof.” no longer occurs on trying to apply a custom filter to the Object Navigator.
  • The error “ORA-00936: missing expression” no longer occurs on trying to open Table SubPartitions and Index Partitions.
  • Additional information is now shown in parentheses for Table Partitions and Table Subpartitions in the Object Navigator.
  • On selecting the SCOTT schema in the ObjectSelector, the ContentSelector now shows only those objects that belong to SCOTT, not all the objects from the database.
  • After restart, autofit of columns is now restored correctly on loading a Scene.
  • The unnecessary “Object Type” column was removed from the ContentSelector for such object types as Triggers, Java Sources, Java Classes, Java Resources, Sequences, Clusters, Rules, Editions, Schedules, etc.
  • The Find field is no longer in focus on opening the Object Navigator.
  • Code Editors:
  • The numbering of code lines no longer breaks when folding code lines are collapsed. Code Folding
  • Code folding now works correctly for the CASE clause in the SELECT statement.
  • Object Wizards:
  • The progress bar is now shown during tablespace allocation in the Tablespace and User Wizards. Database Connection
  • An access violation no longer occurs on changing DB type while a session is running. The error occurred in Windows 7 ×64 only.
  • It is now possible to connect to a database under a common user name that starts with “C##”.
  • Storage Manager:
  • Filter settings are no longer lost on trying to edit this filter.
  • Removing or changing the applied filter to another one now works correctly.
  • Text on the status bar is no longer cut with 125 DPI.
  • An access violation no longer occurs on opening the Storage Manager with 125 DPI.
  • Stored Program Editor
  • An access violation no longer occurs after debugging is completed.
  • An error “ORA-01036: illegal variable name/number” no longer occurs on running the Storage Program Editor.
  • Compare Databases:
  • “Fatal error” no longer occurs on comparing schemas from one database.
  • Top Session Locator:
  • Fixed the alignment of values in the grids: digital values are now aligned to the the right and text values are aligned to the left.
  • Query Builder:
  • The error message that appears on creating a wrong link between datasets no longer has the button to send a report to Technical Support.
  • Group Action:
  • Objects selected for execution are now shown correctly in the Group Action window.
  • Session Navigator:
  • An access violation no longer occurs on trying to close several sessions by clicking “Close Session” on the pop-up menu.
  • An access violation no longer occurs on trying to kill a session.
  • Query By Example:
  • The “Query By Example” editor now opens when more than one object is selected. Installer
  • Microsoft Visual C++ 2008 Redistributable Package (x86) is now correctly installed along with SQLDetective in all supported Windows systems.
  • GUI:
  • INVALID objects are now shown in gray in all the modules of the application.
  • Code Analyzer pop-up menu commands are no longer glued to their shortcuts.
  • Scenes:
  • It is now possible to scroll the text in the Scene Properties dialog box.
  • Relocate Wizard:
  • The rebuilding command is no longer executed on trying to remove/relocate a primary key to another tablespace.
  • Icon Dictionary:
  • The number of clicks on the IDIC and OSD icons is now counted correctly.
  • Resetting toolbar buttons now works correctly for “Dataset Manager > Columns” and “Storage Manager”.
  • Macro Recorder:
  • An access violation no longer occurs on trying to apply an icon to a Macro.
  • Telegram:
  • All custom toolbar buttons in the window of the Telegram client now have hints.
  • Online Support Desk (=OSD):
  • Pasting text in the window of an OSD message using Ctrl+V now works correctly.
  • Preferences:
  • “Workspace” page: “Select All” now works correctly.
  • Main Menu:
  • When multiple sessions are running, clicking “Close Session” now correctly detects the necessary session in the sessions list