Copy Paste Code checking over all Projects

Since the duplicated bug has been resolved, shouldn't this issue be closed now?

No, this is the initial issue. SONAR-1400 duplicates it and has not be resolved.

Test feedback :

In the 'Duplications' tab of the Settings page :

• The following properties should not be displayed any more in the user interface but should still be supported (so they should be added to the Advanced parameters page) :
  • sonar.cpd.minimumTokens
  • sonar.cpd.ignore_literals
  • sonar.cpd.ignore_identifiers
  • sonar.cpd.skip
• The following properties should be added :
  • "sonar.cpd.default.engine=sonar" the other possible value is "cpd"
  • "sonar.cpd.cross_project=true"

Moreover, there is no way from the analysis log file to know which CPD engine has been used and if the cross-project duplication detection mechanism has been activated :

[INFO]  Sensor CpdSensor...
[INFO]  Sensor CpdSensor done: 790 ms

As we've decided to use the word 'duplications' instead of 'clones' it would be better to rename the table 'clone_blocks' into 'duplication_index'.

The use of the 'sonar.branch' property should deactivate the detection of cross-project duplications which is not the case.

The SQL request :

SELECT hash, resource.kee, index_in_file, start_line, end_line 
FROM clone_blocks AS block, snapshots AS snapshot, projects AS resource 
WHERE block.snapshot_id=snapshot.id AND snapshot.islast=true 
AND snapshot.project_id=resource.id AND hash IN ( SELECT hash FROM clone_blocks WHERE snapshot_id = ?  ) 
AND block.project_snapshot_id != ?

should be replaced by :

SELECT to_blocks.hash, resource .resource.kee, to_blocks.index_in_file, to_blocks.start_line, to_blocks.end_line  
FROM clone_blocks to_blocks, clone_blocks from_blocks, snapshots, projects AS resource
where to_blocks.hash = from_blocks.hash
and from_blocks.snapshot_id = ?
and to_blocks.snapshot_id = snapshots.id
and snapshots.islast=false
and snapshots.project_id = resource.id
and to_blocks.project_snapshot_id != ?

Could you also make it possible to tune the size of a blocks through a hidden parameter in order to make some tests ? Thanks

SQL request changed in 2a78a62 and thanks to unit tests I found a typo - instead of "islast=false" should be "islast=true"

• SQL requests were tuned for Derby and Oracle
• Table renamed to 'duplications_index'
• sonar.cpd.engine=sonar by default
• Properties organized in a new category 'Duplications'
• Sonar Engine supports Java 7

However Freddy maybe you can suggest better descriptions for properties? For example describe that Sonar Engine supports only Java for the moment, however allows analysis across projects and requires less memory and so description for "sonar.cpd.skip" also can be tuned.

Tested !

would be great to have an IT to test deactivation of the cross project duplication detection mechanism when the sonar.branch property is defined.

All ITs in place (cross-project detection, sonar.branch, UI - SONAR-2752), so closing this ticket.