diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-11-12 15:08:25 +0100 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-11-12 15:08:25 +0100 |
| commit | 6d3e3e12da1317d656435c978a018254f2c82d94 (patch) | |
| tree | 8ad66235184cd625829a525d0b8bdfcc0a114839 /sonar-db | |
| parent | 0ecd3deb3738d71a9a11f705d4e20320716465b7 (diff) | |
| download | sonarqube-6d3e3e12da1317d656435c978a018254f2c82d94.tar.gz sonarqube-6d3e3e12da1317d656435c978a018254f2c82d94.zip | |
SONAR-6993 Fix SQL query on MsSQL and Oracle
Diffstat (limited to 'sonar-db')
| -rw-r--r-- | sonar-db/src/main/resources/org/sonar/db/duplication/DuplicationMapper.xml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sonar-db/src/main/resources/org/sonar/db/duplication/DuplicationMapper.xml b/sonar-db/src/main/resources/org/sonar/db/duplication/DuplicationMapper.xml index 916eba5ad96..af67fef0584 100644 --- a/sonar-db/src/main/resources/org/sonar/db/duplication/DuplicationMapper.xml +++ b/sonar-db/src/main/resources/org/sonar/db/duplication/DuplicationMapper.xml @@ -12,10 +12,11 @@ duplication_block.index_in_file as indexInFile, duplication_block.start_line as startLine, duplication_block.end_line as endLine, - file.kee as componentKey + file_component.kee as componentKey FROM duplications_index duplication_block INNER JOIN snapshots snapshot ON duplication_block.snapshot_id=snapshot.id AND snapshot.islast=${_true} - INNER JOIN projects file ON file.id=snapshot.project_id AND file.language=#{language} AND file.enabled=${_true} + INNER JOIN projects file_component ON file_component.id=snapshot.project_id AND file_component.language=#{language} + AND file_component.enabled=${_true} <where> AND duplication_block.hash in <foreach collection="hashes" open="(" close=")" item="hash" separator=",">#{hash}</foreach> |