Changeset: f86f40373d71 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f86f40373d71
Modified Files:
geom/sql/Tests/functions/Tests/ST_Boundary.sql
geom/sql/Tests/functions/Tests/ST_Boundary.stable.out
geom/sql/Tests/functions/Tests/ST_Contains.sql
geom/sql/Tests/functions/Tests/ST_GeomFromText.stable.err
geom/sql/Tests/functions/Tests/ST_GeometryType.sql
geom/sql/Tests/functions/Tests/ST_IsClosed.sql
geom/sql/Tests/functions/Tests/ST_IsRing.sql
geom/sql/Tests/functions/Tests/ST_IsValid.sql
geom/sql/Tests/functions/Tests/ST_LineFromText.stable.err
geom/sql/Tests/functions/Tests/ST_MLineFromText.stable.err
geom/sql/Tests/functions/Tests/ST_MPointFromText.stable.err
geom/sql/Tests/functions/Tests/ST_MPolygonFromText.stable.err
geom/sql/Tests/functions/Tests/ST_MakeBox2D.stable.err
geom/sql/Tests/functions/Tests/ST_PointFromText.stable.err
geom/sql/Tests/functions/Tests/ST_PolygonFromText.stable.err
geom/sql/Tests/functions/Tests/loadTestGeometries.sql
geom/sql/Tests/functions/Tests/loadTestGeometries.stable.out
Branch: geo
Log Message:
3D geometries are loaded at the beginning of the tests. New outputs approved
diffs (truncated from 858 to 300 lines):
diff --git a/geom/sql/Tests/functions/Tests/ST_Boundary.sql
b/geom/sql/Tests/functions/Tests/ST_Boundary.sql
--- a/geom/sql/Tests/functions/Tests/ST_Boundary.sql
+++ b/geom/sql/Tests/functions/Tests/ST_Boundary.sql
@@ -6,6 +6,4 @@ SELECT ST_Boundary(ST_GeomFromText('POLY
SELECT ST_Boundary(ST_GeomFromText('MULTILINESTRING((1 1 1,0 0 0.5, -1 1 1),(1
1 0.5,0 0 0.5, -1 1 0.5, 1 1 0.5) )'));
-SELECT geom AS "GEOMETRY", ST_Boundary(geom) AS "BOUNDARY" FROM geometries
WHERE id<12;
-
-
+SELECT geom AS "GEOMETRY", ST_Boundary(geom) AS "BOUNDARY" FROM geometries
where id<>12 and id<>13 and id<>24 and id<>25;
diff --git a/geom/sql/Tests/functions/Tests/ST_Boundary.stable.out
b/geom/sql/Tests/functions/Tests/ST_Boundary.stable.out
--- a/geom/sql/Tests/functions/Tests/ST_Boundary.stable.out
+++ b/geom/sql/Tests/functions/Tests/ST_Boundary.stable.out
@@ -64,6 +64,16 @@ Ready.
[ "MULTILINESTRING ((30 40, 40 50, 30 40), (50 60, 40 50, 20 30, 50 60))",
"MULTIPOINT EMPTY" ]
[ "MULTIPOLYGON (((10 10, 10 20, 20 20, 20 10, 10 10), (30 30, 30 40, 40 40,
40 30, 30 30)))", "MULTILINESTRING ((10 10, 10 20, 20 20, 20 10, 10 10), (30
30, 30 40, 40 40, 40 30, 30 30))" ]
[ "MULTIPOLYGON EMPTY", "MULTILINESTRING EMPTY" ]
+[ "POINT Z (10 20 30)", "GEOMETRYCOLLECTION EMPTY" ]
+[ "LINESTRING Z (10 20 10, 30 40 10, 50 60 10)", "MULTIPOINT Z (10 20
10, 50 60 10)" ]
+[ "LINESTRING Z (10 20 10, 30 40 10, 50 60 10, 80 60 10, 60 40 10, 10 20 10)",
"MULTIPOINT EMPTY" ]
+[ "LINESTRING Z (10 10 20, 50 50 30, 30 80 40, 25 5 50)", "MULTIPOINT Z
(10 10 20, 25 5 50)" ]
+[ "POLYGON Z ((10 10 5, 10 20 10, 20 20 15, 20 10 20, 10 10 25))",
"LINESTRING Z (10 10 5, 10 20 10, 20 20 15, 20 10 20, 10 10 25)" ]
+[ "MULTIPOINT Z (10 20 10, 30 40 30)", "GEOMETRYCOLLECTION EMPTY" ]
+[ "MULTILINESTRING Z ((30 40 10, 40 50 20), (50 60 30, 60 70 40))",
"MULTIPOINT Z (30 40 10, 40 50 20, 50 60 30, 60 70 40)" ]
+[ "MULTILINESTRING Z ((30 40 10, 40 50 20, 30 40 30), (50 60 40, 60 70 50))",
"MULTIPOINT Z (50 60 40, 60 70 50)" ]
+[ "MULTILINESTRING Z ((30 40 100, 40 50 90, 30 40 80), (50 60 70, 40 50 60, 20
30 50, 50 60 40))", "MULTIPOINT EMPTY" ]
+[ "MULTIPOLYGON Z (((10 10 5, 10 20 5, 20 20 5, 20 10 5, 10 10 5), (30 30 10,
30 40 10, 40 40 10, 40 30 10, 30 30 10)))", "MULTILINESTRING Z ((10 10 5,
10 20 5, 20 20 5, 20 10 5, 10 10 5), (30 30 10, 30 40 10, 40 40 10, 40 30 10,
30 30 10))" ]
# 16:00:23 >
# 16:00:23 > "Done."
diff --git a/geom/sql/Tests/functions/Tests/ST_Contains.sql
b/geom/sql/Tests/functions/Tests/ST_Contains.sql
--- a/geom/sql/Tests/functions/Tests/ST_Contains.sql
+++ b/geom/sql/Tests/functions/Tests/ST_Contains.sql
@@ -10,4 +10,4 @@ FROM (SELECT ST_Buffer(ST_GeomFromText('
SELECT ST_Contains(bigc, ST_ExteriorRing(bigc)) As bigcontainsexterior
FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As smallc,
ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As bigc) As foo;
-SELECT geom AS "GEOMETRY", ST_Contains(geom, 'POINT (15 15)') AS "CONTAINS"
FROM geometries;
+SELECT geom AS "GEOMETRY", ST_Contains(geom, 'POINT (15 15)') AS "CONTAINS"
FROM geometries WHERE id<14;
diff --git a/geom/sql/Tests/functions/Tests/ST_GeomFromText.stable.err
b/geom/sql/Tests/functions/Tests/ST_GeomFromText.stable.err
--- a/geom/sql/Tests/functions/Tests/ST_GeomFromText.stable.err
+++ b/geom/sql/Tests/functions/Tests/ST_GeomFromText.stable.err
@@ -29,184 +29,184 @@ stderr of test 'ST_GeomFromText` in dire
# 15:46:20 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-9662" "--port=32350"
# 15:46:20 >
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20)', 4326));
ERROR = !column needs geometry(4, 0) and value is geometry(4, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(4, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20)'));
ERROR = !column needs geometry(4, 4326) and value is geometry(4, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20)', 0));
ERROR = !column needs geometry(4, 4326) and value is geometry(4, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4329));
ERROR = !column needs geometry(4, 4326) and value is geometry(8, 4329)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20 20)',
4326));
ERROR = !column needs geometry(6, 0) and value is geometry(6, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(6, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20 20)'));
ERROR = !column needs geometry(6, 4326) and value is geometry(6, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('point(0 20 20)', 0));
ERROR = !column needs geometry(6, 4326) and value is geometry(6, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4326));
ERROR = !column needs geometry(6, 4326) and value is geometry(8, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(20 20, 30
30, 40 40)', 4326));
ERROR = !column needs geometry(8, 0) and value is geometry(8, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)'));
ERROR = !column needs geometry(8, 0) and value is geometry(4, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 30)'));
ERROR = !column needs geometry(8, 4326) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(30 30, 40
40, 50 50)', 0));
ERROR = !column needs geometry(8, 4326) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)', 4326));
ERROR = !column needs geometry(8, 4326) and value is geometry(4, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(20 20 20, 30
30 30, 40 40 40)', 4326));
ERROR = !column needs geometry(10, 0) and value is geometry(10, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0 0)'));
ERROR = !column needs geometry(10, 0) and value is geometry(6, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(10 10 10, 20
20 20, 30 30 30)'));
ERROR = !column needs geometry(10, 4326) and value is geometry(10, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('linestring(30 30 30, 40
40 40, 50 50 50)', 0));
ERROR = !column needs geometry(10, 4326) and value is geometry(10, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0 0)', 4326));
ERROR = !column needs geometry(10, 4326) and value is geometry(6, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((20 20, 30
30, 40 40, 20 20))', 4326));
ERROR = !column needs geometry(16, 0) and value is geometry(16, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(16, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((10 10, 20
20, 30 30, 10 10))'));
ERROR = !column needs geometry(16, 4326) and value is geometry(16, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((30 30, 40
40, 50 50, 30 30))', 0));
ERROR = !column needs geometry(16, 4326) and value is geometry(16, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4326));
ERROR = !column needs geometry(16, 4326) and value is geometry(8, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((20 20 20,
30 30 30, 40 40 40, 20 20 20))', 4326));
ERROR = !column needs geometry(18, 0) and value is geometry(18, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10 10,
20 20 20, 30 30 30)'));
ERROR = !column needs geometry(18, 0) and value is geometry(10, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((10 10 10,
20 20 20, 30 30 30, 10 10 10))'));
ERROR = !column needs geometry(18, 4326) and value is geometry(18, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('polygon((30 30 30,
40 40 40, 50 50 50, 30 30 30))', 0));
ERROR = !column needs geometry(18, 4326) and value is geometry(18, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10 10,
20 20 20, 30 30 30)', 4326));
ERROR = !column needs geometry(18, 4326) and value is geometry(10, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(20 20, 30
30)', 4326));
ERROR = !column needs geometry(20, 0) and value is geometry(20, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(20, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(10 10, 20
20)'));
ERROR = !column needs geometry(20, 4326) and value is geometry(20, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(30 30, 40
40)', 0));
ERROR = !column needs geometry(20, 4326) and value is geometry(20, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4326));
ERROR = !column needs geometry(20, 4326) and value is geometry(8, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(20 20 20,
30 30 30)', 4326));
ERROR = !column needs geometry(22, 0) and value is geometry(22, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10 10,
20 20 20, 30 30 40)'));
ERROR = !column needs geometry(22, 0) and value is geometry(10, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(10 10 10,
20 20 20)'));
ERROR = !column needs geometry(22, 4326) and value is geometry(22, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('multipoint(30 30 30,
40 40 40)', 0));
ERROR = !column needs geometry(22, 4326) and value is geometry(22, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into points_tbl values (st_geomfromtext('linestring(10 10 10,
20 20 20, 30 30 30)', 4326));
ERROR = !column needs geometry(22, 4326) and value is geometry(10, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((20 20,
30 30, 40 40), (50 50, 60 60, 70 70))', 4326));
ERROR = !column needs geometry(24, 0) and value is geometry(24, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)'));
ERROR = !column needs geometry(24, 0) and value is geometry(4, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((10 10,
20 20, 30 30), (40 40, 50 50, 60 60))'));
ERROR = !column needs geometry(24, 4326) and value is geometry(24, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((30 30,
40 40, 50 50), (60 60, 70 70, 80 80))', 0));
ERROR = !column needs geometry(24, 4326) and value is geometry(24, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)', 4326));
ERROR = !column needs geometry(24, 4326) and value is geometry(4, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((20 20
20, 30 30 30, 40 40 40), (50 50 50, 60 60 60, 70 70 70))', 4326));
ERROR = !column needs geometry(26, 0) and value is geometry(26, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)'));
ERROR = !column needs geometry(26, 0) and value is geometry(4, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((10 10
10, 20 20 20, 30 30 30), (40 40 40, 50 50 50, 60 60 60))'));
ERROR = !column needs geometry(26, 4326) and value is geometry(26, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('multilinestring((30 30
30, 40 40 40, 50 50 50), (60 60 60, 70 70 70, 80 80 80))', 0));
ERROR = !column needs geometry(26, 4326) and value is geometry(26, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into lines_tbl values (st_geomfromtext('point(0 0)', 4326));
ERROR = !column needs geometry(26, 4326) and value is geometry(4, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((20
20, 30 30, 40 40, 20 20),(200 200, 300 300, 400 400, 200 200)))', 4326));
ERROR = !column needs geometry(28, 0) and value is geometry(28, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(28, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((10
10, 20 20, 30 30, 10 10),(100 100, 200 200, 300 300, 100 100)))'));
ERROR = !column needs geometry(28, 4326) and value is geometry(28, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((30
30, 40 40, 50 50, 30 30),(300 300, 400 400, 500 500, 300 300)))', 0));
ERROR = !column needs geometry(28, 4326) and value is geometry(28, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4326));
ERROR = !column needs geometry(28, 4326) and value is geometry(8, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((20 20
20, 30 30 30, 40 40 40, 20 20 20),(200 200 200, 300 300 300, 400 400 400, 200
200 200)))', 4326));
ERROR = !column needs geometry(30, 0) and value is geometry(30, 4326)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)'));
ERROR = !column needs geometry(30, 0) and value is geometry(8, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((10 10
10, 20 20 20, 30 30 30, 10 10 10),(100 100 100, 200 200 200, 300 300 300, 100
100 100)))'));
ERROR = !column needs geometry(30, 4326) and value is geometry(30, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('multipolygon(((30 30
30, 40 40 40, 50 50 50, 30 30 30),(300 300 300, 400 400 400, 500 500 500, 300
300 300)))', 0));
ERROR = !column needs geometry(30, 4326) and value is geometry(30, 0)
-MAPI = (monetdb) /var/tmp/mtest-28358/.s.monetdb.37646
+MAPI = (monetdb) /var/tmp/mtest-6601/.s.monetdb.34457
QUERY = insert into polygons_tbl values (st_geomfromtext('linestring(10 10, 20
20, 30 40)', 4326));
ERROR = !column needs geometry(30, 4326) and value is geometry(8, 4326)
diff --git a/geom/sql/Tests/functions/Tests/ST_GeometryType.sql
b/geom/sql/Tests/functions/Tests/ST_GeometryType.sql
--- a/geom/sql/Tests/functions/Tests/ST_GeometryType.sql
+++ b/geom/sql/Tests/functions/Tests/ST_GeometryType.sql
@@ -42,4 +42,4 @@ WITH t AS ( SELECT 'GEOMETRYCOLLECTION(P
SELECT geometrytype(geom) AS "DESC1", st_geometrytype(geom) AS "DESC2" FROM t;
-SELECT geometrytype(geom) AS "DESC1", st_geometrytype(geom) AS "DESC2" FROM
geometries;
+SELECT geometrytype(geom) AS "DESC1", st_geometrytype(geom) AS "DESC2" FROM
geometries WHERE id<14;
diff --git a/geom/sql/Tests/functions/Tests/ST_IsClosed.sql
b/geom/sql/Tests/functions/Tests/ST_IsClosed.sql
--- a/geom/sql/Tests/functions/Tests/ST_IsClosed.sql
+++ b/geom/sql/Tests/functions/Tests/ST_IsClosed.sql
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
