diff options
| author | Teryk Bellahsene <teryk.bellahsene@sonarsource.com> | 2015-07-31 15:35:25 +0200 |
|---|---|---|
| committer | Teryk Bellahsene <teryk.bellahsene@sonarsource.com> | 2015-07-31 15:35:25 +0200 |
| commit | 2f6eac566f2346272d10a523bf9905bc339540a7 (patch) | |
| tree | 71cc6583d822bc16b0757c2f7ec0c611b925dc14 | |
| parent | ed67fcbdc5aeae489fe42b57735937e0270f9c84 (diff) | |
| download | sonarqube-2f6eac566f2346272d10a523bf9905bc339540a7.tar.gz sonarqube-2f6eac566f2346272d10a523bf9905bc339540a7.zip | |
Lowercase field selection in RoleMapper
| -rw-r--r-- | sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml b/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml index 09fd8d89692..86f44c53b55 100644 --- a/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml +++ b/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml @@ -121,7 +121,7 @@ WHERE ur.role = #{permission} and ur.resource_id IS NULL UNION ALL - SELECT DISTINCT u.ID as id + SELECT DISTINCT u.id as id FROM users u INNER JOIN groups_users gu ON gu.user_id = u.id INNER JOIN group_roles gr ON gr.group_id = gu.group_id |