Changeset: 26392d013a98 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=26392d013a98
Added Files:
geom/sql/Tests/pg_regression/Tests/setpoint.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regress: setpoint
diffs (42 lines):
diff --git a/geom/sql/Tests/pg_regression/Tests/All
b/geom/sql/Tests/pg_regression/Tests/All
--- a/geom/sql/Tests/pg_regression/Tests/All
+++ b/geom/sql/Tests/pg_regression/Tests/All
@@ -17,4 +17,6 @@
#removepoint #Unknown Functions: st_removepoint
+#setpoint #Unknown Functions: st_setpoint
+
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/setpoint.sql
b/geom/sql/Tests/pg_regression/Tests/setpoint.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/setpoint.sql
@@ -0,0 +1,27 @@
+-- Repeat all tests with new function names.
+-- Out of range indexes
+SELECT ST_SetPoint('LINESTRING(0 0, 1 1, 2 2)', 3, 'POINT(9 9)');
+SELECT ST_SetPoint('LINESTRING(0 0, 1 1, 2 2)', -1, 'POINT(9 9)');
+
+-- Invalid inputs
+SELECT ST_SetPoint('MULTIPOINT(0 0, 1 1, 2 2)', 3, 'POINT(9 9)');
+SELECT ST_SetPoint('LINESTRING(0 0, 1 1, 2 2)', -1, 'MULTIPOINT(9 9, 0 0)');
+
+-- Replacing 3dz line with 3dm point
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(-1 -1 -1, 1 1 1, 2 2 2)', 0,
'POINT(90 91 92)'));
+
+-- Replacing 3dm line with 3dz point
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 1, 'POINT(90
91 92)'));
+
+-- Replacing 3dm line with 4d point
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 2, 'POINT(90
91 92 93)'));
+
+-- Replacing 3dz line with 4d point
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 1, 'POINT(90
91 92 93)'));
+
+-- Replacing 4d line with 2d/3dm/3dz/4d point
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 4 4 4 4)',
3, 'POINT(90 91)'));
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 4 4 4 4)',
2, 'POINT(90 91 92)'));
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 4 4 4 4)',
1, 'POINT(90 91 92)'));
+SELECT ST_asewkt(ST_SetPoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 4 4 4 4)',
0, 'POINT(90 91 92 93)'));
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
