Release Notes - 3.7

3.7.6-funcrel

Resolved Issues

Customer Ticket Id	Details
49250	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".
49242	IBM for i related: Fixes a false Cyclomatic Complexity value for Views based on "lf" files.
49253	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, …);".
48868	Fixes an issue causing missing links between CRUD Entity and Table.

Other Updates

Details
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

Resolved Issues

Customer Ticket Id	Details
48461	Fixed false links from SpringData Query to Tables.

Other Updates

Details
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

Resolved Issues

Customer Ticket Id	Details
48078	PostgreSQL: fixed missing SQL objects due to a misinterpreted regular expression.

Other Updates

Details
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).

Rules

Rule Id	New Rule	Details
1101114	TRUE	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(…).
1101022	FALSE	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)."
1101090	FALSE	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".

New Support

Summary	Details
SQLSCRIPT-1325	Added Raw SQL Complexity Metric for SQL Query objects.
SQLSCRIPT-1338	Added a specific property named "System object" for any SQL system objects detected.
SQLSCRIPT-1339	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.

3.7.3-funcrel

Resolved Issues

Customer Ticket Id	Details
47746	Added support for CREATE EXTERNAL TABLE statement.
47857	Fixed incorrect link to a table which has same name but different parent schema to the one referenced in the Dapper SQL Query object.

Other Updates

Details
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

Other Updates

Details
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

Resolved Issues

Customer Ticket Id	Details
47343	Oracle: Some SQL files, with data export / loading statements, were previously and incorrectly considered as DML. This has now been fixed.
46682	Fixed incorrect links created from procedure to a table named SET (MERGE INTO… UPDATE SET syntax).
46591	Fixed missing links between SQL Query objects and Table objects due to a crash at the application level.

Other Updates

Details
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.

Rules

Rule Id	New Rule	Details
1101026	FALSE	T-SQL: fixed false positives for the rule "Always define column names when inserting values" when WITH tables hints are used.
1101004	FALSE	Fixed a random missing violation for the rule "Avoid non-indexed SQL queries".
1101000	FALSE	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.
1101008	FALSE	T-SQL: fixed false positives for the rule "Avoid non-SARGable queries" when a SELECT is used in dynamic SQL.

3.7.0-funcrel

Resolved Issues

Customer Ticket Id	Details
45553	Fixes an issue causing SQL-004 warnings for 5 files during link creation phase for an Oracle analysis.
45635	Fixes an issue where the analysis became stuck after the "DssRun" step finished successfully.
45659	Fixed tables columns reported as missing procedures.
46125	Fixed missing links between Cobol SQL Query and Tables.

Other Updates

Details
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.

Rules

Rule Id	New Rule	Details
1101026	FALSE	Fixed false positive violation which was occurring when the table's schema name is a parameter.

New Support

Summary	Details
Support for missing tables for Entity Operations	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 fo IMS linking	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.

3.7.0-beta5

Resolved Issues

Customer Ticket Id	Details
40693	Fixed false positive on the rule 1101106 "Avoid tables without primary key / unique key constraint / unique index".
41969	Fixes an issue causing missing "belongs to" links.
44556	Improved links for SQL DML files: DML files are now considered as data exports only when INSERTs have static data.

Other Updates

Details
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.

Rules

Rule Id	New Rule	Details
1101106	FALSE	Fixed false positives for the rule "Avoid tables without primary key / unique key constraint / unique index".

New Support

Summary	Details
ORACLE : Object Types : added call link for indirect calls	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 relyon link for parameters/variables datatypes	Added relyonLink from Type's Method to another Type/Table when parameters/variables datatypes are Type/Table Columns.
ORACLE : Object Types : changed link type from sub Type to super Type	The link inheritLink has been changed to inheritExtendLink.
ORACLE : Object Types : added new link between methods	Added inheritOverrideLink from a Method's Type which overrides a super Type's Method.
Support for missing tables	Added support for missing tables for .NET/JEE ORM CRUD operations.
Link ORM CRUD Operations with SQL Tables/Views	Moved the linking of ORM CRUD Operations with SQL Tables/Views from Universal Linker (com.castsoftware.wbslinker) to SQL Analyzer.

3.7.0-beta4

Resolved Issues

Customer Ticket Id	Details
44816	Fixed incorrect missing table object "LOCKS" created for SQL statement "USE AND KEEP UPDATE LOCKS".
44915	Fixed an issue causing the error "ERROR: negative substring length not allowed."
42424	Fixed false link between SQL Server Procedures and Db2 Tables.

Other Updates

Details
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".

Rules

Rule Id	New Rule	Details
1101008	FALSE	Fixed false positives / negatives for "Avoid non-SARGable queries".
1101102	FALSE	Fixed false negatives for "Avoid using LIKE conditions without wildcards".
1101024	FALSE	Fixed false negatives for "Avoid using dynamic SQL in SQL Artifacts".
1101090	FALSE	Fixed false positives for "Avoid Tables without a clustered Index (SQL)".

3.7.0-beta3

Resolved Issues

Customer Ticket Id	Details
43979	Fixed Trigger and Index fullnames when only the table name is prefixed.

Other Updates

Details
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.

New Support

Summary	Details
Add support for the Teradata statement DATABASE <DATABASE_NAME>;	The default session database is correctly detected.

3.7.0-beta2

Other Updates

Details
Fixes an issue causing the creation of a "SQL Missing Table" object when a standard SQL table obejct with the same name already exists.

Rules

Rule Id	New Rule	Details
1101006	FALSE	Fixed a false positive violation on the rule 1101006 "Avoid non-indexed XXL SQL queries".
1101008	FALSE	Fixed a false positive violation on the rule 1101008 "Avoid non-SARGable queries".
1101076	FALSE	Fixed a missing violation for the rule 1101076 "Avoid unqualified column references".

New Support

Summary	Details
New advisor: Migrate DB2 to MySQL	Added support for "Migrate DB2 to MySQL" advisor rules in com.castsoftware.sql.movetocloud extension.

3.7.0-beta1

Resolved Issues

Customer Ticket Id	Details
43519	Fixed missing Oracle procedure and package objects when the SQL file is considered as DML instead of DDL.

Other Updates

Details
Fixed SQL-002 analysis warning for ALTER TABLE statements.

Rules

Rule Id	New Rule	Details
1101006	FALSE	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.

New Support

Summary	Details
Added the support for new SQL file extensions.	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.