Release Notes - 3.7

  • 3.7.25-funcrel
    Fixes TCC of the SQL Script Call to Program end points.
    Fixes missing XXL table size values on DB2 tables.
    Fixes incorrect call link between a COBOL Program and a Table.
    Improves data-sensitive property values at the table level
  • 3.7.24-funcrel
    Improves the parsing of Oracle PL/SQL files with parameters.
    Adds SQL Call to programs/c/c++functions/java methods objects for SQL External procedures created in system databases / schemas.
    Adds SQL calls to programs/C/C++ functions/Java methods/objects in the TCC configuration file.
  • 3.7.23-funcrel
    Fixes random access links between C# methods and table’s columns.
    Fixes missing violation for the quality rule “Avoid non-indexed SQL queries” on a JDBC SQL Query object.
    Fixes incorrect SQL Missing Table objects created for table’s aliases in DELETE statements.
    Fixes the issue where no database table objects are created from a PostgreSQL file when “AS $$” appears in a casted expression. 📝 56890
    Fixes incorrect missing object created from some JCL SQL Query’s Sqlquery property. 📝 56883
    Fixes the issue where some database objects are not created from a T-SQL file when [Create User XX] appears in a table’s column name. 📝 57125
    Adds ‘SQL Call to Program’ objects for a better linking to external procedures.
    Adds ‘SQL Call to Java Method’ objects for a better linking to external procedures.
    Adds ‘SQL Call to C/C++ Function’ objects for a better linking to external procedures.
    Ignores data-loading SQL files.
    Ignores pf/lf files that are not real DDS files.
  • 3.7.22-funcrel
    Fixes missing SQL Synonyms objects. 📝 56558
    Fixes missing link between external Db2 for i SQL procedure implemented in RPG and RPG program when both objects are in the same application.
    Improves SQL Analyzer link creation performance while enabling RDBMS migration rules and SQL Missing Objects.
  • 3.7.21-funcrel
    Fixes intermittent fluctuation in Missing Table objects between sequential runs.
    Fixes handling of object names with diacritics in ASCII-encoded files.
  • 3.7.20-funcrel
    Fixes unanalyzed pkb & pks files. 📝 55469
    Removes incorrect missing procedures and links. 📝 55493
    Fixes slow analysis. 📝 55583
    Removes incorrect temporary objects visible in imaging.
    Fixes incorrect Oracle Method names. 📝 55684
    Removes incorrect missing objects.
  • 3.7.19-funcrel
    Fixes incorrect cyclomatic complexity for stored procedure having ELSE IF statement. 📝 55558
    Removes Oracle incorrect missing procedures and tables. 📝 55493
    Removes incorrect missing procedure named $.
    Removes incorrect missing table and procedures.
    Fixes missing use link between view and table created from LF and PF files, due to the case difference.
    Fixes SQL-004 warnings during the create links step.
    Oracle : Fixes pkb and pks files unanalysed by the SQL analyser. 📝 55469
    Fixes missing use select link between stored procedure and table.
    PostgreSQL : Fixes missing refer link between tables. 📝 55371
  • 3.7.18-funcrel
    Fixes missing use link from view to table due to MySQL syntax issue : SELECT … FROM `table_name``table_name`. 📝 54608
    Fixes performance issue during run extensions at application level. 📝 54608
    Fixes incorrect variant PostgreSQL detected instead of Db2. 📝 55035
    Fixes the missing link between the C/C++ SQL query and a stored procedure called inside an execute immediate.
    Fixes performance issue during the creating link step for an Oracle file when RDBMS Move to Cloud is activated.
    Fixes Db2 stucks during creating links step. 📝 54856
    Fixes missing IBM Db2 for i tables / views.
    Fixes warnings while parsing SQL file. 📝 55362
  • 3.7.17-funcrel
    Adds support for SQL Server to Azure SQL migration path.
  • 3.7.16-funcrel
    Fixes End Migrate Oracle Projects for the application Application with exception: ‘NoneType’ object is not iterable.
    Removes false “missing procedure” which is in fact an alias used in several MERGE queries. 📝 53914
    Fixes SQL-004 warnings.
    Fixes false “missing tables”. 📝 53913
    Fixes missing link between procedure and table. 📝 53690
    Fixes missing schema named DEFAULT.
    Adds extra spaces in the column data type property when needed.
    Fixes the wrong link between an Entity Operation and a SQL table. 📝 54359
    Fixes performance issue during Oracle linking.
    Fixes performance issue during SQL Server linking.
    Fixes SQL analyzer performance issue during link phase. 📝 54102
  • 3.7.15-funcrel
    Fixes incorrect variant detection.
    Fixes .sql file not analyzed when, from the total number of DML statements, 81.82% are INSERT in a context of Db2 for i analysis.
    Fixes missing links.
    Removes pympler.
    Adds support of the FORMAT keyword in .pf/.lf files. It will bring the columns to these tables and views.
    Adds data type and column length property to the table’s column declared in .pf/.lf files.
  • 3.7.14-funcrel
    Fixes wrong database type discovered by SQL analyzer. 📝 53445
    Removes incorrect missing table.
    Fixes missing Use Insert link for incorrect SQL Query statement : INSERT <TABLE_NAME>.
    Fixes linking performances for packages.
    Fixes missing links to synonyms from SQL objects when links are created to referenced table. 📝 53629
    Adds support for SQL Server to Azure SQL migration path.
  • 3.7.13-funcrel
    Fixes Engineering Dashboard visibility for all RDBMS Move to Cloud migration rules.
    Fixes missing call link from shell script to SQL stored procedure. 📝 52371
    Fixes merged primary keys that do not have the same SQL variant. 📝 52477
  • 3.7.12-funcrel
    Fixes missing function and trigger objects. 📝 52387
    Fixes merged tables and indexes that do not have the same SQL variant. 📝 52477
    Fixes incorrect links between stored procedures and tables, that do not have the same SQL variant. 📝 52511
    Fixes incorrect access write links. 📝 52747
    Fixes incorrect missing table object.
    Fixes incorrect name of a missing procedure object.
    Fixes a missing reylon link between synonyms and table objects.
    Fixes incorrect missing .NET procedure objects created when T-SQL stored procedures already exist.
    Fixes GUID migration error when using Core 8.4.x.
    Db2 for i: Added support for system names for tables : https://www.ibm.com/docs/en/i/7.4.0?topic=statements-create-table external link. 📝 52298
    Added support for SQL external procedure/function. The following languages are supported : COBOL, COBOLLE, RPGLE, RPG, CL, C, C++, JAVA, ASSEMBLE, PLI, REXX.
    Added support for Db2 to Oracle migration path for com.castsoftware.sql.movetocloud extension.
    Added support for Db2 to SQL Server migration path for com.castsoftware.sql.movetocloud extension.
    Added Use Select links between cursor embedded in RPG code (FETCH cursor_name) and selected tables (in DECLARE cursor_name).
  • 3.7.11-funcrel
    Fixes an issue (due to table duplication) preventing table objects from being created even when the correct DDL scripts are delivered. 📝 51936
    Fixed missing links from Functions to Tables, when strings with dynamic SQL code are not executed. E.g. : sql_statement = ‘select * from table_name’ return sql_statement. 📝 52048
    Fixed incorrect “missing table” object created when a Cassandra table exists.
    Oracle: added missing “relyon” link between Function / Procedure and Table / Type when variables are declared as “%ROWTYPE” or “%TYPE”.
    Added support for CREATE statements in comments (executable comments).MySQL: Add support fore executable comments
  • 3.7.10-funcrel
    DB2 : fixed incorrect merge of table having the same name, created in the schemas having the same name but in different databases. Added the database name in the full identifier of views and indexes, when the view / index are created in the same file with table, just after the CREATE TABLE statement. 📝 51613
    Oracle : fixed traceback raised by SQL Analyzer during analysis. 📝 51180
    MySQL: Added support of the DEFINER clause in the CREATE TRIGGER statement. 📝 51524
    Fixed traceback warning during CREATE FUNCTION statement analysis.
    Fixed missing use link between a SQL Query and a DEFAULT.table_name when the schema name cannot be resolved and the table is accessed via a SCHEMA_NAME (SCHEMA_NAME.TABLE_NAME).
    Fixed unexpected Missing Table SCHEMA_NAME.TABLE_NAME created when a DEFAULT.TABLE_NAME already exists.
    Oracle USING INDEX TABLESPACE storage clause should not create a SQL Index named TABLESPACE.
    Added support for Oracle Forms and Reports objects. 💎 1101062
    Added support for Oracle Forms and Reports objects. 💎 1101024
    Added support for Oracle Forms and Reports objects. 💎 1101052
    Added support for Oracle Forms and Reports objects. Fixed typo in the rule name WHEN OTHER replaces with WHEN OTHERS. 💎 1101054
    Added support for Oracle Forms and Reports objects. 💎 1101064
    Added support for Oracle Forms and Reports objects. 💎 1101030
    Added support for Oracle Forms and Reports objects. 💎 1101074
    Added support for Oracle Forms and Reports objects. 💎 1101072
    Added support for Oracle Forms and Reports objects. 💎 1101076
    Added support for Oracle Forms and Reports objects. 💎 1101012
    Added support for Oracle Forms and Reports objects. 💎 1101028
    Added support for Oracle Forms and Reports objects. 💎 1101008
    Added support for Oracle Forms and Reports objects. 💎 1101086
    Added support for Oracle Forms and Reports objects. 💎 1101002
    Added support for Oracle Forms and Reports objects. 💎 1101016
    Added support for Oracle Forms and Reports objects. 💎 1101084
    Added support for Oracle Forms and Reports objects. 💎 1101018
    Added support for Oracle Forms and Reports objects. 💎 1101098
    Added support for Oracle Forms and Reports objects. 💎 1101034
    Added support for Oracle Forms and Reports objects. 💎 1101000
    Added support for Oracle Forms and Reports objects. 💎 1101030
    Added support for Oracle Forms and Reports objects. 💎 1101004
    Added support for Oracle Forms and Reports objects. 💎 1101006
    Added support for Oracle Forms and Reports objects. 💎 1101014
    Added support for Oracle Forms and Reports objects. 💎 1101114
    Added support for Oracle Forms and Reports objects. 💎 1101058
    Added support for Oracle Forms and Reports objects. 💎 1101066
    NEW Replaced 7424 Avoid using SQL queries inside a loop with a new one 1101116 Avoid using SQL queries inside a loop (SQL). The rule is also applying to Oracle Forms and Reports objects. 💎 1101116
    Oracle Forms and Reports objects, created by com.castsoftware.formsreport, are from now linked by SQL Analyzer. SQL quality rules are also calculated during the step “Run extensions after analysis”.Added support of linking and quality rules for Oracle Forms and Reports objects.
    In order to ensure transactions are valid and reach their end point.Declared SQL Missing procedure as transaction end point.
    This ensures transactions are valid and reach their end points.Declared SQL procedures, functions, views and DML scripts as end points.
    Improved performances for Oracle package’s analysis during the create links step.
  • 3.7.9-funcrel
    Fixes an issue causing the “run extension” step to fail at application level during the analysis. 📝 50410
    Oracle: fixed missing links between PL/SQL stored procedures with same name when they belong to different packages. 📝 50494
    Fixed unexpected missing table when the table name is a parameter. E.g. : select * from ${dbschema}.${tableId}. 📝 50131
    Fixed missing links between Db2 views and Db2 tables. 📝 50787
    Fixed missing Sensitive Data Option in V3 Imaging.
    Fixed missing table ( .net) named Release is not created.
    Fixed too many warnings SQL-001: No schema found, while the uaxdirectory seems to have the schema referenced.
    Fixed traceback raised by SQL Analyzer, for a Java Hibernate SQL Query “update from…”.
    DB2 : fixed incorrect Unique Key Constraint named LABEL created when key label is specified at the table level for encryption (KEY LABEL key-label-name or NO KEY LABEL). Merge duplicate tables, having the same create statement, in different SQL files.
    Fixed false positive violations for the rule “Avoid OR conditions testing equality on the same identifier in SQL WHERE clauses” when the OR conditions are in different parentheses. 💎 1101038
    Fixed false positive violations for the rule “Avoid using SQL queries inside a loop” when analyzing Microsoft SQL Server source code. 💎 7424
    Support has been added for various RDBMS: Microsoft SQL Server 2022, Oracle Server 21c and 23ai, PostgreSQL 17.x and CockroachDB 24. See also: Vendor compatibility matrix - official support.Update vendor compatibility
  • 3.7.8-funcrel
    Fixes an issue in the file “migrate_sql_project_name_in_guid.sql” causing the extension installation step to hang. 📝 49703
    Fixes an issue causing a missing link from Cobol SQL Query objects to Oracle function objects. 📝 50345
    Fixes an issue causing a missing link from Cobol SQL Query objects to Table through Synonym objects. 📝 49971
    Fixes an issue causing missing links between Entity Operations / SQL Queries and Synonyms / aliased objects.
    Fixes an issue causing the the analyzer to detect the incorrect RDBMS Vendor type: DB2 for I instead of Oracle.
    Fixes an issue causing traceback warnings and duplicate GUIDs when analyzing Sybase ASE SQL files.
    Fixes an issue causing the creation of strange/not meaningful missing procedures named “{}?{}, {}’{}’{}”.
    Added more information to the analysis log, specifically during the Inference Engine Queries loading step.
    Updated the documentation to improve information about the links generated by the analyzer, see: https://doc.castsoftware.com/technologies/sql/extensions/com.castsoftware.sqlanalyzer/3.7/#links external link.
  • 3.7.7-funcrel
    Fixes an issue causing a false positive violation of the rule 1101000 “Never use SQL queries with a cartesian product (SQL)” for SAP Method SQL Script Functions containing a JOIN which uses the table name as a parameter, e.g. : table_name1 join :parameter_name. 📝 49560
    Fixes an issue causing the analyzer to fail to find the end of a SQL Server stored procedure containing XML tags in string expressions, in turn causing the remaining code in the relevant file to be analyzed as if it were part of the procedure. 📝 49437
    The description of the object “SAP Method SQLScript Procedure” has been changed to “ABAP Managed Database Procedure”.
    Improved the detection of Oracle variant.
    Fixes an issue causing the wrong vendor type to be detected on a Cobol file with .SQL as its extension.
    Fixes an issue causing a false positive violation of the rule 1101000 “Never use SQL queries with a cartesian product (SQL)” for SAP Method SQL Script Functions containing a JOIN which uses the table name as a parameter, e.g. : table_name1 join :parameter_name. 💎 1101000
    Added support for Missing Tables and Procedures for Java JSP projects in the com.castsoftware.jee.missingtable extension.SQLSCRIPT-1386
    Missing tables and procedures objects generated by this extension have been changed from the “external” to “internal” object type category. As a result of this change, objects are now visible in the Transactions > Data Entities section in CAST Imaging/Console, and in addition, where an existing application with unchanged source code is re-analyzed with this new release, the number of Data Function Points will increase.SQLSCRIPT-1385
  • 3.7.6-funcrel
    Mainframe related analyses: Fixes an issue causing the analysis to hang during the “run extension after analysis step, within the stage “Start calculating client server quality rules”. 📝 49250
    IBM for i related: Fixes a false Cyclomatic Complexity value for Views based on “lf” files. 📝 49242
    IBM for i related: Fixes a missing table issue when the table is prefixed by a schema starting with “&”, e.g. : “CREATE TABLE &VAR/OTTO (COL1 INT, …);”. 📝 49253
    Fixes an issue causing missing links between CRUD Entity and Table. 📝 48868
    XXXL Mainframe application: Fixes a performance issue during the application level step for SQL Analyzer. Removed unuseful logged messages.
    Mainframe XXXL application: Fixes a performance issue during the application level step, impacting the calculation of client server quality rules.
    Fixes an issue causing the generation of an incorrect Missing Procedure object.
    Fixes an issue causing a runtime error at application level for a CTLProgram object.
    Minor update to add code “bookmarks” for monitor links.
  • 3.7.5-funcrel
    Fixed false links from SpringData Query to Tables. 📝 48461
    Fixed issue with PostgresSQL tables identified as DB2 / Oracle tables.
    Fixed Oracle built-in functions wm_concat, LISTAGG and NUMTODSINTERVAL reported as Missing Procedure.
    Fixed performance issue during application level at the step “removing UA select all properties for SQL Analyzer Objects and objects from languages having SQL Named Queries objects”.
    Fixed duplicated tables when create statements are similar.
    Fixed error during application level at the step “adding missing links between SQL embedded queries and SQL Tables / Views / Procedures / Functions”.
    Fixed an issue causing the property “Raw SQL Complexity” to not be generated for Java Methods.
    Fixed a performance issue in the post-application step pushing links from synonyms to aliased objects for Mainframe applications.
  • 3.7.4-funcrel
    PostgreSQL: fixed missing SQL objects due to a misinterpreted regular expression. 📝 48078
    Fixed Missing Table not created when the table belongs to system schema.
    Fixed SQL-002 warning raised by a “CREATE INDEX” statement with a column named “KEY” in the list of indexed columns. E.g. : “CREATE INDEX index_name ON table_name (column_name, KEY)”.
    Cobol SQL Query: fixed a missing link to a table column object.
    Fixed LF and PF files analyzed in RPG and SQL Analyzer.
    PostgreSQL: fixed built-in functions which are created as missing procedure / table objects.
    Fixed an issue causing SQL files to be ignored (visible in com.castsoftware.sqlanalyzer 3.6.19).
    NEW Added a new rule named Avoid “SELECT *” queries (SQL) which replaces the rule 7344: Avoid “SELECT *” queries for the SQL objects and also for the SQL Query objects. This quality rule reports the SQL artifacts containing queries using the “SELECT *” statement. It applies to DDL as well as DML, including embedded SQL in client code when materialized by a SQL Query object. Not all “SELECT *” queries are reported in violation, some of them are ignored. E.g.: SELECT * FROM a single table in VIEWs / MATERIALIZED VIEWs, CREATE TABLE AS SELECT * FROM a single table, SELECT * INTO table_name FROM a single table, EXISTS(SELECT *, NOT EXISTS(SELECT *, SELECT * EXCEPT(…). 💎 1101114
    Fixed an issue causing false positive violations when the primary key is added in the same alter table statements with a default constraint, in the second position. E.g.: “ALTER TABLE table_name ADD CONSTRAINT default_name DEFAULT (default_value) FOR column_name, CONSTRAINT pk_name PRIMARY KEY (list_of_the_columns).” 💎 1101022
    Fixed an issue causing false positive violations when the clustered index is added in the same alter table statements with a default constraint, in the second position. E.g.: “ALTER TABLE table_name ADD CONSTRAINT default_name DEFAULT (default_value) FOR column_name, CONSTRAINT pk_name PRIMARY KEY (list_of_the_columns) CLUSTERED”. 💎 1101090
    Added Raw SQL Complexity Metric for SQL Query objects.SQLSCRIPT-1325
    Added a specific property named “System object” for any SQL system objects detected.SQLSCRIPT-1338
    When PostgreSQL objects are created without specifying any schema name, by default such objects are automatically put into a schema named “public”. From now on, “public” will be considered by com.castsoftware.sqlanalyzer as the DEFAULT schema for PostgreSQL objects.SQLSCRIPT-1339
  • 3.7.3-funcrel
    Added support for CREATE EXTERNAL TABLE statement. 📝 47746
    Fixed incorrect link to a table which has same name but different parent schema to the one referenced in the Dapper SQL Query object. 📝 47857
    Fixed ValueError: invalid literal for int() with base 10: ‘100000 00270000’ during table’s size loading.
    Fixed missing useSelect link between FETCH Cobol Query and Table.
    Fixed missing links between JPA Query and JPA Entity Operation and SQL Tables.
    Fixed WARNING during run extensions after analysis when adding missing links between SQL embedded queries and SQL objects.
  • 3.7.2-funcrel
    Fixed a WARNING occurring during the run extension step after an analysis, for Mainframe applications.
    Fixed missing links between JPQL Query and SQL Table objects.
  • 3.7.1-funcrel
    Oracle: Some SQL files, with data export / loading statements, were previously and incorrectly considered as DML. This has now been fixed. 📝 47343
    Fixed incorrect links created from procedure to a table named SET (MERGE INTO… UPDATE SET syntax). 📝 46682
    Fixed missing links between SQL Query objects and Table objects due to a crash at the application level. 📝 46591
    Fixed multiple “AttributeError” issues found in in com.castsoftware.sqlanalyzer 3.6.11-funcrel.
    Fixed and removed duplicated objects.
    Oracle : Fixed SQL-004 warning.
    Rules for Cobol SQL Embedded Query objects: removed Cobol file parsing at application level. To benefit from this fix, you should use at least the version 1.1.0-funcrel of com.castsoftware.mainframe.
    Oracle: improved the process of merging duplicate objects.
    Fixed RuntimeError (“Cannot use Object.get_property() if property has not been loaded”).
    Fixed an issue causing a SQL Missing table object to not be created and a duplicate GUID message to be logged in the application level file.
    Fixed invalid Missing Procedure object when a Package Procedure with the same name also exists.
    T-SQL: fixed false positives for the rule “Always define column names when inserting values” when WITH tables hints are used. 💎 1101026
    Fixed a random missing violation for the rule “Avoid non-indexed SQL queries”. 💎 1101004
    T-SQL: fixed false positives for the rule “Never use SQL queries with a cartesian product (SQL)” when a SELECT is used in dynamic SQL. 💎 1101000
    T-SQL: fixed false positives for the rule “Avoid non-SARGable queries” when a SELECT is used in dynamic SQL. 💎 1101008
  • 3.7.0-funcrel
    Fixes an issue causing SQL-004 warnings for 5 files during link creation phase for an Oracle analysis. 📝 45553
    Fixes an issue where the analysis became stuck after the “DssRun” step finished successfully. 📝 45635
    Fixed tables columns reported as missing procedures. 📝 45659
    Fixed missing links between Cobol SQL Query and Tables. 📝 46125
    Fixes an issue where some objects (Synonyms, Missing Tables) were incorrectly set as “end points” isntead of “data entities” for transaction purposes.
    Removed SQL Analyzer log messages from analysis units that are not SQL related.
    Cobol SQL Query object: fixed missing links when FETCH is used with NEXT ROWSET.
    Fixed missing links between JPQL Query and SQL Tables.
    Oracle PL/SQL scripts: a change has been implemented to ensure that a BEGIN in a PROMPT statement is no longer considered the beginning of a block statement.
    JDBC SQL Query objects: fixed incorrectly created Missing table object for CREATE TABLE statements.
    Spring JDBC Query obejcts: fixed missing links for tables that have the same name.
    CTLCode objects: fixed missing links between CTLCode and SQL Table objects when the name of the table is PRINT.
    Fixed duplicated tables.
    DotNet Enterprise Library SQL Query object: fixed an issue causing a missing Procedure.
    Fixed duplicated synonyms.
    Improved application level performance.
    Fixed false positive violation which was occurring when the table’s schema name is a parameter. 💎 1101026
    Added the support for missing tables for Entity ORM CRUD operations. You should install com.castsoftware.sqlanalyzer >= 3.7.0-funcrel if you have Entity Operations in your applications and you are already using com.castsoftware.entity >= 2.2.12-funcrel.Support for missing tables for Entity Operations
    Added support for the linking between IMS SQL Query objects and IMS DB Segment objects. Available with com.castsoftware.mainframe >= 1.4.0-alpha1 and com.castsoftware.wbslinker >= 1.7.33.Support fo IMS linking
  • 3.7.0-beta5
    Fixed false positive on the rule 1101106 “Avoid tables without primary key / unique key constraint / unique index”. 📝 40693
    Fixes an issue causing missing “belongs to” links. 📝 41969
    Improved links for SQL DML files: DML files are now considered as data exports only when INSERTs have static data. 📝 44556
    Improved detection of DATA exports vs DML files.
    Fixed SQL-002 parsing issue raised on ALTER TABLE … RENAME statement.
    Fixed missing insert link from Spring JDBC Query to SQL Table.
    Fixed application level error.
    Fixed false positives for the rule “Avoid tables without primary key / unique key constraint / unique index”. 💎 1101106
    Added callLink from a Method’s Type via another Method’s Type when an object’s method is called indirectly, via a variable.ORACLE : Object Types : added call link for indirect calls
    Added relyonLink from Type’s Method to another Type/Table when parameters/variables datatypes are Type/Table Columns.ORACLE : Object Types : added relyon link for parameters/variables datatypes
    The link inheritLink has been changed to inheritExtendLink.ORACLE : Object Types : changed link type from sub Type to super Type
    Added inheritOverrideLink from a Method’s Type which overrides a super Type’s Method.ORACLE : Object Types : added new link between methods
    Added support for missing tables for .NET/JEE ORM CRUD operations.Support for missing tables
    Moved the linking of ORM CRUD Operations with SQL Tables/Views from Universal Linker (com.castsoftware.wbslinker) to SQL Analyzer.Link ORM CRUD Operations with SQL Tables/Views
  • 3.7.0-beta4
    Fixed incorrect missing table object “LOCKS” created for SQL statement “USE AND KEEP UPDATE LOCKS”. 📝 44816
    Fixed an issue causing the error “ERROR: negative substring length not allowed.” 📝 44915
    Fixed false link between SQL Server Procedures and Db2 Tables. 📝 42424
    Changed SQL Analysis objects GUID’s. The analysis unit name logged in the analysis log will no longer contain the numeric suffix. Eg.: a previous GUID “SQLScriptFunction?Main_sourcesDatabase_36645.CASTPUBS.STORENAME_PROC” will change to “SQLScriptFunction?Main_sourcesDatabase.CASTPUBS.STORENAME_PROC”. During the update to the new version, all SQL Analyzer GUID’s will be migrated.
    When two missing objects with same name are created one in DEFAULT the second in a named missing schema - because the object is prefixed - the one in the DEFAULT schema should be merged in the second one, from the named schema. E.g.: for the following SQL Embedded Queries: “select * from TOTO.TATA and “select * from TATA” a single Missing Table will be created : “TOTO.TATA.TATA”.
    Fixed Invalid name assigned to artifact when %SCHEMA% prefix is used in SQL script. E.g. : “CREATE PROCEDURE %SCHEMA%.TOTO” … previous to the fix the SQL Procedure was named “%” and now the name is “TOTO”.
    Fixed false positives / negatives for “Avoid non-SARGable queries”. 💎 1101008
    Fixed false negatives for “Avoid using LIKE conditions without wildcards”. 💎 1101102
    Fixed false negatives for “Avoid using dynamic SQL in SQL Artifacts”. 💎 1101024
    Fixed false positives for “Avoid Tables without a clustered Index (SQL)”. 💎 1101090
  • 3.7.0-beta3
    Fixed Trigger and Index fullnames when only the table name is prefixed. 📝 43979
    Fixed random metric inconsistency for metric “Max Control Statements Nested” for duplicated objects, created in different SQL files.
    Fixed false link between a procedure and a table, when table is not in the procedure scope.
    The default session database is correctly detected.Add support for the Teradata statement DATABASE <DATABASE_NAME>;
  • 3.7.0-beta2
    Fixes an issue causing the creation of a “SQL Missing Table” object when a standard SQL table obejct with the same name already exists.
    Fixed a false positive violation on the rule 1101006 “Avoid non-indexed XXL SQL queries”. 💎 1101006
    Fixed a false positive violation on the rule 1101008 “Avoid non-SARGable queries”. 💎 1101008
    Fixed a missing violation for the rule 1101076 “Avoid unqualified column references”. 💎 1101076
    Added support for “Migrate DB2 to MySQL” advisor rules in com.castsoftware.sql.movetocloud extension.New advisor: Migrate DB2 to MySQL
  • 3.7.0-beta1
    Fixed missing Oracle procedure and package objects when the SQL file is considered as DML instead of DDL. 📝 43519
    Fixed SQL-002 analysis warning for ALTER TABLE statements.
    Removed false positives when the table is filtered via a CASE statement. And also in the situation when multiple tables with the same name are matching for the selected table. 💎 1101006
    More file extensions are supported. You can find all details in the official documentation https://doc.castsoftware.com/display/TECHNOS/SQL+Analyzer+-+3.7#SQLAnalyzer3.7-Supportedfileextensions external link.Added the support for new SQL file extensions.