Changeset: 3ad65316a642 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3ad65316a642
Added Files:
geom/sql/conformance/Tests/T1.test
geom/sql/conformance/Tests/T10.test
geom/sql/conformance/Tests/T11.test
geom/sql/conformance/Tests/T12.test
geom/sql/conformance/Tests/T13.test
geom/sql/conformance/Tests/T14.test
geom/sql/conformance/Tests/T15.test
geom/sql/conformance/Tests/T16.test
geom/sql/conformance/Tests/T17.test
geom/sql/conformance/Tests/T18.test
geom/sql/conformance/Tests/T19.test
geom/sql/conformance/Tests/T2.test
geom/sql/conformance/Tests/T20.test
geom/sql/conformance/Tests/T21.test
geom/sql/conformance/Tests/T22.test
geom/sql/conformance/Tests/T23.test
geom/sql/conformance/Tests/T24.test
geom/sql/conformance/Tests/T25.test
geom/sql/conformance/Tests/T26.test
geom/sql/conformance/Tests/T27.test
geom/sql/conformance/Tests/T28.test
geom/sql/conformance/Tests/T29.test
geom/sql/conformance/Tests/T3.test
geom/sql/conformance/Tests/T30.test
geom/sql/conformance/Tests/T31.test
geom/sql/conformance/Tests/T32.test
geom/sql/conformance/Tests/T33.test
geom/sql/conformance/Tests/T34.test
geom/sql/conformance/Tests/T35.test
geom/sql/conformance/Tests/T36.test
geom/sql/conformance/Tests/T37.test
geom/sql/conformance/Tests/T38.test
geom/sql/conformance/Tests/T39.test
geom/sql/conformance/Tests/T4.test
geom/sql/conformance/Tests/T40.test
geom/sql/conformance/Tests/T41.test
geom/sql/conformance/Tests/T42.test
geom/sql/conformance/Tests/T43.test
geom/sql/conformance/Tests/T44.test
geom/sql/conformance/Tests/T45.test
geom/sql/conformance/Tests/T46.test
geom/sql/conformance/Tests/T47.test
geom/sql/conformance/Tests/T48.test
geom/sql/conformance/Tests/T49.test
geom/sql/conformance/Tests/T5.test
geom/sql/conformance/Tests/T50.test
geom/sql/conformance/Tests/T51.test
geom/sql/conformance/Tests/T52.test
geom/sql/conformance/Tests/T6.test
geom/sql/conformance/Tests/T7.test
geom/sql/conformance/Tests/T8.test
geom/sql/conformance/Tests/T9.test
geom/sql/conformance/Tests/conformance_drop.test
geom/sql/conformance/Tests/conformance_load.test
Branch: mtest
Log Message:
Converted tests in geom/sql/conformance
NB: also converted the three currently disabled tests. If they ever run, need
to update their expected outputs.
diffs (truncated from 833 to 300 lines):
diff --git a/geom/sql/conformance/Tests/T1.test
b/geom/sql/conformance/Tests/T1.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T1.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT f_table_name FROM geometry_columns ORDER BY f_table_name
+----
+11 values hashing to c4c2fd32627fe8478eeeb74c8a76c7c7
+
+
diff --git a/geom/sql/conformance/Tests/T10.test
b/geom/sql/conformance/Tests/T10.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T10.test
@@ -0,0 +1,6 @@
+query I rowsort
+SELECT ST_SRID(boundary) FROM named_places WHERE name = 'Goose Island'
+----
+101
+
+
diff --git a/geom/sql/conformance/Tests/T11.test
b/geom/sql/conformance/Tests/T11.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T11.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_IsEmpty(centerline) FROM road_segments WHERE name = 'Route 5' AND
aliases = 'Main Street'
+----
+False
+
+
diff --git a/geom/sql/conformance/Tests/T12.test
b/geom/sql/conformance/Tests/T12.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T12.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_IsSimple(shore) FROM lakes WHERE name = 'Blue Lake'
+----
+True
+
+
diff --git a/geom/sql/conformance/Tests/T13.test
b/geom/sql/conformance/Tests/T13.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T13.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_Boundary(boundary)) FROM named_places WHERE name = 'Goose
Island'
+----
+LINESTRING (67 13, 67 18, 59 18, 59 13, 67 13)
+
+
diff --git a/geom/sql/conformance/Tests/T14.test
b/geom/sql/conformance/Tests/T14.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T14.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_Envelope(boundary)) FROM named_places WHERE name = 'Goose
Island'
+----
+POLYGON ((59 13, 67 13, 67 18, 59 18, 59 13))
+
+
diff --git a/geom/sql/conformance/Tests/T15.test
b/geom/sql/conformance/Tests/T15.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T15.test
@@ -0,0 +1,6 @@
+query R rowsort
+SELECT ST_X("position") FROM bridges WHERE name = 'Cam Bridge'
+----
+44.000
+
+
diff --git a/geom/sql/conformance/Tests/T16.test
b/geom/sql/conformance/Tests/T16.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T16.test
@@ -0,0 +1,6 @@
+query R rowsort
+SELECT ST_Y("position") FROM bridges WHERE name = 'Cam Bridge'
+----
+31.000
+
+
diff --git a/geom/sql/conformance/Tests/T17.test
b/geom/sql/conformance/Tests/T17.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T17.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_StartPoint(centerline)) FROM road_segments WHERE fid = 102
+----
+POINT (0 18)
+
+
diff --git a/geom/sql/conformance/Tests/T18.test
b/geom/sql/conformance/Tests/T18.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T18.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_EndPoint(centerline)) FROM road_segments WHERE fid = 102
+----
+POINT (44 31)
+
+
diff --git a/geom/sql/conformance/Tests/T19.test
b/geom/sql/conformance/Tests/T19.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T19.test
@@ -0,0 +1,4 @@
+statement error
+SELECT
ST_IsClosed(ST_LineFromWKB(ST_AsBinary(ST_Boundary(ST_WKBToSQL(boundary))),ST_SRID(boundary)))
FROM named_places WHERE name = 'Goose Island'
+
+
diff --git a/geom/sql/conformance/Tests/T2.test
b/geom/sql/conformance/Tests/T2.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T2.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT f_geometry_column FROM geometry_columns WHERE f_table_name = 'streams'
+----
+centerline
+
+
diff --git a/geom/sql/conformance/Tests/T20.test
b/geom/sql/conformance/Tests/T20.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T20.test
@@ -0,0 +1,4 @@
+statement error
+SELECT
ST_IsRing(ST_LineFromWKB(ST_AsBinary(ST_Boundary(ST_WKBToSQL(boundary))),ST_SRID(boundary)))
FROM named_places WHERE name = 'Goose Island'
+
+
diff --git a/geom/sql/conformance/Tests/T21.test
b/geom/sql/conformance/Tests/T21.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T21.test
@@ -0,0 +1,6 @@
+query R rowsort
+SELECT ST_Length(centerline) FROM road_segments WHERE fid = 106
+----
+26.000
+
+
diff --git a/geom/sql/conformance/Tests/T22.test
b/geom/sql/conformance/Tests/T22.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T22.test
@@ -0,0 +1,6 @@
+query I rowsort
+SELECT ST_NumPoints(centerline) FROM road_segments WHERE fid = 102
+----
+5
+
+
diff --git a/geom/sql/conformance/Tests/T23.test
b/geom/sql/conformance/Tests/T23.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T23.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_PointN(centerline, 1)) FROM road_segments WHERE fid = 102
+----
+POINT (10 21)
+
+
diff --git a/geom/sql/conformance/Tests/T24.test
b/geom/sql/conformance/Tests/T24.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T24.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_Centroid(boundary)) FROM named_places WHERE name = 'Goose
Island'
+----
+POINT (63 15.5)
+
+
diff --git a/geom/sql/conformance/Tests/T25.test
b/geom/sql/conformance/Tests/T25.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T25.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_Contains(boundary, ST_PointOnSurface(boundary)) FROM named_places
WHERE name = 'Goose Island'
+----
+True
+
+
diff --git a/geom/sql/conformance/Tests/T26.test
b/geom/sql/conformance/Tests/T26.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T26.test
@@ -0,0 +1,6 @@
+query R rowsort
+SELECT ST_Area(boundary) FROM named_places WHERE name = 'Goose Island'
+----
+40.000
+
+
diff --git a/geom/sql/conformance/Tests/T27.test
b/geom/sql/conformance/Tests/T27.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T27.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_ExteriorRing(shore)) FROM lakes WHERE name = 'Blue Lake'
+----
+LINESTRING (52 18, 66 23, 73 9, 48 6, 52 18)
+
+
diff --git a/geom/sql/conformance/Tests/T28.test
b/geom/sql/conformance/Tests/T28.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T28.test
@@ -0,0 +1,6 @@
+query I rowsort
+SELECT ST_NumInteriorRing(shore) FROM lakes WHERE name = 'Blue Lake'
+----
+1
+
+
diff --git a/geom/sql/conformance/Tests/T29.test
b/geom/sql/conformance/Tests/T29.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T29.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_InteriorRingN(shore, 1)) FROM lakes WHERE name = 'Blue
Lake'
+----
+LINESTRING (59 18, 67 18, 67 13, 59 13, 59 18)
+
+
diff --git a/geom/sql/conformance/Tests/T3.test
b/geom/sql/conformance/Tests/T3.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T3.test
@@ -0,0 +1,6 @@
+query I rowsort
+SELECT coord_dimension FROM geometry_columns WHERE f_table_name = 'streams'
+----
+2
+
+
diff --git a/geom/sql/conformance/Tests/T30.test
b/geom/sql/conformance/Tests/T30.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T30.test
@@ -0,0 +1,6 @@
+query I rowsort
+SELECT ST_NumGeometries(centerlines) FROM divided_routes WHERE name = 'Route
75'
+----
+2
+
+
diff --git a/geom/sql/conformance/Tests/T31.test
b/geom/sql/conformance/Tests/T31.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T31.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_GeometryN(centerlines, 2)) FROM divided_routes WHERE name
= 'Route 75'
+----
+LINESTRING (16 0, 16 23, 16 48)
+
+
diff --git a/geom/sql/conformance/Tests/T32.test
b/geom/sql/conformance/Tests/T32.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T32.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_IsClosed(centerlines) FROM divided_routes WHERE name = 'Route 75'
+----
+False
+
+
diff --git a/geom/sql/conformance/Tests/T33.test
b/geom/sql/conformance/Tests/T33.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T33.test
@@ -0,0 +1,6 @@
+query R rowsort
+SELECT ST_Length(centerlines) FROM divided_routes WHERE name = 'Route 75'
+----
+96.000
+
+
diff --git a/geom/sql/conformance/Tests/T34.test
b/geom/sql/conformance/Tests/T34.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/conformance/Tests/T34.test
@@ -0,0 +1,6 @@
+query T rowsort
+SELECT ST_AsText(ST_Centroid(shores)) FROM ponds WHERE fid = 120
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
