From 969407f6a612223ab19c22c36b5121c2c6659498 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@sonarsource.com>
Date: Mon, 4 Nov 2019 13:48:20 +0100
Subject: [PATCH] SONAR-12512 Fix SQL queries on MsSQL

---
 .../sonar/db/alm/setting/AlmSettingMapper.xml  | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/alm/setting/AlmSettingMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/alm/setting/AlmSettingMapper.xml
index 17e8c548b52..f8c29ed4a3b 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/alm/setting/AlmSettingMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/alm/setting/AlmSettingMapper.xml
@@ -4,15 +4,15 @@
 <mapper namespace="org.sonar.db.alm.setting.AlmSettingMapper">
 
   <sql id="sqlColumns">
-    a.kee as key,
-    a.uuid as uuid,
-    a.alm_id as rawAlm,
-    a.url as url,
-    a.app_id as appId,
-    a.private_key as privateKey,
-    a.pat as personalAccessToken,
-    a.created_at as createdAt,
-    a.updated_at as updatedAt
+    a.kee as "key",
+    a.uuid as "uuid",
+    a.alm_id as "rawAlm",
+    a.url as "url",
+    a.app_id as "appId",
+    a.private_key as "privateKey",
+    a.pat as "personalAccessToken",
+    a.created_at as "createdAt",
+    a.updated_at as "updatedAt"
   </sql>
 
   <select id="selectByUuid" parameterType="string" resultType="org.sonar.db.alm.setting.AlmSettingDto">
-- 
2.39.5