SONAR-22871 Fix CLOB type assertions

1 files changed, 7 insertions, 4 deletions

diff --git a/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java b/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java
index 783c296128b..39807031d67 100644
--- a/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java
+++ b/server/sonar-db-core/src/testFixtures/java/org/sonar/db/AbstractDbTester.java
@@ -63,6 +63,7 @@ import static com.google.common.collect.Lists.asList;
 import static java.sql.Types.BIGINT;
 import static java.sql.Types.BIT;
 import static java.sql.Types.BOOLEAN;
+import static java.sql.Types.CLOB;
 import static java.sql.Types.DECIMAL;
 import static java.sql.Types.DOUBLE;
 import static java.sql.Types.INTEGER;
@@ -77,13 +78,15 @@ public class AbstractDbTester<T extends TestDb> extends ExternalResource {
 
   private static final Pattern INDEX_NAME_PATTERN = Pattern.compile("COALESCE\\(([\\w_]*),");
 
-  private static final Map<Integer, Integer> POSTGRES_TYPE_SUBSTITUTION = Map.of(BOOLEAN, BIT,
-    DOUBLE, NUMERIC);
+  private static final Map<Integer, Integer> POSTGRES_TYPE_SUBSTITUTION = Map.of(
+    BOOLEAN, BIT,
+    DOUBLE, NUMERIC,
+    CLOB, VARCHAR);
   private static final Map<Integer, Integer> MSSQL_TYPE_SUBSTITUTION = Map.of(
     BOOLEAN, BIT,
     VARCHAR, NVARCHAR,
-    DOUBLE, DECIMAL);
-
+    DOUBLE, DECIMAL,
+    CLOB, NVARCHAR);
   private static final Map<Integer, Integer> ORACLE_TYPE_SUBSTITUTION = Map.of(
     BOOLEAN, NUMERIC,
     BIGINT, NUMERIC,