diff options
| author | Simon Brandhof <simon.brandhof@gmail.com> | 2013-04-15 10:32:05 +0200 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@gmail.com> | 2013-04-15 10:32:05 +0200 |
| commit | 4b3f46acbef4c1ffcd24d55ac9ba973b3228976f (patch) | |
| tree | ff58eefbe10422d07ee089363d80c103d6c840a5 | |
| parent | d5775b6b816717262b98e62fdd95097985bc5f77 (diff) | |
| download | sonarqube-4b3f46acbef4c1ffcd24d55ac9ba973b3228976f.tar.gz sonarqube-4b3f46acbef4c1ffcd24d55ac9ba973b3228976f.zip | |
SONAR-3755 fix SQL for mssql and oracle
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/user/AuthorizationMapper.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sonar-core/src/main/resources/org/sonar/core/user/AuthorizationMapper.xml b/sonar-core/src/main/resources/org/sonar/core/user/AuthorizationMapper.xml index f2338f3bddc..b8f800fbb70 100644 --- a/sonar-core/src/main/resources/org/sonar/core/user/AuthorizationMapper.xml +++ b/sonar-core/src/main/resources/org/sonar/core/user/AuthorizationMapper.xml @@ -12,7 +12,7 @@ and gr.resource_id = s.root_project_id and s.project_id in <foreach item="componentId" index="index" collection="componentIds" open="(" separator="," close=")">#{componentId}</foreach> and s.islast = ${_true} - UNION DISTINCT + UNION SELECT s.project_id FROM user_roles ur, snapshots s WHERE |