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

ClearSQL Changelog

What's new in ClearSQL 9.3.2 Build 207

Nov 26, 2020
  • IMPROVEMENTS :
  • Trial Subscription:
  • To activate ClearSQL in trial mode, the user is now prompted to enter their payment details. After a 5-day evaluation period, the license will be automatically upgraded to the monthly subscription.
  • All trial users now have their personal Conquest accounts created after activating the trial subscription. This allows canceling the subscription, updating payment details, or upgrading to the full license.
  • Startup Window:
  • Added the ability to request a quote for a full license by clicking the “Request a quote” button in the startup window.
  • Analysis Log Manager:
  • Added the ability to locate the log file on the disk. The “Locate on Disk” command is now available from the pop-up menu.
  • Analysis log files are now deleted along with the corresponding project.
  • Print:
  • If an HTML file is bigger than 50 MB, the following message will be shown on clicking “Print Preview”: “You are about to preview an HTML file larger than 50 MB. This may cause performance and stability issues. Are you sure you want to continue?”
  • Added the ability to print out code metrics and code review results at the script level.
  • Summary Info:
  • Added the ability to abort the expansion of all nodes on the Summary tab if the process takes too much time.
  • Export to MS Excel:
  • On trying to export diagrams or code review results to MS Excel, make sure another file is not being edited in MS Excel at the same time. Otherwise, you will be prompted to stop editing cells in the open MS Excel file to proceed with the export.
  • Import Wizard:
  • If files/folders selected for import are no longer available on the disk, you will be prompted that these files/folders no longer exist.
  • Back Up/Restore Project:
  • Removed the “Backup folder” box as irrelevant.
  • BUGS FIXED Core:
  • Fixed the error “Could not initialize taskbar. Error:-2147467263” when running the application on Windows Server with Citrix.
  • The application’s features no longer stay inactive once the ORA-01005 error occurs after the database connection fails due to a missing password.
  • Code 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.
  • Code Explorer:
  • Resetting the workspace to default now restores the Code Explorer panel.
  • Database Connection Options
  • The error that is shown on trying to add a new database connection type with the existing connection type name is no longer handled by EurekaLog.
  • Code Metrics:
  • Script tags are no longer duplicated and subprogram names are no longer missing from the code metrics results exported to an XML file.
  • Database Connection Window:
  • Changing the state of the “Auto connection” check box now works correctly without the need to log into a database.
  • Project Summary:
  • When no project is loaded, all Summary tab features are unavailable.
  • Analysis Log Manager:
  • Fixed the look&feel of the Analysis Log Manager when there’s only one report in the list.
  • Startup Window:
  • Fixed the look&feel of the progress bar shown in the second instance while code analysis is running in the first instance. Relevant for the subscription type of license.
  • Link Manager:
  • Removed the ability to add new files and database objects.
  • Removed the ability to select multiple objects and the whole database object tree.
  • New Project Assistant / Import Wizard:
  • ClearSQL no longer stops working on trying to abort the import of the items that were not fully retrieved from the database.
  • Fixed the ability to break the “Select All” action in the database object tree.
  • Export Wizard:
  • Removed the “Yes to All” and “No to All” buttons from the warning message shown when the exported script or diagram already exists in the target folder.
  • Export Summary Tables:
  • The error message that appears when no MS Excel is installed is no longer duplicated.
  • GUI:
  • If the caption of a UI element, such as column header or item, is not fully visible, pointing to it now shows a hint with the full name.
  • Project Backup:
  • Fixed the visibility of the “Display password” check box in the dark theme.
  • Oracle Libraries:
  • Scripts that are part of an Oracle Library can no longer be edited or deleted separately from the whole library.
  • Toolbar Customizer:
  • A newly added toolbar icon is now located correctly.
  • Online Support Desk:
  • The “Reply to message” toolbar button is no longer active when an empty folder is selected.

New in ClearSQL 8.1.1 Build 224 (Apr 4, 2019)

  • IMPROVEMENTS:
  • Core:
  • Improved the application installation procedure:
  • The Conquest application installer now checks for the installation of Oracle Client and other prerequisites for a successful database connection.
  • The user is forwarded to the Conquest website to see the full set of database connection prerequisites and install Oracle Client, Instant Oracle Client, or Microsoft Visual C ++ Redistributable Package for Visual Studio.
  • CRUD Matrices:
  • It is now possible to view subprograms from a CRUD1 matrix, locate them in code, and view call trees for each subprogram.
  • The vertical layout of headers in CRUD1 matrices is now also available in Chrome and Firefox.
  • Added support for CRUD2 matrices at the column level:
  • Columns are now shown as subnodes of dataset objects.
  • It’s possible to view matrices for multiple columns.
  • Analyzer View:
  • Updated the order of tabs in the Project Analyzer and Script Analyzer View.
  • Added the ability to hide/show tabs in the Project Analyzer and Script Analyzer View:
  • Tabs are now listed on the “View > Project Analyzer View Tab/Script Analyzer View Tab” menu and can be enabled/disabled with the checkmarks.
  • By default, some of the Script Analyzer View tabs are now hidden.
  • Database Connection Window:
  • Added the ability to select Oracle Home from the drop-down list in the Database Connection window.
  • Added the ability to select all/none connections in the Last Connections list.
  • Added the ability to export and import database connections to and from XML.
  • Database Connection Options:
  • Updated the layout of the Connection Settings window
  • Code Formatter:
  • Added a new linefeed “Before the RETURN clause of a function declaration”
  • Code Insight:
  • The Code Insight window is now resizable; it is possible to save/restore window size.
  • Removed the colon “:” between a topic and a value.
  • Datatypes are now displayed right after the column name.
  • Datatypes of parameters and variables are now displayed in the Code Editor.
  • Code Analyzer:
  • Windows username is now always shown as a part of user comments.
  • Code Review Rules:
  • The violation of the rule “The alias is missing for a table reference in a multi-source query” is no longer raised if the table name used in the query is shorter than 4 characters.
  • Search Tool:
  • A double-click on a search result now locates the corresponding line of code in the Code Editor.
  • Added the “Locate in Code Editor” command to the Search pop-up menu
  • Project Report:
  • Full support of Unicode
  • Online Support Desk (OSD):
  • The OSD window and the New Message window are now displayed on the main window taskbar.
  • Installer/Updater:
  • On uninstalling the Conquest tool, the user is now forwarded to the website to fill out a short form explaining the reasons to quit.
  • BUGS FIXED:
  • Project Tree:
  • Creating new project scripts and/or folders now removes highlighting from the previous selection.
  • On trying to perform bulk synchronization of scripts with their database sources, the Project Tree pane is no longer colored in black and the application icon no longer becomes inactive.
  • After clicking “Refresh selected linked source”, scripts now get the “Link validated” status
  • Code Review Rules:
  • The rule “Unreferenced parameter” is no longer violated when the parameter is referenced only in the RETURN statement.
  • The rule “Runtime concatenations of string literals affect performance” now works correctly.
  • Code Formatter:
  • Fixed indentation of the PL/SQL CASE expression.
  • RAISE_APPLICATION_ERROR is now treated as an Oracle built-in procedure and is included in the user dictionary in upper case.
  • Code Analyzer:
  • Enabling the “Tagline” option no longer removes line breaks, causes code line duplication, or adds empty lines.
  • Import Wizard:
  • The error “No argument for format” no longer occurs on trying to import files from the Project Tree pop-upmenu.
  • Summary Into:
  • The Quality Trend panel is no longer empty when the root project node is selected with the checkmark in the Project Tree.
  • Job Manager:
  • Clicking “Run Job Now” no longer makes the initial application instance inactive.
  • Analysis History:
  • Changing the identifier case no longer causes the Code Metrics history to disappear after re-analyzing the script.
  • Synchronization Settings:
  • Fixed the width of the filter fields.
  • Main Window:
  • Autofit now works correctly when the Project Tree is disabled in the active workspace.

New in ClearSQL 8.0.1 Build 169 (Mar 20, 2019)

  • New:
  • Metered License. A new license that provides a monthly subscription including 100.000 lines of code.
  • Technical Debt. A new code metric to calculated an assumed cost of fixing structural imperfections incode.
  • “Avoid duplicate code.” A new code review rule detecting similar lines of code, blocks, and scripts ina ClearSQL project.
  • Quality Trend. A graphical chart representing a trend of issues detected during code analyses
  • Improvements:
  • CoreThe new trial version of ClearSQL is now available without feature limitations and is active for 5 days.
  • The service Annual Maintenance & Support is no longer automatically renewed for another period. Now itwill get expired in a year but can be extended for another period upon request.
  • The usage of lines of code in a subscription is shown as a graph in the Startup and Analyzer Progress windows.
  • New startup window:
  • Added the ability to buy a subscription plan from the application.
  • Added a graph representing the status of the subscription plan.
  • Redesigned the look&feel of the window
  • Analyzer View:
  • Identification numbers of code review rules are now shown in the rationale panel on the Code Review tab.
  • When a folder is selected, the Analyzer View tabs are now hidden as irrelevant. The tabs are shown onlywhen a script is selected.
  • Added the section “Anonymous blocks” to “Structure View > Module Analysis”.
  • Summary Info:
  • Thousands, millions, etc., in the summary results are now shown with the multiplier suffix, e.g. 100k, 2m.
  • Pointing on the parts of a pie chart now shows hints with the corresponding values.
  • Moved the toolbar to the top of the Summary tab.
  • Information about duplicate code is now shown on the Summary tab.
  • SQL*Plus:
  • Optimized work of SQL*Plus.
  • Improved messages related to the SQL*Plus feature.
  • SQL*Plus options are now available on the Code Editor pop-up menu.
  • Import Wizard:
  • Accelerated the work of the options that hide/show system and sample schemas.
  • Added the ability to search for files and objects in the file system and database.
  • File extensions used in the filter are now shown on the status bar of the wizard.
  • Updated the messages shown on trying to import scripts that already exist in the project.
  • Project Manager:
  • November 12, 20182/3Html tags no longer appear in the captions of the Code Review filter.
  • Analyzer Progress:
  • Updated the information message shown before running a project analysis.
  • Project Tree:
  • On trying to save a project to another file, the user is now prompted to save changes to the current project.
  • Project Report Assistant:
  • When the project is filtered, the option to select the whole project for a report is now called “Include wholeproject (filtered)”.
  • Project Report:
  • Removed group names from the Observations pages.
  • Code Analyzer:
  • Package body variables are now included in Instrumented Code.
  • Export Wizard:
  • The image export format is now shown on the wizard’s status bar.
  • Code Editor:
  • The object owner is now added to default comments generated by ClearSQL on object import.
  • Project Analysis Report:
  • Added a new total value: the number of times a project has been analyzed.
  • Bugs Fixed:
  • Core:
  • An access violation error no longer occurs when an application with a long title is running in Windows.
  • A project copy is now saved under a new name with the postfix “copy”.
  • Call Trees:
  • Fixed generation of Call Trees for standalone procedures imported to a ClearSQL Project including their object owners.
  • Fixed highlighting of Call Tree diagrams in SVG format.
  • Import Wizard:
  • Enabling “Hide system schemas” now removes all relevant nodes from the tree.
  • Importing package specs with their package bodies no longer raises the warning message that suchobjects already exist.
  • Scripts that have comments defined between the object type and object name are now imported correctly.
  • Objects with similar names but different owners are now imported correctly.
  • The option “Uncheck All” on the “From Database” tab is no longer available when nothing is selected in the tree.
  • Preferences:
  • Sorting of the summary code metrics is now reset to default correctly.
  • Default sorting of the summary code metrics in Preferences is set to Cyclomatic Complexity, descendingand it no longer differs from the sorting on the Summary tab.
  • The eye icon now works correctly in the “Password” field of the Internet Connection page.
  • Unsaved preferences are no longer restored after restarting ClearSQL
  • Code Analyzer Options:
  • The filter on the Code Review Options page is no longer hidden when DPI 125% and higher is applied.
  • Clicking “Uncheck All” on the Code Review Options page and in the Rule Suppression Template Editorwhen a filter is applied now unchecks only filtered items.
  • Summary Info:
  • The maximize button is now available on all panels.
  • Script statuses now correctly fit in the “Folder, Scripts, Script Statuses” panel.
  • Project Tree:
  • Clicking “Select None” now leaves one node selected, and the status of the “Analyze” and “Syntax check”options is now validated depending on the type of selection
  • Project Report:L
  • Added explanation hints to the links on the Report Summary page.
  • Invalid or outdated diagrams and matrices in a project report are now marked with a red warning message.
  • Split/Rename Project Script:
  • Fixed the error that is shown on trying to rename a non-txt script.
  • Fixed the error message shown on trying to rename a script according to its object type.
  • Project Manager:
  • Fixed the order of code review rules in the “By Code Review” filter.
  • Analysis History:
  • Summary charts are no longer duplicated.
  • Analyzer View:
  • Fixed handling of the toolbar visibility, so the Analyzer View tabs no longer blink while a new license key is applied in Preferences.
  • Code Review Options:
  • The option “Revert Modifications” now works correctly.
  • Toolbar:
  • The options “Unlink all scripts from the linked sources” and “Unlink selected items from the linked sources”no longer appear in the list of options that can be added to the Project Tree toolbar.
  • GUI:
  • Captions on the Code Review tab are now shown correctly when the Splash window is open.
  • Autofixes:
  • Autofixes are no longer lost when a new script version is created.