SEM007 : Statement metrics for detecting duplicated code

Introduction

Description

Metrics rule - hash,tokens and lines count of each statement. For use by copy-paste detection.

How to fix

The rule is only informational.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix

Not configured.

Additional Information

There is no additional info for this rule.

Example Test SQL

begin
-- non-ANSI inner join syntax:
SELECT     a.au_id ,
           t.titlr e
FROM       titles AS t ,
           authors AS a ,
           titleauthor AS ta
WHERE      a.au_id = ta.au_id
       AND ta.title_id = t.title_id
       AND t.title LIKE 'Example%'

-- ANSI inner join syntax:

/*
SELECT     a.au_id ,
           t.title
FROM       authors AS a
INNER JOIN titleauthor AS ta
ON         a.au_id = ta.au_id
INNER JOIN titles AS t
ON         ta.title_id = t.title_id
WHERE      t.title LIKE 'Example%'
*/

SELECT     a.au_id ,
           t.title
FROM       authors AS a
INNER JOIN titleauthor AS ta
ON         a.au_id = ta.au_id
INNER JOIN titles AS t
ON         ta.title_id = t.title_id
WHERE      t.title LIKE 'Example%' -- Ignore

SELECT     a.au_id ,
           t.title
FROM       authors AS a
INNER JOIN titleauthor AS ta




ON         a.au_id = ta.au_id
INNER JOIN titles AS t
ON         ta.title_id = t.title_id
WHERE      t.title LIKE 'Example%' -- Ignore


end

Analysis Results

	Message	Line
1	SEM007 : Hash=BCC52F87,Statements=4,Tokens=138,Lines=48,Position=1,StatementLength=1026	1
2	SEM007 : Hash=F01E538,Statements=1,Tokens=43,Lines=21,Position=2,StatementLength=495	3
3	SEM007 : Hash=EA388B09,Statements=1,Tokens=45,Lines=8,Position=3,StatementLength=233	25
4	SEM007 : Hash=EA388B09,Statements=1,Tokens=45,Lines=12,Position=4,StatementLength=241	34

Analysis Rules