Changeset: 06b85a591a37 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=06b85a591a37
Added Files:
geom/sql/Tests/pg_regression/Tests/clean.sql
geom/sql/Tests/pg_regression/Tests/delaunaytriangles.sql
geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.err
geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.out
geom/sql/Tests/pg_regression/Tests/node.sql
geom/sql/Tests/pg_regression/Tests/relate_bnr.sql
geom/sql/Tests/pg_regression/Tests/snap.sql
geom/sql/Tests/pg_regression/Tests/unaryunion.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regression: snap node unaryunion clean relate_bnr delaunaytriangles
in_geojson uninstall
diffs (truncated from 815 to 300 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
@@ -123,4 +123,19 @@ boundary #Uknown Types: TRIANGLE (querie
#sharedpaths #Unknown Functions: st_sharedpaths
+#snap #Unknown Functions: st_snap
+
+#node #Unknown Functions: st_node
+
+#unaryunion #Unknown Functions: st_unaryunion
+
+#clean #Unknown Functions: st_isvaliddetail, st_makevalid
+ #It reads from stdin EWKB kai EWKT which is a format introduced
and supported by PostGIS
+
+#relate_bnr #Unknown Functions: ST_Relate(geometry, geometry, int)
+
+delaunaytriangles #unknown Types : TIN (removed tests that need to output TIN)
+
+#in_geojson #Unknown Functions: st_geomfromgeojson, st_asgeojson
+
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/clean.sql
b/geom/sql/Tests/pg_regression/Tests/clean.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/clean.sql
@@ -0,0 +1,54 @@
+CREATE TABLE clean_cases (origin varchar(2), caseno numeric,
+ orig geometry,
+ valid geometry);
+
+COPY 22 RECORDS INTO clean_cases FROM stdin USING DELIMITERS '|','\n';
+RT|1|0103000000010000000700000000000000000000400000000000000040000000000000184000000000000000C000000000000024400000000000000040000000000000244000000000000000C000000000000018400000000000000040000000000000004000000000000000C000000000000000400000000000000040|010600000003000000010300000001000000040000000000000000000040000000000000004000000000000010400000000000000000000000000000004000000000000000C0000000000000004000000000000000400103000000010000000500000000000000000020400000000000000000000000000000184000000000000000C0000000000000104000000000000000000000000000001840000000000000004000000000000020400000000000000000010300000001000000040000000000000000002040000000000000000000000000000024400000000000000040000000000000244000000000000000C000000000000020400000000000000000
+RT|2|01030000000100000007000000000000000000284000000000000000C000000000000028400000000000000040000000000000304000000000000000000000000000002C40000000000000000000000000000032400000000000000040000000000000324000000000000000C0000000000000284000000000000000C0|01030000000200000006000000000000000000284000000000000000C0000000000000284000000000000000400000000000002E40000000000000E03F00000000000032400000000000000040000000000000324000000000000000C0000000000000284000000000000000C0040000000000000000002E40000000000000E03F0000000000002C400000000000000000000000000000304000000000000000000000000000002E40000000000000E03F
+RT|3|01030000000100000006000000000000000000004000000000000010400000000000000040000000000000184000000000000010400000000000001040000000000000184000000000000018400000000000001840000000000000104000000000000000400000000000001040|01060000000200000001030000000100000004000000000000000000004000000000000010400000000000000040000000000000184000000000000010400000000000001040000000000000004000000000000010400103000000010000000400000000000000000010400000000000001040000000000000184000000000000018400000000000001840000000000000104000000000000010400000000000001040
+RT|4|01060000000200000001030000000100000007000000000000000000344000000000000000C00000000000003440000000000000004000000000000038400000000000000000000000000000364000000000000000000000000000003A4000000000000000400000000000003A4000000000000000C0000000000000344000000000000000C001030000000100000005000000000000000000344000000000000010C00000000000003A4000000000000010C00000000000003A4000000000000018C0000000000000344000000000000018C0000000000000344000000000000010C0|01060000000200000001030000000200000006000000000000000000344000000000000000C0000000000000344000000000000000400000000000003740000000000000E03F0000000000003A4000000000000000400000000000003A4000000000000000C0000000000000344000000000000000C0040000000000000000003740000000000000E03F00000000000036400000000000000000000000000000384000000000000000000000000000003740000000000000E03F01030000000100000005000000000000000000344000000000000010C00000000000003A4000000000000010C00000000000003A4000000000000018C0000000000000344000000000000018C000000000000
0344000000000000010C0
+RT|5|010600000001000000010300000001000000070000000000000000001C4000000000000008400000000000001C400000000000001840000000000000224000000000000014400000000000002640000000000000184000000000000026400000000000000840000000000000224000000000000014400000000000001C400000000000000840|010600000002000000010300000001000000040000000000000000001C4000000000000008400000000000001C400000000000001840000000000000224000000000000014400000000000001C4000000000000008400103000000010000000400000000000000000022400000000000001440000000000000264000000000000018400000000000002640000000000000084000000000000022400000000000001440
+RT|6|010300000001000000090000000000000000002840000000000000104000000000000028400000000000001C40000000000000304000000000000018400000000000002C400000000000001440000000000000304000000000000014400000000000002C40000000000000184000000000000032400000000000001C400000000000003240000000000000104000000000000028400000000000001040|010300000003000000060000000000000000002840000000000000104000000000000028400000000000001C400000000000002E40000000000000194000000000000032400000000000001C400000000000003240000000000000104000000000000028400000000000001040050000000000000000002E4000000000000019400000000000002C4000000000000018400000000000002E400000000000001640000000000000304000000000000018400000000000002E400000000000001940040000000000000000002E4000000000000016400000000000002C400000000000001440000000000000304000000000000014400000000000002E400000000000001640
+RT|7|01060000000100000001030000000100000009000000000000000000244000000000000024400000000000002440000000000000344000000000000034400000000000003440000000000000344000000000000024400000000000003E4000000000000024400000000000003E400000000000003440000000000000344000000000000034400000000000003440000000000000244000000000000024400000000000002440|010700000002000000010300000001000000070000000000000000002440000000000000244000000000000024400000000000003440000000000000344000000000000034400000000000003E4000000000000034400000000000003E40000000000000244000000000000034400000000000002440000000000000244000000000000024400102000000020000000000000000003440000000000000344000000000000034400000000000002440
+RT|7.1|0103000000010000000900000000000000000028C0000000000000244000000000000028C0000000000000344000000000000000C0000000000000344000000000000000C00000000000002440000000000000204000000000000024400000000000002040000000000000344000000000000000C0000000000000344000000000000000C0000000000000244000000000000028C00000000000002440|0107000000020000000103000000010000000700000000000000000028C0000000000000244000000000000028C0000000000000344000000000000000C00000000000003440000000000000204000000000000034400000000000002040000000000000244000000000000000C0000000000000244000000000000028C0000000000000244001020000000200000000000000000000C0000000000000344000000000000000C00000000000002440
+RT|8|0103000000010000000C00000000000000000034C000000000000028C000000000000034C000000000000000C0000000000000000000000000000000C0000000000000000000000000000028C000000000000024C000000000000028C000000000000024C0000000000000204000000000000000000000000000002040000000000000000000000000000000C000000000000039C000000000000000C000000000000039C0000000000000084000000000000034C0000000000000084000000000000034C000000000000028C0|01070000000200000001060000000200000001030000000100000007000000000000000000000000000000000000C0000000000000000000000000000028C000000000000024C000000000000028C000000000000024C000000000000000C000000000000024C0000000000000204000000000000000000000000000002040000000000000000000000000000000C00103000000010000000500000000000000000034C000000000000000C000000000000039C000000000000000C000000000000039C0000000000000084000000000000034C0000000000000084000000000000034C000000000000000C001050000000300000001020000000200000000000000000034C000000000000028C000000000000034C000000000000000C0010200000
00200000000000000000034C000000000000000C000000000000024C000000000000000C001020000000200000000000000000024C000000000000000C0000000000000000000000000000000C0
+RT|9|0103000000010000000400000000000000000024400000000000003640000000000000244000000000000040400000000000003440000000000000404000000000000034400000000000003640|010300000001000000050000000000000000002440000000000000364000000000000024400000000000004040000000000000344000000000000040400000000000003440000000000000364000000000000024400000000000003640
+RT|9.1|0103000000010000000600000000000000000028C0000000000000364000000000000028C00000000000004040000000000000204000000000000040400000000000002040000000000000364000000000000000C0000000000000364000000000000000C00000000000004540|0106000000030000000103000000010000000400000000000000000028C0000000000000364000000000000028C000000000000040400000000000001CC0000000000000404000000000000028C000000000000036400103000000010000000400000000000000000000C000000000000040400000000000001CC0000000000000404000000000000000C0000000000000454000000000000000C000000000000040400103000000010000000500000000000000000000C00000000000004040000000000000204000000000000040400000000000002040000000000000364000000000000000C0000000000000364000000000000000C00000000000004040
+RT|10|0103000000010000000500000000000000000039C000000000000024400000000000002EC000000000000024400000000000002EC0000000000000344000000000000039C0000000000000344000000000000039C00000000000002440|0103000000010000000500000000000000000039C000000000000024400000000000002EC000000000000024400000000000002EC0000000000000344000000000000039C0000000000000344000000000000039C00000000000002440
+RT|11|0103000000010000000300000000000000008042C00000000000002E4000000000000042C0000000000000304000000000008042C00000000000002E40|LINESTRING(-37
15,-36 16)
+RT|12|0103000000020000000500000000000000008040C00000000000002C4000000000008040C000000000000031400000000000003EC000000000000031400000000000003EC00000000000002C4000000000008040C00000000000002C400300000000000000000040C00000000000002E400000000000003FC0000000000000304000000000000040C00000000000002E40|0107000000020000000103000000010000000500000000000000008040C00000000000002C4000000000008040C000000000000031400000000000003EC000000000000031400000000000003EC00000000000002C4000000000008040C00000000000002C4001020000000200000000000000000040C00000000000002E400000000000003FC00000000000003040
+RT|13.1|0103000000010000000900000000000000000039C000000000000039400000000000002EC000000000000039400000000000002EC000000000008041400000000000002EC000000000008041400000000000002EC0000000000080414000000000000039C0000000000080414000000000000039C0000000000080414000000000000039C0000000000000394000000000000039C00000000000003940|0103000000010000000900000000000000000039C000000000000039400000000000002EC000000000000039400000000000002EC000000000008041400000000000002EC000000000008041400000000000002EC0000000000080414000000000000039C0000000000080414000000000000039C0000000000080414000000000000039C0000000000000394000000000000039C00000000000003940
+RT|13.2|0103000000010000000700000000000000000044C000000000000039400000000000003EC000000000000039400000000000003EC000000000008041400000000000003EC000000000008046400000000000003EC0000000000080414000000000000044C0000000000080414000000000000044C00000000000003940|010700000002000000010300000001000000050000000000000000003EC000000000008041400000000000003EC0000000000000394000000000000044C0000000000000394000000000000044C000000000008041400000000000003EC000000000008041400102000000020000000000000000003EC000000000008041400000000000003EC00000000000804640
+RT|14|01030000000100000009000000000000000000004000000000000018C0000000000000004000000000000010C0000000000000104000000000000010C0000000000000204000000000000018C0000000000000244000000000000018C0000000000000244000000000000010C0000000000000204000000000000010C0000000000000104000000000000018C0000000000000004000000000000018C0|01060000000200000001030000000100000006000000000000000000004000000000000018C0000000000000004000000000000010C0000000000000104000000000000010C0000000000000184000000000000014C0000000000000104000000000000018C0000000000000004000000000000018C001030000000100000006000000000000000000184000000000000014C0000000000000204000000000000010C0000000000000244000000000000010C0000000000000244000000000000018C0000000000000204000000000000018C0000000000000184000000000000014C0
+RT|15|0103000000010000000B00000000000000000040400000000000002440000000000000404000000000000034400000000000004540000000000000344000000000000045400000000000002E40000000000000454000000000000024400000000000004A4000000000000024400000000000004A4000000000000034400000000000004540000000000000344000000000000045400000000000002E400000000000004540000000000000244000000000000040400000000000002440|010700000002000000010300000001000000070000000000000000004040000000000000244000000000000040400000000000003440000000000000454000000000000034400000000000004A4000000000000034400000000000004A40000000000000244000000000000045400000000000002440000000000000404000000000000024400105000000020000000102000000020000000000000000004540000000000000344000000000000045400000000000002E4001020000000200000000000000000045400000000000002E4000000000000045400000000000002440
+RT|16.1|010600000002000000010300000001000000050000000000000000003640000000000000364000000000000040400000000000003640000000000000404000000000000040400000000000003640000000000000404000000000000036400000000000003640010300000001000000050000000000000000003B400000000000003B4000000000008042400000000000003B40000000000080424000000000008042400000000000003B4000000000008042400000000000003B400000000000003B40|0106000000020000000103000000010000000700000000000000000040400000000000003B400000000000004040000000000000364000000000000036400000000000003640000000000000364000000000000040400000000000003B4000000000000040400000000000003B400000000000003B4000000000000040400000000000003B40010300000001000000070000000000000000003B4000000000000040400000000000003B4000000000008042400000000000804240000000000080424000000000008042400000000000003B4000000000000040400000000000003B40000000000000404000000000000040400000000000003B400000000000004040
+RT|16.2|0106000000020000000103000000010000000500000000000000008043400000000000003640000000000080484000000000000036400000000000804840000000000000404000000000008043400000000000004040000000000080434000000000000036400103000000010000000500000000000000008047400000000000003A4000000000008049400000000000003A4000000000008049400000000000003E4000000000008047400000000000003E4000000000008047400000000000003A40|0106000000020000000103000000010000000900000000000000008048400000000000003A400000000000804840000000000000364000000000008043400000000000003640000000000080434000000000000040400000000000804840000000000000404000000000008048400000000000003E4000000000008047400000000000003E4000000000008047400000000000003A4000000000008048400000000000003A400103000000010000000500000000000000008048400000000000003E4000000000008049400000000000003E4000000000008049400000000000003A4000000000008048400000000000003A4000000000008048400000000000003E40
+RT|16.3|010600000002000000010300000001000000050000000000000000804A4000000000000036400000000000804F4000000000000036400000000000804F4000000000000040400000000000804A4000000000000040400000000000804A400000000000003640010300000001000000050000000000000000804E400000000000003A400000000000804F400000000000003A400000000000804F400000000000003E400000000000804E400000000000003E400000000000804E400000000000003A40|010700000002000000010300000001000000070000000000000000804F400000000000003A400000000000804F4000000000000036400000000000804A4000000000000036400000000000804A4000000000000040400000000000804F4000000000000040400000000000804F400000000000003E400000000000804F400000000000003A400105000000020000000102000000020000000000000000804E400000000000003A400000000000804F400000000000003A400102000000030000000000000000804F400000000000003E400000000000804E400000000000003E400000000000804E400000000000003A40
+RT|16.4|010600000002000000010300000001000000080000000000000000C0504000000000000036400000000000405340000000000000364000000000004053400000000000003A400000000000C053400000000000003C4000000000004053400000000000003E40000000000040534000000000000040400000000000C0504000000000000040400000000000C050400000000000003640010300000001000000060000000000000000C052400000000000003A4000000000004053400000000000003A400000000000C053400000000000003C4000000000004053400000000000003E400000000000C052400000000000003E400000000000C052400000000000003A40|0107000000020000000103000000010000000800000000000000004053400000000000003A40000000000040534000000000000036400000000000C0504000000000000036400000000000C0504000000000000040400000000000405340000000000000404000000000004053400000000000003E400000000000C053400000000000003C4000000000004053400000000000003A400105000000020000000102000000020000000000000000C052400000000000003A4000000000004053400000000000003A4001020000000300000000000000004053400000000000003E400000000000C052400000
000000003E400000000000C052400000000000003A40
+--RT|17.1|SRID=12;010300000003000000050000000000000000004E4000000000000014C0000000000000544000000000000014C0000000000000544000000000000034400000000000004E4000000000000034400000000000004E4000000000000014C0050000000000000000804B4000000000000000000000000000805140000000000000000000000000008051400000000000002E400000000000804B400000000000002E400000000000804B40000000000000000005000000000000000040504000000000000014400000000000C0524000000000000014400000000000C0524000000000000024400000000000405040000000000000244000000000004050400000000000001440|SRID=12;0106000000030000000103000000010000000D0000000000000000004E400000000000002E400000000000004E40000000000000344000000000000054400000000000003440000000000000544000000000000014C00000000000004E4000000000000014C00000000000004E40000000000000000000000000008051400000000000000000000000000080514000000000000014400000000000C0524000000000000014400000000000C0524000000000000024400000000000805140000000000000244000000000008051400000000000002E400000000000004E400000
000000002E40010300000001000000050000000000000000004E4000000000000000000000000000804B4000000000000000000000000000804B400000000000002E400000000000004E400000000000002E400000000000004E400000000000000000010300000001000000050000000000000000805140000000000000244000000000008051400000000000001440000000000040504000000000000014400000000000405040000000000000244000000000008051400000000000002440
+--PG|1|SRID=1;0103000000010000000100000000000000000000000000000000000000|SRID=1;POINT(0
0)
+--PG|2|SRID=3;LINESTRING(0 0, 0 0)|SRID=3;POINT(0 0)
+--PG|3|SRID=43;MULTILINESTRING((0 0, 10 0),(20 20, 20
20))|SRID=43;GEOMETRYCOLLECTION(LINESTRING(0 0, 10 0),POINT(20 20))
+--PG|4|SRID=2;MULTIPOLYGON(((5 3, 7 4, 9 5, 11 6, 13 7, 5 3)),((14 14, 14 14,
14 14, 14 14)))|SRID=2;GEOMETRYCOLLECTION(MULTILINESTRING((5 3,7 4),(7 4,9
5),(9 5,11 6),(11 6,13 7)),POINT(14 14))
+--PG|5|SRID=4;MULTILINESTRING((5 3 0, 7 4 5, 9 5 3, 11 6 4, 13 7 9, 5 3 0),(14
14 2, 14 14 3, 14 14 4, 14 14 5))|SRID=4;GEOMETRYCOLLECTION(MULTILINESTRING((5
3 0,7 4 3.625),(7 4 3.625,9 5 3.75),(9 5 3.75,11 6 5.375),(11 6 5.375,13 7
9)),POINT(14 14 2))
+--\.
+
+
+-- PG.1 : polygon with single ring with single point in it
+-- to be converted to a POINT
+--
+
+SELECT origin,caseno,
+ st_equals(st_collectionextract(st_makevalid(orig),1),
st_collectionextract(valid,1)) AND
+ st_equals(st_collectionextract(st_makevalid(orig),2),
st_collectionextract(valid,2)) AND
+ st_equals(st_collectionextract(st_makevalid(orig),3),
st_collectionextract(valid,3)),
+ st_isvalid(st_makevalid(orig)), -- paranoia
+ (st_isvaliddetail(orig)).valid
+ FROM clean_cases;
+
+
+SELECT '#1719.1', ST_AsEWKT(ST_MakeValid('POINT(0 0)'));
+SELECT '#1719.2', ST_AsEWKT(ST_MakeValid('GEOMETRYCOLLECTION(POINT(0
0),MULTIPOINT(3 4,5 2),LINESTRING(4 4, 4 4),POLYGON((0 0,10 10,0 10,10 0,0
0)))'));
+SELECT '#1719.3', ST_AsEWKT(ST_MakeValid('MULTIPOINT(3 4,5 2)'));
+
+DROP TABLE clean_cases;
diff --git a/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.sql
b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.sql
@@ -0,0 +1,8 @@
+-- MonetDB does not support default values for this function
+SELECT 1, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9)'), 0.0, 0));
+SELECT 2, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 0.0, 0));
+SELECT 3, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 2.0, 0));
+SELECT 4, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 2.0, 1));
+--SELECT 5, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0,
7 9)'), 0.0, 2));
+--SELECT 6, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0,
7 9, 8 9)'), 0.0, 2));
+--SELECT 7, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0,
7 9, 8 9)'), 2.0, 2));
diff --git a/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.err
b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.err
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.err
@@ -0,0 +1,36 @@
+stderr of test 'delaunaytriangles` in directory 'geom/sql/Tests/pg_regression`
itself:
+
+
+# 11:45:10 >
+# 11:45:10 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=37553" "--set"
"mapi_usock=/var/tmp/mtest-4255/.s.monetdb.37553" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_pg_regression"
"--set" "mal_listing=0"
+# 11:45:10 >
+
+# builtin opt gdk_dbpath =
/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = no
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 37553
+# cmdline opt mapi_usock = /var/tmp/mtest-4255/.s.monetdb.37553
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_pg_regression
+# cmdline opt mal_listing = 0
+# cmdline opt gdk_debug = 536870922
+
+# 11:45:10 >
+# 11:45:10 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-4255" "--port=37553"
+# 11:45:10 >
+
+
+# 11:45:10 >
+# 11:45:10 > "Done."
+# 11:45:10 >
+
diff --git a/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.out
b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.out
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/delaunaytriangles.stable.out
@@ -0,0 +1,55 @@
+stdout of test 'delaunaytriangles` in directory 'geom/sql/Tests/pg_regression`
itself:
+
+
+# 11:45:10 >
+# 11:45:10 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=37553" "--set"
"mapi_usock=/var/tmp/mtest-4255/.s.monetdb.37553" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_pg_regression"
"--set" "mal_listing=0"
+# 11:45:10 >
+
+# MonetDB 5 server v11.20.0
+# This is an unreleased version
+# Serving database 'mTests_geom_sql_Tests_pg_regression', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit
integers dynamically linked
+# Found 15.356 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sibuyan.da.cwi.nl:37553/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-4255/.s.monetdb.37553
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+
+# 11:45:10 >
+# 11:45:10 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-4255" "--port=37553"
+# 11:45:10 >
+
+#SELECT 1, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9)'), 0.0, 0));
+% .L1, .L1 # table_name
+% L1, st_wkttosql_single_value # name
+% tinyint, clob # type
+% 1, 189 # length
+[ 1, "\"GEOMETRYCOLLECTION (POLYGON ((5.0000000000000000 5.0000000000000000,
6.0000000000000000 0.0000000000000000, 7.0000000000000000 9.0000000000000000,
5.0000000000000000 5.0000000000000000)))\"" ]
+#SELECT 2, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 0.0, 0));
+% .L1, .L1 # table_name
+% L1, st_wkttosql_single_value # name
+% tinyint, clob # type
+% 1, 357 # length
+[ 2, "\"GEOMETRYCOLLECTION (POLYGON ((5.0000000000000000 5.0000000000000000,
6.0000000000000000 0.0000000000000000, 8.0000000000000000 9.0000000000000000,
5.0000000000000000 5.0000000000000000)), POLYGON ((5.0000000000000000
5.0000000000000000, 8.0000000000000000 9.0000000000000000, 7.0000000000000000
9.0000000000000000, 5.0000000000000000 5.0000000000000000)))\"" ]
+#SELECT 3, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 2.0, 0));
+% .L1, .L1 # table_name
+% L1, st_wkttosql_single_value # name
+% tinyint, clob # type
+% 1, 189 # length
+[ 3, "\"GEOMETRYCOLLECTION (POLYGON ((5.0000000000000000 5.0000000000000000,
6.0000000000000000 0.0000000000000000, 7.0000000000000000 9.0000000000000000,
5.0000000000000000 5.0000000000000000)))\"" ]
+#SELECT 4, ST_AsText(ST_DelaunayTriangles(ST_WKTToSQL('MULTIPOINT(5 5, 6 0, 7
9, 8 9)'), 2.0, 1));
+% .L1, .L1 # table_name
+% L1, st_wkttosql_single_value # name
+% tinyint, clob # type
+% 1, 258 # length
+[ 4, "\"MULTILINESTRING ((5.0000000000000000 5.0000000000000000,
7.0000000000000000 9.0000000000000000), (5.0000000000000000 5.0000000000000000,
6.0000000000000000 0.0000000000000000), (6.0000000000000000 0.0000000000000000,
7.0000000000000000 9.0000000000000000))\"" ]
+
+# 11:45:10 >
+# 11:45:10 > "Done."
+# 11:45:10 >
+
diff --git a/geom/sql/Tests/pg_regression/Tests/node.sql
b/geom/sql/Tests/pg_regression/Tests/node.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/node.sql
@@ -0,0 +1,8 @@
+-- Node two crossing lines
+select 't1', st_asewkt(st_node(ST_GeomFromText('MULTILINESTRING((0 0, 10 0),(5
-5, 5 5))', 10)));
+
+-- Node two overlapping lines
+select 't2', st_asewkt(st_node(ST_GeomFromText('MULTILINESTRING((0 0, 10 0, 20
0),(25 0, 15 0, 8 0))', 10)));
+
+-- Node a self-intersecting line
+select st_node(ST_GeomFromText('LINESTRING(0 0, 10 10, 0 10, 10 0)', 10));
diff --git a/geom/sql/Tests/pg_regression/Tests/relate_bnr.sql
b/geom/sql/Tests/pg_regression/Tests/relate_bnr.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/relate_bnr.sql
@@ -0,0 +1,557 @@
+SELECT '1', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,80 0,80 80,0 80,0 0))'
as a, 'POLYGON((100 200,100 140,180 140,180 200,100 200))' as b) as f;
+SELECT '2', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,140 0,140 140,0 140,0
0))' as a, 'POLYGON((140 0,0 0,0 140,140 140,140 0))' as b) as f;
+SELECT '3', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 60,360 60,360 300,40
300,40 60))' as a, 'POLYGON((120 100,280 100,280 240,120 240,120 100))' as b)
as f;
+SELECT '4', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 60,420 60,420 320,40
320,40 60),(200 140,160 220,260 200,200 140))' as a, 'POLYGON((80 100,360
100,360 280,80 280,80 100))' as b) as f;
+SELECT '5', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 280,0 0,260 0,260 280,0
280),(220 240,40 240,40 40,220 40,220 240))' as a, 'POLYGON((20 260,240 260,240
20,20 20,20 260),(160 180,80 180,120 120,160 180))' as b) as f;
+SELECT '6', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 80,200 80,200 220,60
220,60 80))' as a, 'POLYGON((120 140,260 140,260 260,120 260,120 140))' as b)
as f;
+SELECT '7', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 220,220 220,140 140,60
220))' as a, 'POLYGON((100 180,180 180,180 100,100 100,100 180))' as b) as f;
+SELECT '8', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 40,180 40,180 180,40
180,40 40))' as a, 'POLYGON((180 40,40 180,160 280,300 140,180 40))' as b) as f;
+SELECT '9', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 60,140 100,100 140,60
100,100 60))' as a, 'MULTIPOLYGON(((80 40,120 40,120 80,80 80,80 40)),((120
80,160 80,160 120,120 120,120 80)),((80 120,120 120,120 160,80 160,80
120)),((40 80,80 80,80 120,40 120,40 80)))' as b) as f;
+SELECT '10', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 280,200 280,200 100,40
100,40 280),(100 220,120 220,120 200,100 180,100 220))' as a, 'POLYGON((40
280,180 260,180 120,60 120,40 280))' as b) as f;
+SELECT '11', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 200,0 0,200 0,200 200,0
200),(20 180,130 180,130 30,20 30,20 180))' as a, 'POLYGON((60 90,130 90,130
30,60 30,60 90))' as b) as f;
+SELECT '12', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((150 150,410 150,280 20,20
20,150 150),(170 120,330 120,260 50,100 50,170 120))' as a, 'POLYGON((270
90,200 50,150 80,210 120,270 90))' as b) as f;
+SELECT '13', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 60,140 100,100 140,60
100,100 60))' as a, 'MULTIPOLYGON(((80 40,120 40,120 80,80 80,80 40)),((120
80,160 80,160 120,120 120,120 80)),((80 120,120 120,120 160,80 160,80
120)),((40 80,80 80,80 120,40 120,40 80)))' as b) as f;
+SELECT '14', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 120,100 240)' as a,
'POLYGON((40 60,160 60,160 180,40 180,40 60))' as b) as f;
+SELECT '15', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 80,140 140,200 200)'
as a, 'POLYGON((40 40,140 40,140 140,40 140,40 40))' as b) as f;
+SELECT '16', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(70 50,70 150)' as a,
'MULTIPOLYGON(((0 0,0 100,140 100,140 0,0 0)),((20 170,70 100,130 170,20
170)))' as b) as f;
+SELECT '17', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)' as a,
'POLYGON((190 190,360 20,20 20,190 190),(110 110,250 100,140 30,110 110))' as
b) as f;
+SELECT '18', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)' as a,
'POLYGON((190 190,360 20,20 20,190 190),(111 110,250 100,140 30,111 110))' as
b) as f;
+SELECT '19', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,170 110)' as a,
'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130
110),(130 180,130 40,200 110,130 180))' as b) as f;
+SELECT '20', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,170 110)' as a,
'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130
110),(130 180,131 40,200 110,130 180))' as b) as f;
+SELECT '21', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(160 70,320 230)' as a,
'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340
190,220 190,300 270)))' as b) as f;
+SELECT '22', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 140,100 40)' as a,
'MULTIPOLYGON(((20 80,180 79,100 0,20 80)),((20 160,180 160,100 80,20 160)))'
as b) as f;
+SELECT '23', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 140,100 40)' as a,
'MULTIPOLYGON(((20 80,180 80,100 0,20 80)),((20 160,180 160,100 80,20 160)))'
as b) as f;
+SELECT '24', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 60,20 150,200
150,110 60)' as a, 'POLYGON((20 20,200 20,110 110,20 20))' as b) as f;
+SELECT '25', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,0 50,50 50,50 0,0
0)' as a, 'MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))' as
b) as f;
+SELECT '26', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)' as a,
'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((20 180,20 80,180
80,180 180,20 180)))' as b) as f;
+SELECT '27', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)' as a,
'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((60 180,60 80,180
80,180 180,60 180)))' as b) as f;
+SELECT '28', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,60 0,60 60,60 0,120
0)' as a, 'MULTILINESTRING((0 0,60 0),(60 0,120 0),(60 0,60 60))' as b) as f;
+SELECT '29', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80
120,40 140)' as a, 'LINESTRING(140 300,220 160,260 200,240 260)' as b) as f;
+SELECT '30', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80
120,40 140)' as a, 'LINESTRING(60 40,140 40,140 160,0 160)' as b) as f;
+SELECT '31', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80
120,40 140)' as a, 'LINESTRING(140 280,240 280,240 180,140 180,140 280)' as b)
as f;
+SELECT '32', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(140 0,0 0,40 60,0 120,60
200,220 160,220 40)' as a, 'LINESTRING(80 140,180 100,160 40,100 40,60 100,80
140)' as b) as f;
+SELECT '33', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80)' as a,
'LINESTRING(20 20,80 80)' as b) as f;
+SELECT '34', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,160 160,200 60,60
140)' as a, 'LINESTRING(40 40,160 160,200 60,60 140)' as b) as f;
+SELECT '35', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,200 40)' as a,
'LINESTRING(200 40,140 40,40 40)' as b) as f;
+SELECT '36', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,110 0,60 0)' as a,
'LINESTRING(0 0,110 0)' as b) as f;
+SELECT '37', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,0 50,50 50,50 0,0
0)' as a, 'MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))' as
b) as f;
+SELECT '38', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,80 0,80 60,80 0,170
0)' as a, 'MULTILINESTRING((0 0,170 0),(80 0,80 60))' as b) as f;
+SELECT '39', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 100,180 200)' as a,
'LINESTRING(80 180,180 120)' as b) as f;
+SELECT '40', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,160 160)'
as a, 'LINESTRING(160 60,100 100,60 140)' as b) as f;
+SELECT '41', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,180
100,180 180,100 180,100 100)' as a, 'LINESTRING(140 60,60 140)' as b) as f;
+SELECT '42', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180,100
180,100 100)' as a, 'LINESTRING(140 60,60 140)' as b) as f;
+SELECT '43', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 110,200 110)' as a,
'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)' as b) as f;
+SELECT '44', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 90,50 50,0 0)' as a,
'LINESTRING(0 0,100 100)' as b) as f;
+SELECT '45', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 140,240 140)' as a,
'LINESTRING(40 140,100 140,80 80,120 60,100 140,160 140,160 100,200 100,160
140,240 140)' as b) as f;
+SELECT '46', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,100 20,20 20)' as
a, 'LINESTRING(60 20,200 20)' as b) as f;
+SELECT '47', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 60,180 60,180 140,100
140,100 60,220 60,220 180,80 180,80 60,280 60)' as a, 'LINESTRING(140 60,180
60,220 60,260 60)' as b) as f;
+SELECT '48', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)' as a, 'POLYGON((60
120,60 40,160 40,160 120,60 120))' as b) as f;
+SELECT '49', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(0 20,40 20)' as a,
'POLYGON((20 40,20 0,60 0,60 40,20 40))' as b) as f;
+SELECT '50', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(0 20,20 20)' as a,
'POLYGON((20 40,20 0,60 0,60 40,20 40))' as b) as f;
+SELECT '51', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 20,40 20)' as a,
'POLYGON((20 40,20 0,60 0,60 40,20 40))' as b) as f;
+SELECT '52', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(80 260,140 260,180 260)'
as a, 'POLYGON((40 320,140 320,140 200,40 200,40 320))' as b) as f;
+SELECT '53', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(40 40)' as a,
'MULTIPOLYGON(((0 40,0 0,40 0,40 40,0 40)),((40 80,40 40,80 40,80 80,40 80)))'
as b) as f;
+SELECT '54', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 120)' as a, 'LINESTRING(40
40,120 120,200 120)' as b) as f;
+SELECT '55', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(40 40)' as a, 'LINESTRING(40
40,100 100,160 100)' as b) as f;
+SELECT '56', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 60)' as a, 'LINESTRING(40
40,100 100)' as b) as f;
+SELECT '57', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,100 40)' as a,
'LINESTRING(40 40,80 80)' as b) as f;
+SELECT '58', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,60 60)' as a,
'LINESTRING(40 40,80 80)' as b) as f;
+SELECT '59', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)' as a,
'LINESTRING(40 40,80 80)' as b) as f;
+SELECT '60', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)' as a,
'LINESTRING(40 40,80 80)' as b) as f;
+SELECT '61', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)' as a,
'LINESTRING(40 40,60 60,80 80)' as b) as f;
+SELECT '62', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)' as a, 'POINT(20 20)'
as b) as f;
+SELECT '63', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)' as a, 'POINT(20 30)'
as b) as f;
+SELECT '64', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,40 100)' as
a, 'MULTIPOINT(40 40,80 60,120 100)' as b) as f;
+SELECT '65', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,120 100)' as
a, 'MULTIPOINT(40 40,80 60,120 100)' as b) as f;
+SELECT '66', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,100 200,200
200,200 100,100 100))' as a, 'POLYGON((100 100,1e+15 110,1e+15 100,100 100))'
as b) as f;
+SELECT '67', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,120 200,200
200,200 100,120 100))' as a, 'POLYGON((100 100,1e+15 110,1e+15 100,100 100))'
as b) as f;
+SELECT '68', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140
20,20 20))' as a, 'POLYGON((20 20,20 100,120 100,140 20,20 20))' as b) as f;
+SELECT '69', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140
20,20 20))' as a, 'POLYGON((20 20,140 20,120 100,20 100,20 20))' as b) as f;
+SELECT '70', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140
20,20 20))' as a, 'POLYGON((120 100,140 20,20 20,20 100,120 100))' as b) as f;
+SELECT '71', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140
20,20 20))' as a, 'POLYGON((20 100,60 100,120 100,140 20,80 20,20 20,20 100))'
as b) as f;
+SELECT '72', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,80 0,80 80,0 80,0 0))'
as a, 'POLYGON((100 200,100 140,180 140,180 200,100 200))' as b) as f;
+SELECT '73', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20
120,140 120))' as a, 'POLYGON((140 120,140 200,240 200,240 120,140 120))' as b)
as f;
+SELECT '74', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20
120,140 120))' as a, 'POLYGON((80 180,140 260,260 200,200 60,80 180))' as b) as
f;
+SELECT '75', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20
120,140 120))' as a, 'POLYGON((240 80,140 120,180 240,280 200,240 80))' as b)
as f;
+SELECT '76', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 160,20 20,270 20,150
160,230 40,60 40,140 160))' as a, 'POLYGON((140 40,180 80,120 100,140 40))' as
b) as f;
+SELECT '77', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 160,20 20,270 20,150
160,230 40,60 40,140 160))' as a, 'POLYGON((120 100,180 80,130 40,120 100))' as
b) as f;
+SELECT '78', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,180 20,140 140,20
140,20 20))' as a, 'POLYGON((180 100,80 200,180 280,260 200,180 100))' as b) as
f;
+SELECT '79', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20
120,140 120))' as a, 'POLYGON((140 140,20 120,0 220,120 240,140 140))' as b) as
f;
+SELECT '80', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((160 200,210 70,120 70,160
200))' as a, 'POLYGON((160 200,260 40,70 40,160 200,20 20,310 20,160 200))' as
b) as f;
+SELECT '81', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((110 140,200 70,200 160,110
140))' as a, 'POLYGON((110 140,110 50,60 50,60 90,160 190,20 110,20 20,200
20,110 140))' as b) as f;
+SELECT '82', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 120,20 20,260 20,260
120,200 40,140 120,80 40,20 120))' as a, 'POLYGON((20 120,20 240,260 240,260
120,200 200,140 120,80 200,20 120))' as b) as f;
+SELECT '83', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 120,20 20,260 20,260
120,180 40,140 120,100 40,20 120))' as a, 'POLYGON((20 120,300 120,140 240,20
120))' as b) as f;
+SELECT '84', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 300,280 300,280
260,220 260,60 100,60 60,280 60,280 20,20 20))' as a, 'POLYGON((100 140,160
80,280 180,200 240,220 160,160 200,180 120,100 140))' as b) as f;
+SELECT '85', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 300,280 300,280
260,220 260,60 100,60 60,280 60,280 20,20 20))' as a, 'POLYGON((260 200,180
80,120 160,200 160,180 220,260 200))' as b) as f;
+SELECT '86', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3)
as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,280 20,280 140,220
60,140 140,80 60,20 140,20 20))' as a, 'POLYGON((0 140,300 140,140 240,0 140))'
as b) as f;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
