From 2039302bc25821eee1139fb80a41d26ab7365e3e Mon Sep 17 00:00:00 2001 From: danielhanrahan Date: Thu, 17 Jul 2025 15:12:34 +0100 Subject: [PATCH] Make Liquibase use lowercase for SQL names (Liquibase #4) Liquibase by default will put quotes around table/column/index names, making them case-sensitive. DB-migrator SQL does not use quotes, so all names are treated as lowercase. This will cause upgrade issues in further commits. This commit makes Liquibase only quote entity name if they are using reserved keywords like 'table'. Issue-ID: POLICY-5398 Change-Id: Id0c6f553cf9c0d2459cf1a3701676d177644f619 Signed-off-by: danielhanrahan --- runtime-acm/src/main/resources/db/changelog/changelog-1400.yaml | 1 + runtime-acm/src/main/resources/db/changelog/changelog-1500.yaml | 1 + runtime-acm/src/main/resources/db/changelog/changelog-1600.yaml | 1 + runtime-acm/src/main/resources/db/changelog/changelog-1601.yaml | 1 + runtime-acm/src/main/resources/db/changelog/changelog-1700.yaml | 1 + runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml | 1 + runtime-acm/src/main/resources/db/changelog/db.changelog-master.yaml | 1 + 7 files changed, 7 insertions(+) diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1400.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1400.yaml index fb767de0e..26da4093a 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1400.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1400.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1400 diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1500.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1500.yaml index 2aeed5c64..0ab30f60e 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1500.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1500.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1500 diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1600.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1600.yaml index 1cbfddbf4..4a735498e 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1600.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1600.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1600 diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1601.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1601.yaml index bf21bee0d..874afdca4 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1601.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1601.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1601 diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1700.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1700.yaml index 26a4973db..26052323f 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1700.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1700.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1700 diff --git a/runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml b/runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml index dfc4b263a..ccf06e562 100644 --- a/runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml +++ b/runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - changeSet: author: policy id: 1701 diff --git a/runtime-acm/src/main/resources/db/changelog/db.changelog-master.yaml b/runtime-acm/src/main/resources/db/changelog/db.changelog-master.yaml index d50d972d2..7b8a7a670 100644 --- a/runtime-acm/src/main/resources/db/changelog/db.changelog-master.yaml +++ b/runtime-acm/src/main/resources/db/changelog/db.changelog-master.yaml @@ -17,6 +17,7 @@ # ============LICENSE_END========================================================= databaseChangeLog: + - objectQuotingStrategy: QUOTE_ONLY_RESERVED_WORDS - include: file: db/changelog/changelog-1400.yaml - include: -- 2.16.6