aboutsummaryrefslogtreecommitdiff
path: root/data/sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/sql')
-rw-r--r--data/sql/commit.sql3
-rw-r--r--data/sql/metadata.sql4
2 files changed, 7 insertions, 0 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index 7a4b74ad..80f5d7ba 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -191,6 +191,9 @@ FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'missing au_ga_AUSGeoid98.tif')
WHERE NOT EXISTS(SELECT 1 FROM grid_alternatives WHERE proj_grid_name = 'au_ga_AUSGeoid98.tif');
+ -- check PROJ.VERSION value
+ SELECT RAISE(ABORT, 'Value of PROJ.VERSION entry of metadata tables not substituted by actual value')
+ WHERE (SELECT 1 FROM metadata WHERE key = 'PROJ.VERSION' AND value LIKE '$%');
END;
INSERT INTO dummy DEFAULT VALUES;
diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql
index bb8e3095..5a196c0b 100644
--- a/data/sql/metadata.sql
+++ b/data/sql/metadata.sql
@@ -11,3 +11,7 @@ INSERT INTO "metadata" VALUES('DATABASE.LAYOUT.VERSION.MINOR', 0);
INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v10.018');
INSERT INTO "metadata" VALUES('EPSG.DATE', '2021-04-02');
+
+-- The value of ${PROJ_VERSION} is substituted at build time by the actual
+-- value.
+INSERT INTO "metadata" VALUES('PROJ.VERSION', '${PROJ_VERSION}');