diff options
| author | Julien Lancelot <julien.lancelot@gmail.com> | 2013-05-24 15:53:28 +0200 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@gmail.com> | 2013-05-24 15:53:28 +0200 |
| commit | 69d60465a1a5e99e94e1a3eedbb3df71d6f287d9 (patch) | |
| tree | 4290f661c35c801454740910219a5109a5e7c8c1 /sonar-core/src | |
| parent | 28542b892d415acaa04d15ad508f54349f0e799a (diff) | |
| download | sonarqube-69d60465a1a5e99e94e1a3eedbb3df71d6f287d9.tar.gz sonarqube-69d60465a1a5e99e94e1a3eedbb3df71d6f287d9.zip | |
SONAR-4301 Fix sql query
Diffstat (limited to 'sonar-core/src')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/issue/db/IssueMapper.xml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueMapper.xml b/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueMapper.xml index 295ffa94a1b..52d9f3d4aa6 100644 --- a/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueMapper.xml +++ b/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueMapper.xml @@ -146,7 +146,7 @@ </where> </select> - <select id="selectIssueAndProjectIds" parameterType="map" resultType="Issue" fetchSize="1000000"> + <select id="selectIssueAndProjectIds" parameterType="map" resultType="Issue" > select i.id, i.project_id as projectId <include refid="sortColumn"/> <include refid="selectQueryConditions"/> @@ -156,8 +156,8 @@ </select> <!-- SQL Server --> - <select id="selectIssueAndProjectIds" parameterType="map" resultType="Issue" fetchSize="1000000" databaseId="mssql"> - select TOP #{maxResults} i.id, i.project_id as projectId + <select id="selectIssueAndProjectIds" parameterType="map" resultType="Issue" databaseId="mssql"> + select top (#{maxResults}) i.id, i.project_id as projectId <include refid="sortColumn"/> <include refid="selectQueryConditions"/> </select> |