DEFECTS |
QCAR 6 Cartesian product between tables sybsystemprocs..sysobjects o and [sybsystemprocs..sysusers u] |
210 |
QCAR 6 Cartesian product between tables sybsystemprocs..sysobjects o and [sybsystemprocs..sysusers u] |
227 |
QCAR 6 Cartesian product between tables sybsystemprocs..sysobjects o and [sybsystemprocs..sysusers u] |
277 |
QCAR 6 Cartesian product between tables sybsystemprocs..sysobjects o and [sybsystemprocs..sysusers u] |
293 |
QJWI 5 Join or Sarg Without Index |
83 |
MEST 4 Empty String will be replaced by Single Space |
75 |
MEST 4 Empty String will be replaced by Single Space |
80 |
MEST 4 Empty String will be replaced by Single Space |
90 |
MEST 4 Empty String will be replaced by Single Space |
97 |
MEST 4 Empty String will be replaced by Single Space |
477 |
MEST 4 Empty String will be replaced by Single Space |
486 |
MEST 4 Empty String will be replaced by Single Space |
495 |
MEST 4 Empty String will be replaced by Single Space |
504 |
MINU 4 Unique Index with nullable columns master..sysconfigures |
master..sysconfigures |
MINU 4 Unique Index with nullable columns master..sysmessages |
master..sysmessages |
MINU 4 Unique Index with nullable columns sybsystemprocs..sysjars |
sybsystemprocs..sysjars |
MINU 4 Unique Index with nullable columns sybsystemprocs..sysxtypes |
sybsystemprocs..sysxtypes |
MPSI 4 Possible SQL Injection @object_name |
374 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
85 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
93 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
110 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
126 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
148 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
157 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
240 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
304 |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int |
60 |
QTYP 4 Comparison type mismatch smallint = int |
60 |
TNOU 4 Table with no unique index master..spt_values |
master..spt_values |
MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain |
19 |
MGTP 3 Grant to public master..spt_values |
|
MGTP 3 Grant to public master..sysconfigures |
|
MGTP 3 Grant to public master..sysmessages |
|
MGTP 3 Grant to public sybsystemprocs..sp_helpjava |
|
MGTP 3 Grant to public sybsystemprocs..syscolumns |
|
MGTP 3 Grant to public sybsystemprocs..sysdepends |
|
MGTP 3 Grant to public sybsystemprocs..sysjars |
|
MGTP 3 Grant to public sybsystemprocs..sysobjects |
|
MGTP 3 Grant to public sybsystemprocs..sysusers |
|
MGTP 3 Grant to public sybsystemprocs..sysxtypes |
|
MNER 3 No Error Check should check @@error after select into |
79 |
MNER 3 No Error Check should check return value of exec |
85 |
MNER 3 No Error Check should check return value of exec |
93 |
MNER 3 No Error Check should check return value of exec |
110 |
MNER 3 No Error Check should check return value of exec |
126 |
MNER 3 No Error Check should check @@error after select into |
144 |
MNER 3 No Error Check should check return value of exec |
148 |
MNER 3 No Error Check should check @@error after select into |
152 |
MNER 3 No Error Check should check return value of exec |
157 |
MNER 3 No Error Check should check return value of exec |
203 |
MNER 3 No Error Check should check @@error after select into |
205 |
MNER 3 No Error Check should check return value of exec |
240 |
MNER 3 No Error Check should check return value of exec |
269 |
MNER 3 No Error Check should check @@error after select into |
272 |
MNER 3 No Error Check should check return value of exec |
304 |
MUCO 3 Useless Code Useless Brackets |
43 |
MUCO 3 Useless Code Useless Brackets |
98 |
MUCO 3 Useless Code Useless Brackets |
114 |
MUCO 3 Useless Code Useless Brackets |
130 |
MUCO 3 Useless Code Useless Brackets |
161 |
MUCO 3 Useless Code Useless Brackets |
167 |
MUCO 3 Useless Code Useless Brackets |
192 |
MUCO 3 Useless Code Useless Brackets |
248 |
MUCO 3 Useless Code Useless Brackets |
254 |
MUCO 3 Useless Code Useless Brackets |
263 |
MUCO 3 Useless Code Useless Brackets |
307 |
MUCO 3 Useless Code Useless Brackets |
318 |
MUCO 3 Useless Code Useless Brackets |
507 |
MUCO 3 Useless Code Useless Brackets |
517 |
MUIN 3 Column created using implicit nullability |
330 |
MUIN 3 Column created using implicit nullability |
331 |
MUIN 3 Column created using implicit nullability |
332 |
MUIN 3 Column created using implicit nullability |
333 |
QCTC 3 Conditional Table Creation |
79 |
QCTC 3 Conditional Table Creation |
144 |
QCTC 3 Conditional Table Creation |
152 |
QCTC 3 Conditional Table Creation |
205 |
QCTC 3 Conditional Table Creation |
272 |
QCTC 3 Conditional Table Creation |
330 |
QCTC 3 Conditional Table Creation |
331 |
QCTC 3 Conditional Table Creation |
332 |
QCTC 3 Conditional Table Creation |
333 |
QDIS 3 Check correct use of 'select distinct' |
205 |
QDIS 3 Check correct use of 'select distinct' |
223 |
QDIS 3 Check correct use of 'select distinct' |
272 |
QDIS 3 Check correct use of 'select distinct' |
289 |
QGWO 3 Group by/Distinct/Union without order by |
205 |
QGWO 3 Group by/Distinct/Union without order by |
223 |
QGWO 3 Group by/Distinct/Union without order by |
272 |
QGWO 3 Group by/Distinct/Union without order by |
289 |
QISO 3 Set isolation level |
51 |
QNAJ 3 Not using ANSI Inner Join |
154 |
QNAJ 3 Not using ANSI Inner Join |
185 |
QNAJ 3 Not using ANSI Inner Join |
194 |
QNAJ 3 Not using ANSI Inner Join |
210 |
QNAJ 3 Not using ANSI Inner Join |
227 |
QNAJ 3 Not using ANSI Inner Join |
277 |
QNAJ 3 Not using ANSI Inner Join |
293 |
QNAO 3 Not using ANSI Outer Join |
82 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysconfigures.csysconfigures unique clustered (name, parent, config) Intersection: {name} |
34 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid} |
58 |
QPRI 3 Join or Sarg with Rooted Partial Index Use JOIN Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error} Uncovered: [dlevel, langid] |
221 |
QPRI 3 Join or Sarg with Rooted Partial Index Use JOIN Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error} Uncovered: [dlevel, langid] |
239 |
QPRI 3 Join or Sarg with Rooted Partial Index Use JOIN Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error} Uncovered: [dlevel, langid] |
287 |
QPRI 3 Join or Sarg with Rooted Partial Index Use JOIN Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error} Uncovered: [dlevel, langid] |
303 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysconfigures.csysconfigures unique clustered (name, parent, config) Intersection: {name} |
365 |
QUNI 3 Check Use of 'union' vs 'union all' |
205 |
QUNI 3 Check Use of 'union' vs 'union all' |
272 |
VNRD 3 Variable is not read @sptlang |
61 |
VUNU 3 Variable is not used @method_variable |
26 |
CRDO 2 Read Only Cursor Marker (has for read only clause) |
184 |
MDYS 2 Dynamic SQL Marker |
374 |
MDYS 2 Dynamic SQL Marker |
475 |
MDYS 2 Dynamic SQL Marker |
484 |
MDYS 2 Dynamic SQL Marker |
493 |
MDYS 2 Dynamic SQL Marker |
502 |
MSUB 2 Subquery Marker |
33 |
MSUB 2 Subquery Marker |
57 |
MSUB 2 Subquery Marker |
139 |
MSUB 2 Subquery Marker |
179 |
MSUB 2 Subquery Marker |
194 |
MSUB 2 Subquery Marker |
365 |
MTR1 2 Metrics: Comments Ratio Comments: 23% |
19 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 67 = 77dec - 12exi + 2 |
19 |
MTR3 2 Metrics: Query Complexity Complexity: 252 |
19 |
PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0 |
152 |
PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0 |
184 |
PRED_QUERY_COLLECTION 2 {c=sybsystemprocs..syscolumns, d=sybsystemprocs..sysdepends, x=sybsystemprocs..sysxtypes} 0 |
194 |
PRED_QUERY_COLLECTION 2 {d=sybsystemprocs..sysdepends, m=master..sysmessages, o=sybsystemprocs..sysobjects, sv=master..spt_values, x=sybsystemprocs..sysxtypes} 0 |
205 |
PRED_QUERY_COLLECTION 2 {c=sybsystemprocs..syscolumns, m=master..sysmessages, o=sybsystemprocs..sysobjects, sv=master..spt_values, x=sybsystemprocs..sysxtypes} 0 |
223 |
PRED_QUERY_COLLECTION 2 {d=sybsystemprocs..sysdepends, m=master..sysmessages, o=sybsystemprocs..sysobjects, sv=master..spt_values, x=sybsystemprocs..sysxtypes} 0 |
272 |
PRED_QUERY_COLLECTION 2 {c=sybsystemprocs..syscolumns, m=master..sysmessages, o=sybsystemprocs..sysobjects, sv=master..spt_values, x=sybsystemprocs..sysxtypes} 0 |
289 |