Created by Shared Doc User on Oct 06, 2023
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