Add version.sql test

Current version check was moved from init.sql into version.sql because init.sql it is not executed with the 'test' target.
postgrespro · vitcpp · Nov 23, 2023 · Nov 22, 2023 · Nov 22, 2023 · Nov 22, 2023
commit 902ba8da469da799dd18ca3b68b8915bd4d381b5
diff --git a/Makefile b/Makefile
@@ -35,7 +35,7 @@ DATA_built  = $(RELEASE_SQL) \
 			  pg_sphere--1.3.1--1.4.0.sql
 
 DOCS        = README.pg_sphere COPYRIGHT.pg_sphere
-TESTS       = tables points euler circle line ellipse poly path box \
+TESTS       = version tables points euler circle line ellipse poly path box \
               index contains_ops contains_ops_compat bounding_box_gist gnomo \
               epochprop contains overlaps spoint_brin sbox_brin selectivity
 REGRESS     = init $(TESTS)

diff --git a/expected/init.out b/expected/init.out
@@ -1,11 +1,4 @@
 --
--- first, define the datatype.  Turn off echoing so that expected file
--- does not depend on contents of pg_sphere.sql.
+-- Initialize the extension.
 --
 CREATE EXTENSION pg_sphere;
-select pg_sphere_version();
- pg_sphere_version 
--------------------
- 1.4.0
-(1 row)
-
diff --git a/expected/version.out b/expected/version.out
@@ -0,0 +1,7 @@
+-- Check current pgsphere version
+SELECT pg_sphere_version();
+ pg_sphere_version 
+-------------------
+ 1.4.0
+(1 row)
+
diff --git a/sql/init.sql b/sql/init.sql
@@ -1,7 +1,4 @@
 --
--- first, define the datatype.  Turn off echoing so that expected file
--- does not depend on contents of pg_sphere.sql.
+-- Initialize the extension.
 --
 CREATE EXTENSION pg_sphere;
-
-select pg_sphere_version();
diff --git a/sql/version.sql b/sql/version.sql
@@ -0,0 +1,3 @@
+-- Check current pgsphere version
+SELECT pg_sphere_version();
+
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,3 @@
		-- Check current pgsphere version
		SELECT pg_sphere_version();