Purpose of Query
Using the query:
- One can retrieve the mangling information for all objects for identifying the functions for which the input parameters are changed and exclude them from action plan.
- CAST uses mangling to identify the differences between objects (others parameters also).
- Mangling information are stored in CDT_OBJECTS (OBJECT_MANGLING).
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT * FROM <KB_NAME>.CDT_OBJECTS A, <KB_NAME>.CSV_PARAMS B WHERE A.OBJECT_ID=B.OBJECT_ID
Query result example
1602;"GetColumnList";"Sherlock.DataAccess.Access.OracleSystem.GetColumnList";"C# Method";"GetColumnList(Sherlock.Infrastructure.Model.IDataConnection,System.String,System.String,System.Collections.Generic.List<Sherlock.Infrastructure.Model.DbColumn>,Sherlock.Infrastructure.Logger.ILoggerFacade)System.Void";" public static";"C#";1602;"GetColumnList";"Sherlock.DataAccess.Access.OracleSystem.GetColumnList";1;"dataConn";"Sherlock.Infrastructure.Model.IDataConnection";"BY VAL ";"Sherlock.DataAccess.csproj"
Query result interpretation
The query result gives the information on the Object name, Object id, Application name and corresponding Mangling Object
Query for Oracle
Same as CSS
Query result example
Query result interpretation
Query for SQL server
Same as CSS
Query result example
Query result interpretation
Notes/Comments