Changeset: bdfa23789109 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bdfa23789109
Added Files:
geom/sql/Tests/pg_regression/Tests/relate.sql
geom/sql/Tests/pg_regression/Tests/remove_repeated_points.sql
geom/sql/Tests/pg_regression/Tests/split.sql
geom/sql/Tests/pg_regression/Tests/tickets.sql
geom/sql/Tests/pg_regression/Tests/typmod.sql
geom/sql/Tests/pg_regression/Tests/wkb.sql
geom/sql/Tests/pg_regression/Tests/wkt.sql
geom/sql/Tests/pg_regression/Tests/wmsservers.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regress: wmsservers, wkt, wkb, tickets, typmod, remove_repeated_points,
split, relate
diffs (truncated from 3231 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
@@ -90,6 +90,22 @@ dumppoints #Uknown Types: TRIANGLE, TIN,
boundary #Uknown Types: TRIANGLE (queries for these types commented out)
+#wmsservers #Not applicable to MonetDB (?)
+
+#wkt #Unknown Functions: st_orderingequals
+
+#wkb #Unknown Functions: st_asbinary(char,char), encode, st_orderingequals
+
+#tickets #Unknown Functions: st_locate_along_measure, round, st_asgml,
ST_Shift_Longitude, st_linetocurve, st_forcecollection, st_multi,
st_curvetoline, st_snaptogrid, st_asewkb(geometry,char), ST_AsSVG,
st_linecrossingdirection, ST_GeographyFromText, geography, ...
+ #Unknown Types: CIRCULARSTRING, COMPOUNDCURVE
+
+#typmod #Unknwown Types: circularstring, compoundcurve, curvepolygon,
geography, multicurve, multisurface, polyhedralsurface, tin, triangle
+
+#remove_repeated_points #Unknown Functions: #st_removerepeatedpoints
+
+#split #Unknown Functions: #st_split
+
+#relate #Unknown Functions: st_relate(char,char)
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/relate.sql
b/geom/sql/Tests/pg_regression/Tests/relate.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/relate.sql
@@ -0,0 +1,555 @@
+SELECT '1', ST_Relate('POLYGON((0 0,80 0,80 80,0 80,0 0))','POLYGON((100
200,100 140,180 140,180 200,100 200))');
+SELECT '2', ST_Relate('POLYGON((0 0,140 0,140 140,0 140,0 0))','POLYGON((140
0,0 0,0 140,140 140,140 0))');
+SELECT '3', ST_Relate('POLYGON((40 60,360 60,360 300,40 300,40
60))','POLYGON((120 100,280 100,280 240,120 240,120 100))');
+SELECT '4', ST_Relate('POLYGON((40 60,420 60,420 320,40 320,40 60),(200
140,160 220,260 200,200 140))','POLYGON((80 100,360 100,360 280,80 280,80
100))');
+SELECT '5', ST_Relate('POLYGON((0 280,0 0,260 0,260 280,0 280),(220 240,40
240,40 40,220 40,220 240))','POLYGON((20 260,240 260,240 20,20 20,20 260),(160
180,80 180,120 120,160 180))');
+SELECT '6', ST_Relate('POLYGON((60 80,200 80,200 220,60 220,60
80))','POLYGON((120 140,260 140,260 260,120 260,120 140))');
+SELECT '7', ST_Relate('POLYGON((60 220,220 220,140 140,60 220))','POLYGON((100
180,180 180,180 100,100 100,100 180))');
+SELECT '8', ST_Relate('POLYGON((40 40,180 40,180 180,40 180,40
40))','POLYGON((180 40,40 180,160 280,300 140,180 40))');
+SELECT '9', ST_Relate('POLYGON((100 60,140 100,100 140,60 100,100
60))','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)))');
+SELECT '10', ST_Relate('POLYGON((40 280,200 280,200 100,40 100,40 280),(100
220,120 220,120 200,100 180,100 220))','POLYGON((40 280,180 260,180 120,60
120,40 280))');
+SELECT '11', ST_Relate('POLYGON((0 200,0 0,200 0,200 200,0 200),(20 180,130
180,130 30,20 30,20 180))','POLYGON((60 90,130 90,130 30,60 30,60 90))');
+SELECT '12', ST_Relate('POLYGON((150 150,410 150,280 20,20 20,150 150),(170
120,330 120,260 50,100 50,170 120))','POLYGON((270 90,200 50,150 80,210 120,270
90))');
+SELECT '13', ST_Relate('POLYGON((100 60,140 100,100 140,60 100,100
60))','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)))');
+SELECT '14', ST_Relate('LINESTRING(100 120,100 240)','POLYGON((40 60,160
60,160 180,40 180,40 60))');
+SELECT '15', ST_Relate('LINESTRING(80 80,140 140,200 200)','POLYGON((40 40,140
40,140 140,40 140,40 40))');
+SELECT '16', ST_Relate('LINESTRING(70 50,70 150)','MULTIPOLYGON(((0 0,0
100,140 100,140 0,0 0)),((20 170,70 100,130 170,20 170)))');
+SELECT '17', ST_Relate('LINESTRING(60 160,150 70)','POLYGON((190 190,360 20,20
20,190 190),(110 110,250 100,140 30,110 110))');
+SELECT '18', ST_Relate('LINESTRING(60 160,150 70)','POLYGON((190 190,360 20,20
20,190 190),(111 110,250 100,140 30,111 110))');
+SELECT '19', ST_Relate('LINESTRING(80 110,170 110)','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))');
+SELECT '20', ST_Relate('LINESTRING(80 110,170 110)','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))');
+SELECT '21', ST_Relate('LINESTRING(160 70,320 230)','MULTIPOLYGON(((140
110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300
270)))');
+SELECT '22', ST_Relate('LINESTRING(100 140,100 40)','MULTIPOLYGON(((20 80,180
79,100 0,20 80)),((20 160,180 160,100 80,20 160)))');
+SELECT '23', ST_Relate('LINESTRING(100 140,100 40)','MULTIPOLYGON(((20 80,180
80,100 0,20 80)),((20 160,180 160,100 80,20 160)))');
+SELECT '24', ST_Relate('LINESTRING(110 60,20 150,200 150,110 60)','POLYGON((20
20,200 20,110 110,20 20))');
+SELECT '25', ST_Relate('LINESTRING(0 0,0 50,50 50,50 0,0
0)','MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))');
+SELECT '26', ST_Relate('LINESTRING(40 180,140 180)','MULTIPOLYGON(((20 320,180
320,180 180,20 180,20 320)),((20 180,20 80,180 80,180 180,20 180)))');
+SELECT '27', ST_Relate('LINESTRING(40 180,140 180)','MULTIPOLYGON(((20 320,180
320,180 180,20 180,20 320)),((60 180,60 80,180 80,180 180,60 180)))');
+SELECT '28', ST_Relate('LINESTRING(0 0,60 0,60 60,60 0,120
0)','MULTILINESTRING((0 0,60 0),(60 0,120 0),(60 0,60 60))');
+SELECT '29', ST_Relate('LINESTRING(60 0,20 80,100 80,80 120,40
140)','LINESTRING(140 300,220 160,260 200,240 260)');
+SELECT '30', ST_Relate('LINESTRING(60 0,20 80,100 80,80 120,40
140)','LINESTRING(60 40,140 40,140 160,0 160)');
+SELECT '31', ST_Relate('LINESTRING(60 0,20 80,100 80,80 120,40
140)','LINESTRING(140 280,240 280,240 180,140 180,140 280)');
+SELECT '32', ST_Relate('LINESTRING(140 0,0 0,40 60,0 120,60 200,220 160,220
40)','LINESTRING(80 140,180 100,160 40,100 40,60 100,80 140)');
+SELECT '33', ST_Relate('LINESTRING(20 20,80 80)','LINESTRING(20 20,80 80)');
+SELECT '34', ST_Relate('LINESTRING(40 40,160 160,200 60,60
140)','LINESTRING(40 40,160 160,200 60,60 140)');
+SELECT '35', ST_Relate('LINESTRING(40 40,200 40)','LINESTRING(200 40,140 40,40
40)');
+SELECT '36', ST_Relate('LINESTRING(0 0,110 0,60 0)','LINESTRING(0 0,110 0)');
+SELECT '37', ST_Relate('LINESTRING(0 0,0 50,50 50,50 0,0
0)','MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))');
+SELECT '38', ST_Relate('LINESTRING(0 0,80 0,80 60,80 0,170
0)','MULTILINESTRING((0 0,170 0),(80 0,80 60))');
+SELECT '39', ST_Relate('LINESTRING(80 100,180 200)','LINESTRING(80 180,180
120)');
+SELECT '40', ST_Relate('LINESTRING(40 40,100 100,160 160)','LINESTRING(160
60,100 100,60 140)');
+SELECT '41', ST_Relate('LINESTRING(40 40,100 100,180 100,180 180,100 180,100
100)','LINESTRING(140 60,60 140)');
+SELECT '42', ST_Relate('LINESTRING(40 40,180 180,100 180,100
100)','LINESTRING(140 60,60 140)');
+SELECT '43', ST_Relate('LINESTRING(20 110,200 110)','LINESTRING(200 200,20
20,200 20,110 110,20 200,110 200,110 110)');
+SELECT '44', ST_Relate('LINESTRING(80 90,50 50,0 0)','LINESTRING(0 0,100
100)');
+SELECT '45', ST_Relate('LINESTRING(40 140,240 140)','LINESTRING(40 140,100
140,80 80,120 60,100 140,160 140,160 100,200 100,160 140,240 140)');
+SELECT '46', ST_Relate('LINESTRING(20 20,100 20,20 20)','LINESTRING(60 20,200
20)');
+SELECT '47', ST_Relate('LINESTRING(40 60,180 60,180 140,100 140,100 60,220
60,220 180,80 180,80 60,280 60)','LINESTRING(140 60,180 60,220 60,260 60)');
+SELECT '48', ST_Relate('POINT(20 20)','POLYGON((60 120,60 40,160 40,160 120,60
120))');
+SELECT '49', ST_Relate('MULTIPOINT(0 20,40 20)','POLYGON((20 40,20 0,60 0,60
40,20 40))');
+SELECT '50', ST_Relate('MULTIPOINT(0 20,20 20)','POLYGON((20 40,20 0,60 0,60
40,20 40))');
+SELECT '51', ST_Relate('MULTIPOINT(20 20,40 20)','POLYGON((20 40,20 0,60 0,60
40,20 40))');
+SELECT '52', ST_Relate('MULTIPOINT(80 260,140 260,180 260)','POLYGON((40
320,140 320,140 200,40 200,40 320))');
+SELECT '53', ST_Relate('POINT(40 40)','MULTIPOLYGON(((0 40,0 0,40 0,40 40,0
40)),((40 80,40 40,80 40,80 80,40 80)))');
+SELECT '54', ST_Relate('POINT(60 120)','LINESTRING(40 40,120 120,200 120)');
+SELECT '55', ST_Relate('POINT(40 40)','LINESTRING(40 40,100 100,160 100)');
+SELECT '56', ST_Relate('POINT(60 60)','LINESTRING(40 40,100 100)');
+SELECT '57', ST_Relate('MULTIPOINT(40 40,100 40)','LINESTRING(40 40,80 80)');
+SELECT '58', ST_Relate('MULTIPOINT(40 40,60 60)','LINESTRING(40 40,80 80)');
+SELECT '59', ST_Relate('MULTIPOINT(60 60,100 100)','LINESTRING(40 40,80 80)');
+SELECT '60', ST_Relate('MULTIPOINT(60 60,100 100)','LINESTRING(40 40,80 80)');
+SELECT '61', ST_Relate('MULTIPOINT(60 60,100 100)','LINESTRING(40 40,60 60,80
80)');
+SELECT '62', ST_Relate('POINT(20 20)','POINT(20 20)');
+SELECT '63', ST_Relate('POINT(20 20)','POINT(20 30)');
+SELECT '64', ST_Relate('MULTIPOINT(40 40,80 60,40 100)','MULTIPOINT(40 40,80
60,120 100)');
+SELECT '65', ST_Relate('MULTIPOINT(40 40,80 60,120 100)','MULTIPOINT(40 40,80
60,120 100)');
+SELECT '66', ST_Relate('POLYGON((100 100,100 200,200 200,200 100,100
100))','POLYGON((100 100,1e+15 110,1e+15 100,100 100))');
+SELECT '67', ST_Relate('POLYGON((120 100,120 200,200 200,200 100,120
100))','POLYGON((100 100,1e+15 110,1e+15 100,100 100))');
+SELECT '68', ST_Relate('POLYGON((20 20,20 100,120 100,140 20,20
20))','POLYGON((20 20,20 100,120 100,140 20,20 20))');
+SELECT '69', ST_Relate('POLYGON((20 20,20 100,120 100,140 20,20
20))','POLYGON((20 20,140 20,120 100,20 100,20 20))');
+SELECT '70', ST_Relate('POLYGON((20 20,20 100,120 100,140 20,20
20))','POLYGON((120 100,140 20,20 20,20 100,120 100))');
+SELECT '71', ST_Relate('POLYGON((20 20,20 100,120 100,140 20,20
20))','POLYGON((20 100,60 100,120 100,140 20,80 20,20 20,20 100))');
+SELECT '72', ST_Relate('POLYGON((0 0,80 0,80 80,0 80,0 0))','POLYGON((100
200,100 140,180 140,180 200,100 200))');
+SELECT '73', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((140 120,140 200,240 200,240 120,140 120))');
+SELECT '74', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((80 180,140 260,260 200,200 60,80 180))');
+SELECT '75', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((240 80,140 120,180 240,280 200,240 80))');
+SELECT '76', ST_Relate('POLYGON((140 160,20 20,270 20,150 160,230 40,60 40,140
160))','POLYGON((140 40,180 80,120 100,140 40))');
+SELECT '77', ST_Relate('POLYGON((140 160,20 20,270 20,150 160,230 40,60 40,140
160))','POLYGON((120 100,180 80,130 40,120 100))');
+SELECT '78', ST_Relate('POLYGON((20 20,180 20,140 140,20 140,20
20))','POLYGON((180 100,80 200,180 280,260 200,180 100))');
+SELECT '79', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((140 140,20 120,0 220,120 240,140 140))');
+SELECT '80', ST_Relate('POLYGON((160 200,210 70,120 70,160
200))','POLYGON((160 200,260 40,70 40,160 200,20 20,310 20,160 200))');
+SELECT '81', ST_Relate('POLYGON((110 140,200 70,200 160,110
140))','POLYGON((110 140,110 50,60 50,60 90,160 190,20 110,20 20,200 20,110
140))');
+SELECT '82', ST_Relate('POLYGON((20 120,20 20,260 20,260 120,200 40,140 120,80
40,20 120))','POLYGON((20 120,20 240,260 240,260 120,200 200,140 120,80 200,20
120))');
+SELECT '83', ST_Relate('POLYGON((20 120,20 20,260 20,260 120,180 40,140
120,100 40,20 120))','POLYGON((20 120,300 120,140 240,20 120))');
+SELECT '84', ST_Relate('POLYGON((20 20,20 300,280 300,280 260,220 260,60
100,60 60,280 60,280 20,20 20))','POLYGON((100 140,160 80,280 180,200 240,220
160,160 200,180 120,100 140))');
+SELECT '85', ST_Relate('POLYGON((20 20,20 300,280 300,280 260,220 260,60
100,60 60,280 60,280 20,20 20))','POLYGON((260 200,180 80,120 160,200 160,180
220,260 200))');
+SELECT '86', ST_Relate('POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20
140,20 20))','POLYGON((0 140,300 140,140 240,0 140))');
+SELECT '87', ST_Relate('POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20
140,20 20))','POLYGON((20 240,20 140,320 140,180 240,20 240))');
+SELECT '88', ST_Relate('POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20
140,20 20))','POLYGON((20 240,20 140,80 180,140 140,220 180,280 140,280 240,20
240))');
+SELECT '89', ST_Relate('POLYGON((120 120,180 60,20 20,20 120,120
120))','POLYGON((120 120,220 20,280 20,240 160,120 120))');
+SELECT '90', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((140 120,160 20,260 120,220 200,140 120))');
+SELECT '91', ST_Relate('POLYGON((20 140,120 40,20 40,20 140))','POLYGON((190
140,190 20,140 20,20 140,190 140))');
+SELECT '92', ST_Relate('POLYGON((120 120,180 60,20 20,20 120,120
120))','POLYGON((300 20,220 20,120 120,260 160,300 20))');
+SELECT '93', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((140 120,240 160,280 60,160 20,140 120))');
+SELECT '94', ST_Relate('POLYGON((120 120,180 60,20 20,20 120,120
120))','POLYGON((280 60,180 60,120 120,260 180,280 60))');
+SELECT '95', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((120 200,120 120,40 120,40 200,120 200))');
+SELECT '96', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((160 220,140 120,60 120,40 220,160 220))');
+SELECT '97', ST_Relate('POLYGON((140 120,160 20,20 20,20 120,140
120))','POLYGON((140 120,20 120,20 220,140 220,140 120))');
+SELECT '98', ST_Relate('POLYGON((120 120,180 60,20 20,20 120,120
120))','POLYGON((320 20,220 20,80 160,240 140,320 20))');
+SELECT '99', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((60 40,60 140,180 140,180 40,60 40))');
+SELECT '100', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,80 140,160 60,20 20))');
+SELECT '101', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((160 60,20 20,100 140,160 60))');
+SELECT '102', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 100,140 160,160 40,20 100))');
+SELECT '103', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((160 40,20 100,160 160,160 40))');
+SELECT '104', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 180,180 120,80 40,20 180))');
+SELECT '105', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((180 120,100 40,20 180,180 120))');
+SELECT '106', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,140 40,140 120,20 160,80 80,20 20))');
+SELECT '107', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,140 40,140 140,20 180,80 100,20 20))');
+SELECT '108', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((40 180,60 100,180 100,200 180,120 120,40 180))');
+SELECT '109', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 180,60 80,180 80,220 180,120 120,20 180))');
+SELECT '110', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((40 60,20 180,100 100,140 180,160 120,220 100,140 40,40 60))');
+SELECT '111', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((60 100,180 100,220 180,120 140,20 180,60 100))');
+SELECT '112', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,20 140,120 120,120 40,20 20))');
+SELECT '113', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,20 180,140 140,140 60,20 20))');
+SELECT '114', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,120 40,120 120,20 140,20 20))');
+SELECT '115', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((120 40,20 20,20 140,120 120,120 40))');
+SELECT '116', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,140 60,140 140,20 180,20 20))');
+SELECT '117', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((140 60,20 20,20 180,140 140,140 60))');
+SELECT '118', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,60 120,140 120,180 20,20 20))');
+SELECT '119', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 40,120 40,120 120,20 140,20 40))');
+SELECT '120', ST_Relate('POLYGON((20 20,20 180,220 180,220 20,20
20))','POLYGON((20 20,20 180,60 120,100 180,140 120,220 180,200 120,140 60,20
20))');
+SELECT '121', ST_Relate('POLYGON((150 150,330 150,250 70,70 70,150
150))','POLYGON((150 150,270 150,140 20,20 20,150 150))');
+SELECT '122', ST_Relate('POLYGON((150 150,270 150,330 150,250 70,190 70,70
70,150 150))','POLYGON((150 150,270 150,190 70,140 20,20 20,70 70,150 150))');
+SELECT '123', ST_Relate('POLYGON((20 20,60 50,20 40,60 70,20 60,60 90,20 90,70
110,20 130,80 130,20 150,80 160,20 170,80 180,20 200,80 200,30 240,80 220,50
260,100 220,100 260,120 220,130 260,140 220,150 280,150 190,160 280,170 190,180
280,190 190,200 280,210 190,220 280,230 190,240 260,250 230,260 260,260 220,290
270,290 220,330 260,300 210,340 240,290 180,340 210,290 170,350 170,240 150,350
150,240 140,350 130,240 120,350 120,240 110,350 110,240 100,350 100,240 90,350
90,240 80,350 80,300 70,340 60,290 60,340 40,300 50,340 20,270 60,310 20,250
60,270 20,230 60,240 20,210 60,210 20,190 70,190 20,180 90,170 20,160 90,150
20,140 90,130 20,120 90,110 20,100 90,100 20,90 60,80 20,70 40,20
20))','POLYGON((190 140,140 130,200 160,130 150,210 170,130 170,210 180,120
190,220 200,120 200,250 210,120 210,250 220,120 220,250 230,120 240,230 240,120
250,240 260,120 260,240 270,120 270,270 290,120 290,230 300,150 310,250 310,180
320,250 320,200 360,260 330,240 360,280 320,290 370,290 320,320 36
0,310 320,360 360,310 310,380 340,310 290,390 330,310 280,410 310,310 270,420
280,310 260,430 250,300 250,440 240,300 240,450 230,280 220,440 220,280 210,440
210,300 200,430 190,300 190,440 180,330 180,430 150,320 180,420 130,300 180,410
120,280 180,400 110,280 170,390 90,280 160,400 70,270 160,450 30,260 160,420
30,250 160,390 30,240 160,370 30,230 160,360 30,230 150,330 50,240 130,330
30,230 130,310 30,220 130,280 30,230 100,270 40,220 110,250 30,210 130,240
30,210 100,220 40,200 90,200 20,190 100,180 30,20 20,180 40,20 30,180 50,20
50,180 60,30 60,180 70,20 70,170 80,80 80,170 90,20 80,180 100,40 100,200
110,60 110,200 120,120 120,190 140))');
+SELECT '124', ST_Relate('POLYGON((70 150,20 160,110 160,20 180,100 200,20
200,190 210,20 210,160 220,20 220,150 230,60 240,180 250,20 260,170 260,60
270,160 270,100 310,170 280,200 260,180 230,210 260,130 330,230 250,210 290,240
250,230 210,260 300,250 230,270 300,270 240,300 340,280 250,320 330,290 250,340
350,290 240,350 360,270 190,350 340,290 200,350 330,300 190,360 320,310 190,360
300,320 200,360 280,330 200,360 260,340 200,370 260,340 180,390 290,340 170,400
260,350 170,400 250,350 160,410 240,350 150,400 170,350 140,310 170,340 140,270
180,330 140,260 170,310 140,240 170,290 140,200 190,270 140,180 190,260 140,170
190,260 130,170 180,250 130,170 170,240 120,170 160,210 120,170 150,210 110,340
130,230 110,420 140,220 100,410 130,220 90,400 120,220 80,390 110,220 70,420
110,240 70,420 100,260 70,420 90,280 70,430 80,230 60,430 60,270 50,450 40,210
50,370 40,260 40,460 30,160 40,210 60,200 110,190 60,190 120,170 50,180 130,150
30,170 130,140 20,160 120,130 20,160 150,120 20,160
170,110 20,160 190,100 20,150 190,90 20,140 180,80 20,120 140,70 20,120 150,60
20,110 150,50 20,100 140,50 30,90 130,40 30,80 120,30 30,80 130,30 40,80 140,20
40,70 140,40 90,60 130,20 90,60 140,20 130,70 150))','POLYGON((190 140,140
130,200 160,130 150,210 170,130 170,210 180,120 190,220 200,120 200,250 210,120
210,250 220,120 220,250 230,120 240,230 240,120 250,240 260,120 260,240 270,120
270,270 290,120 290,230 300,150 310,250 310,180 320,250 320,200 360,260 330,240
360,280 320,290 370,290 320,320 360,310 320,360 360,310 310,380 340,310 290,390
330,310 280,410 310,310 270,420 280,310 260,430 250,300 250,440 240,300 240,450
230,280 220,440 220,280 210,440 210,300 200,430 190,300 190,440 180,330 180,430
150,320 180,420 130,300 180,410 120,280 180,400 110,280 170,390 90,280 160,400
70,270 160,450 30,260 160,420 30,250 160,390 30,240 160,370 30,230 160,360
30,230 150,330 50,240 130,330 30,230 130,310 30,220 130,280 30,230 100,270
40,220 110,250 30,210 130,240 30,210 100,220 40,200 90
,200 20,190 100,180 30,20 20,180 40,20 30,180 50,20 50,180 60,30 60,180 70,20
70,170 80,80 80,170 90,20 80,180 100,40 100,200 110,60 110,200 120,120 120,190
140))');
+SELECT '125', ST_Relate('POLYGON((60 160,220 160,220 20,60 20,60
160))','POLYGON((60 160,20 200,260 200,220 160,140 80,60 160))');
+SELECT '126', ST_Relate('POLYGON((60 160,220 160,220 20,60 20,60
160))','POLYGON((60 160,20 200,260 200,140 80,60 160))');
+SELECT '127', ST_Relate('POLYGON((60 160,220 160,220 20,60 20,60
160))','POLYGON((20 200,140 80,260 200,20 200))');
+SELECT '128', ST_Relate('POLYGON((60 160,220 160,220 20,60 20,60
160))','POLYGON((20 200,60 160,140 80,220 160,260 200,20 200))');
+SELECT '129', ST_Relate('POLYGON((60 160,220 160,220 20,60 20,60
160))','POLYGON((20 200,60 160,140 80,260 200,20 200))');
+SELECT '130', ST_Relate('POLYGON((0 0,0 200,200 200,200 0,0 0))','POLYGON((100
100,1000000 110,10000000 100,100 100))');
+SELECT '131', ST_Relate('POLYGON((100 0,100 200,200 200,200 0,100
0))','POLYGON((100 100,1000000 110,10000000 100,100 100))');
+SELECT '132', ST_Relate('POLYGON((120 0,120 200,200 200,200 0,120
0))','POLYGON((100 100,1000000 110,10000000 100,100 100))');
+SELECT '133', ST_Relate('POLYGON((0 0,0 200,110 200,110 0,0 0))','POLYGON((100
100,1000000 110,10000000 100,100 100))');
+SELECT '134', ST_Relate('POLYGON((100 100,100 200,200 200,200 100,100
100))','POLYGON((100 100,2100 110,2100 100,100 100))');
+SELECT '135', ST_Relate('POLYGON((100 100,100 200,200 200,200 100,100
100))','POLYGON((100 100,2101 110,2101 100,100 100))');
+SELECT '136', ST_Relate('POLYGON((100 100,200 200,200 100,100
100))','POLYGON((100 100,2101 110,2101 100,100 100))');
+SELECT '137', ST_Relate('POLYGON((100 100,100 200,200 200,200 100,100
100))','POLYGON((100 100,1000000 110,1000000 100,100 100))');
+SELECT '138', ST_Relate('POLYGON((120 100,120 200,200 200,200 100,120
100))','POLYGON((100 100,500 110,500 100,100 100))');
+SELECT '139', ST_Relate('POLYGON((120 100,120 200,200 200,200 100,120
100))','POLYGON((100 100,501 110,501 100,100 100))');
+SELECT '140', ST_Relate('POLYGON((120 100,130 200,200 200,200 100,120
100))','POLYGON((100 100,501 110,501 100,100 100))');
+SELECT '141', ST_Relate('POLYGON((120 100,17 200,200 200,200 100,120
100))','POLYGON((100 100,501 110,501 100,100 100))');
+SELECT '142', ST_Relate('POLYGON((120 100,120 200,200 200,200 100,120
100))','POLYGON((100 100,1000000 110,1000000 100,100 100))');
+SELECT '143', ST_Relate('POLYGON((101 99,101 1000000,102 1000000,101
99))','POLYGON((100 100,1000000 110,1000000 100,100 100))');
+SELECT '144', ST_Relate('POLYGON((100 100,200 101,200 100,100
100))','POLYGON((100 100,2101 110,2101 100,100 100))');
+SELECT '145', ST_Relate('POLYGON((16 319,150 39,25 302,160 20,265 20,127
317,16 319))','POLYGON((10 307,22 307,153 34,22 34,10 307))');
+SELECT '146', ST_Relate('POLYGON((160 200,210 70,120 70,160
200))','POLYGON((160 200,310 20,20 20,160 200),(160 200,260 40,70 40,160
200))');
+SELECT '147', ST_Relate('POLYGON((170 120,240 100,260 50,190 70,170
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '148', ST_Relate('POLYGON((270 90,200 50,150 80,210 120,270
90))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '149', ST_Relate('POLYGON((170 120,260 100,240 60,150 80,170
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '150', ST_Relate('POLYGON((220 120,270 80,200 60,160 100,220
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '151', ST_Relate('POLYGON((260 50,180 70,180 110,260 90,260
50))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '152', ST_Relate('POLYGON((230 110,290 80,190 60,140 90,230
110))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '153', ST_Relate('POLYGON((170 120,330 120,260 50,100 50,170
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '154', ST_Relate('POLYGON((170 120,330 120,280 70,120 70,170
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '155', ST_Relate('POLYGON((170 120,300 120,250 70,120 70,170
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '156', ST_Relate('POLYGON((190 100,310 100,260 50,140 50,190
100))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '157', ST_Relate('POLYGON((280 130,360 130,270 40,190 40,280
130))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180
50,100 50,170 120))');
+SELECT '158', ST_Relate('POLYGON((220 80,180 40,80 40,170 130,270 130,230
90,300 90,250 30,280 30,390 140,150 140,40 30,230 30,280 80,220
80))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180
50,100 50,170 120))');
+SELECT '159', ST_Relate('POLYGON((260 130,360 130,280 40,170 40,260
130))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180
50,100 50,170 120))');
+SELECT '160', ST_Relate('POLYGON((240 110,340 110,290 60,190 60,240
110))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180
50,100 50,170 120))');
+SELECT '161', ST_Relate('POLYGON((250 120,350 120,280 50,180 50,250
120))','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180
50,100 50,170 120))');
+SELECT '162', ST_Relate('POLYGON((230 210,230 20,20 20,20 210,230 210),(120
180,50 50,200 50,120 180))','POLYGON((230 210,230 20,20 20,20 210,230 210),(120
180,50 50,200 50,120 180))');
+SELECT '163', ST_Relate('POLYGON((230 210,230 20,20 20,20 210,230 210),(140
40,40 40,40 170,140 40),(110 190,210 190,210 50,110 190))','POLYGON((230
210,230 20,20 20,20 210,230 210),(140 40,40 40,40 170,140 40),(110 190,210
190,210 50,110 190))');
+SELECT '164', ST_Relate('POLYGON((280 190,330 150,200 110,150 150,280
190))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '165', ST_Relate('POLYGON((80 190,220 190,140 110,0 110,80
190))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '166', ST_Relate('POLYGON((330 150,200 110,150 150,280 190,330
150))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '167', ST_Relate('POLYGON((290 190,340 150,220 120,170 170,290
190))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '168', ST_Relate('POLYGON((220 190,340 190,260 110,140 110,220
190))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '169', ST_Relate('POLYGON((140 190,220 190,100 70,20 70,140
190))','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '170', ST_Relate('POLYGON((140 220,60 140,140 60,220 140,140
220))','MULTIPOLYGON(((100 20,180 20,180 100,100 100,100 20)),((20 100,100
100,100 180,20 180,20 100)),((100 180,180 180,180 260,100 260,100 180)),((180
100,260 100,260 180,180 180,180 100)))');
+SELECT '171', ST_Relate('MULTIPOLYGON(((110 110,70 200,150 200,110 110)),((110
110,150 20,70 20,110 110)))','MULTIPOLYGON(((110 110,160 160,210 110,160 60,110
110)),((110 110,60 60,10 110,60 160,110 110)))');
+SELECT '172', ST_Relate('MULTIPOLYGON(((110 110,70 200,150 200,110 110),(110
110,100 180,120 180,110 110)),((110 110,150 20,70 20,110 110),(110 110,120
40,100 40,110 110)))','MULTIPOLYGON(((110 110,160 160,210 110,160 60,110
110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110
110),(110 110,60 90,60 130,110 110)))');
+SELECT '173', ST_Relate('MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110
110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120
40,100 40,110 110)))','MULTIPOLYGON(((110 110,160 160,210 110,160 60,110
110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110
110),(110 110,60 90,60 130,110 110)))');
+SELECT '174', ST_Relate('MULTIPOLYGON(((110 110,20 200,200 200,110 110),(110
110,100 180,120 180,110 110)),((110 110,200 20,20 20,110 110),(110 110,120
40,100 40,110 110)))','MULTIPOLYGON(((110 110,160 160,210 110,160 60,110
110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110
110),(110 110,60 90,60 130,110 110)))');
+SELECT '175', ST_Relate('MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110
110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120
40,100 40,110 110)))','MULTIPOLYGON(((110 110,160 160,210 110,160 60,110
110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110
110),(110 110,60 90,60 130,110 110)))');
+SELECT '176', ST_Relate('MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110
110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120
40,100 40,110 110)))','MULTIPOLYGON(((110 110,70 200,210 110,70 20,110
110),(110 110,110 140,150 110,110 80,110 110)),((110 110,60 60,10 110,60
160,110 110),(110 110,60 90,60 130,110 110)))');
+SELECT '177', ST_Relate('POLYGON((100 60,140 100,100 140,60 100,100
60))','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)))');
+SELECT '178', ST_Relate('LINESTRING(150 150,40 230)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '179', ST_Relate('LINESTRING(40 40,50 130,130 130)','POLYGON((150
150,410 150,280 20,20 20,150 150))');
+SELECT '180', ST_Relate('LINESTRING(40 230,150 150)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '181', ST_Relate('LINESTRING(210 150,330 150)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '182', ST_Relate('LINESTRING(200 150,310 150,360 220)','POLYGON((150
150,410 150,280 20,20 20,150 150))');
+SELECT '183', ST_Relate('LINESTRING(180 150,250 150,230 250,370 250,410
150)','POLYGON((150 150,410 150,280 20,20 20,150 150))');
+SELECT '184', ST_Relate('LINESTRING(210 210,220 150,320 150,370
210)','POLYGON((150 150,410 150,280 20,20 20,150 150))');
+SELECT '185', ST_Relate('LINESTRING(20 60,150 60)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '186', ST_Relate('LINESTRING(60 90,310 180)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '187', ST_Relate('LINESTRING(90 210,210 90)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '188', ST_Relate('LINESTRING(290 10,130 170)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '189', ST_Relate('LINESTRING(30 100,100 100,180 100)','POLYGON((150
150,410 150,280 20,20 20,150 150))');
+SELECT '190', ST_Relate('LINESTRING(20 100,100 100,360 100,410
100)','POLYGON((150 150,410 150,280 20,20 20,150 150))');
+SELECT '191', ST_Relate('LINESTRING(90 210,150 150,210 90)','POLYGON((150
150,410 150,280 20,20 20,150 150))');
+SELECT '192', ST_Relate('LINESTRING(180 90,280 120)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '193', ST_Relate('LINESTRING(70 70,80 20)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '194', ST_Relate('LINESTRING(130 20,150 60)','POLYGON((150 150,410
150,280 20,20 20,150 150))');
+SELECT '195', ST_Relate('LINESTRING(70 70,80 20,140 20,150 60)','POLYGON((150
150,410 150,280 20,20 20,150 150))');
+SELECT '196', ST_Relate('LINESTRING(170 50,170 20,240 20,260
60)','POLYGON((150 150,410 150,280 20,20 20,150 150))');
+SELECT '197', ST_Relate('LINESTRING(50 100,140 190,280 190)','POLYGON((150
150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))');
+SELECT '198', ST_Relate('LINESTRING(140 60,180 100,290 100)','POLYGON((150
150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))');
+SELECT '199', ST_Relate('LINESTRING(170 120,210 80,270 80)','POLYGON((150
150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))');
+SELECT '200', ST_Relate('LINESTRING(170 120,260 50)','POLYGON((150 150,410
150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))');
+SELECT '201', ST_Relate('LINESTRING(190 90,190 270)','POLYGON((190 190,360
20,20 20,190 190),(190 190,280 50,100 50,190 190))');
+SELECT '202', ST_Relate('LINESTRING(60 160,150 70)','POLYGON((190 190,360
20,20 20,190 190),(110 110,250 100,140 30,110 110))');
+SELECT '203', ST_Relate('LINESTRING(60 160,150 70)','POLYGON((190 190,20
20,360 20,190 190),(250 100,110 110,140 30,250 100))');
+SELECT '204', ST_Relate('LINESTRING(60 160,150 70)','POLYGON((190 190,20
20,360 20,190 190),(250 100,110 110,140 30,250 100))');
+SELECT '205', ST_Relate('LINESTRING(190 90,190 190,190 270)','POLYGON((190
190,360 20,20 20,190 190),(190 190,280 50,100 50,190 190))');
+SELECT '206', ST_Relate('LINESTRING(60 160,110 110,150 70)','POLYGON((190
190,360 20,20 20,190 190),(110 110,250 100,140 30,110 110))');
+SELECT '207', ST_Relate('LINESTRING(60 160,110 110,150 70)','POLYGON((190
190,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))');
+SELECT '208', ST_Relate('LINESTRING(60 160,110 110,150 70)','POLYGON((190
190,110 110,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))');
+SELECT '209', ST_Relate('LINESTRING(130 110,180 110,190 60)','POLYGON((20
200,240 200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200
40,200 180,130 110))');
+SELECT '210', ST_Relate('LINESTRING(80 110,180 110)','POLYGON((20 200,240
200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200 40,200
180,130 110))');
+SELECT '211', ST_Relate('LINESTRING(80 110,180 110)','POLYGON((20 200,20
20,240 20,240 200,20 200),(60 180,130 110,60 40,60 180),(130 110,200 40,200
180,130 110))');
+SELECT '212', ST_Relate('LINESTRING(80 110,170 110)','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))');
+SELECT '213', ST_Relate('LINESTRING(80 110,130 110,170 110)','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))');
+SELECT '214', ST_Relate('LINESTRING(80 110,130 110,180 110)','POLYGON((20
200,240 200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200
40,200 180,130 110))');
+SELECT '215', ST_Relate('LINESTRING(80 110,130 110,180 110)','POLYGON((20
200,20 20,240 20,240 200,20 200),(60 180,130 110,60 40,60 180),(130 110,200
40,200 180,130 110))');
+SELECT '216', ST_Relate('LINESTRING(80 110,130 110,170 110)','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))');
+SELECT '217', ST_Relate('LINESTRING(160 70,320 230)','MULTIPOLYGON(((140
110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300
270)))');
+SELECT '218', ST_Relate('LINESTRING(160 70,200 110,280 190,320
230)','MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420
270,340 190,220 190,300 270)))');
+SELECT '219', ST_Relate('LINESTRING(70 50,70 150)','MULTIPOLYGON(((0 0,0
100,140 100,140 0,0 0)),((20 170,70 100,130 170,20 170)))');
+SELECT '220', ST_Relate('LINESTRING(110 110,20 200,200 200,110
110)','POLYGON((20 20,200 20,110 110,20 20))');
+SELECT '221', ST_Relate('LINESTRING(150 70,160 110,200 60,150
70)','POLYGON((20 20,200 20,110 110,20 20))');
+SELECT '222', ST_Relate('LINESTRING(80 60,120 40,120 70,80 60)','POLYGON((110
110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))');
+SELECT '223', ST_Relate('LINESTRING(20 20,200 20,110 110,20 20)','POLYGON((20
20,200 20,110 110,20 20))');
+SELECT '224', ST_Relate('LINESTRING(110 90,170 30,50 30,110 90)','POLYGON((110
110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))');
+SELECT '225', ST_Relate('LINESTRING(110 110,170 50,170 110,110
110)','POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))');
+SELECT '226', ST_Relate('LINESTRING(110 90,70 50,130 50,110 90)','POLYGON((110
110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))');
+SELECT '227', ST_Relate('LINESTRING(110 60,20 150,200 150,110
60)','POLYGON((20 20,200 20,110 110,20 20))');
+SELECT '228', ST_Relate('LINESTRING(110 130,110 70,200 100,110
130)','POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))');
+SELECT '229', ST_Relate('LINESTRING(110 90,160 40,60 40,110 90)','POLYGON((20
20,200 20,110 110,20 20))');
+SELECT '230', ST_Relate('LINESTRING(110 100,40 30,180 30,110
100)','POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))');
+SELECT '231', ST_Relate('LINESTRING(110 110,180 30,40 30,110
110)','POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))');
+SELECT '232', ST_Relate('LINESTRING(110 90,180 30,40 30,110 90)','POLYGON((110
110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))');
+SELECT '233', ST_Relate('LINESTRING(110 90,50 30,180 30,110 90)','POLYGON((110
110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))');
+SELECT '234', ST_Relate('LINESTRING(110 110,200 200,200 110,110
200)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '235', ST_Relate('LINESTRING(110 110,200 200,110 110,20 200,20 110,200
110)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '236', ST_Relate('LINESTRING(110 110,20 110,200 110,50 110,110
170)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '237', ST_Relate('LINESTRING(110 110,20 200,110 200,110 110,200
200)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '238', ST_Relate('LINESTRING(110 110,170 50,20 200,20 110,200
110)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '239', ST_Relate('LINESTRING(110 110,180 40,110 40,110
180)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '240', ST_Relate('LINESTRING(110 60,50 30,170 30,90 70)','POLYGON((110
110,200 20,20 20,110 110))');
+SELECT '241', ST_Relate('LINESTRING(110 110,180 40,110 40,110 110,70
40)','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '242', ST_Relate('LINESTRING(230 70,170 120,190 60,140 60,170 120,270
90)','POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260
50,100 50,170 120))');
+SELECT '243', ST_Relate('MULTILINESTRING((20 110,200 110),(200 200,110 110,20
210,110 110))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '244', ST_Relate('MULTILINESTRING((20 110,200 110),(60 180,60 110,160
110,110 110))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '245', ST_Relate('MULTILINESTRING((20 110,200 110),(200 200,110 110,20
200,110 200,110 110))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '246', ST_Relate('MULTILINESTRING((20 110,200 110),(110 50,110 170,110
70,110 150,200 150))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '247', ST_Relate('MULTILINESTRING((20 110,200 110),(50 110,170 110,110
170,110 50,110 170,110 50))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '248', ST_Relate('MULTILINESTRING((20 110,200 110),(110 60,110 160,200
160))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '249', ST_Relate('MULTILINESTRING((20 110,200 110),(110 60,110 160,200
160))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '250', ST_Relate('MULTILINESTRING((110 100,40 30,180 30),(170 30,110
90,50 30))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '251', ST_Relate('MULTILINESTRING((110 110,60 40,70 20,150 20,170
40),(180 30,40 30,110 80))','POLYGON((110 110,200 20,20 20,110 110))');
+SELECT '252', ST_Relate('MULTILINESTRING((20 110,200 110,200 160),(110 110,200
110,200 70,20 150))','MULTIPOLYGON(((110 110,20 20,200 20,110 110)),((110
110,20 200,200 200,110 110)))');
+SELECT '253', ST_Relate('MULTILINESTRING((20 160,70 110,150 110,200 160),(110
110,20 110,50 80,70 110,200 110))','MULTIPOLYGON(((110 110,20 20,200 20,110
110)),((110 110,20 200,200 200,110 110)))');
+SELECT '254', ST_Relate('MULTILINESTRING((20 110,200 110),(110 110,20 170,20
130,200 90))','MULTIPOLYGON(((110 110,20 20,200 20,110 110)),((110 110,20
200,200 200,110 110)))');
+SELECT '255', ST_Relate('LINESTRING(0 0,0 50,50 50,50 0,0
0)','MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))');
+SELECT '256', ST_Relate('LINESTRING(40 180,140 180)','MULTIPOLYGON(((20
320,180 320,180 180,20 180,20 320)),((20 180,20 80,180 80,180 180,20 180)))');
+SELECT '257', ST_Relate('LINESTRING(40 180,140 180)','MULTIPOLYGON(((20
320,180 320,180 180,20 180,20 320)),((60 180,60 80,180 80,180 180,60 180)))');
+SELECT '258', ST_Relate('LINESTRING(0 0,60 0,60 60,60 0,120
0)','MULTILINESTRING((0 0,60 0),(60 0,120 0),(60 0,60 60))');
+SELECT '259', ST_Relate('LINESTRING(40 40,120 120)','LINESTRING(40 40,60
120)');
+SELECT '260', ST_Relate('LINESTRING(40 40,120 120)','LINESTRING(60 240,40
40)');
+SELECT '261', ST_Relate('LINESTRING(40 40,180 180)','LINESTRING(120 120,20
200)');
+SELECT '262', ST_Relate('LINESTRING(40 40,120 120)','LINESTRING(60 240,120
120)');
+SELECT '263', ST_Relate('LINESTRING(40 40,180 180)','LINESTRING(20 180,140
140)');
+SELECT '264', ST_Relate('LINESTRING(40 40,120 120)','LINESTRING(40 120,120
40)');
+SELECT '265', ST_Relate('LINESTRING(40 40,100 100)','LINESTRING(40 40,100
100)');
+SELECT '266', ST_Relate('LINESTRING(40 40,100 100)','LINESTRING(100 100,40
40)');
+SELECT '267', ST_Relate('LINESTRING(40 40,120 120)','LINESTRING(40 120,120
160)');
+SELECT '268', ST_Relate('LINESTRING(20 20,180 180)','LINESTRING(20 20,180
180)');
+SELECT '269', ST_Relate('LINESTRING(20 20,180 180)','LINESTRING(20 20,110
110)');
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
