Changeset: 6b54a8f46413 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6b54a8f46413
Modified Files:
sql/test/pg_regress/Tests/polygon.sql
sql/test/pg_regress/Tests/polygon.stable.err
sql/test/pg_regress/Tests/polygon.stable.out
Branch: geo
Log Message:
fixed sql/test/pg_regress/Tests/polygon
diffs (truncated from 559 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/polygon.sql
b/sql/test/pg_regress/Tests/polygon.sql
--- a/sql/test/pg_regress/Tests/polygon.sql
+++ b/sql/test/pg_regress/Tests/polygon.sql
@@ -14,105 +14,106 @@
-- 0 1 2 3 4
--
-CREATE TABLE POLYGON_TBL(f1 polygon);
+CREATE TABLE POLYGON_TBL(f1 GEOMETRY(POLYGON));
--- converted PostgreSQL '(2.0,0.0),(2.0,4.0),(0.0,0.0)' into MonetDB
'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))'
+-- converted PostgreSQL '(2.0,0.0),(2.0,4.0),(0.0,0.0)' into MonetDB
'POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))'
--INSERT INTO POLYGON_TBL(f1) VALUES ('(2.0,0.0),(2.0,4.0),(0.0,0.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))');
--- converted PostgreSQL '(3.0,1.0),(3.0,3.0),(1.0,0.0)' into MonetDB
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
+-- converted PostgreSQL '(3.0,1.0),(3.0,3.0),(1.0,0.0)' into MonetDB
'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'
--INSERT INTO POLYGON_TBL(f1) VALUES ('(3.0,1.0),(3.0,3.0),(1.0,0.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0
1.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0
1.0))');
-SELECT cast('polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' as polygon);
-SELECT polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+SELECT cast('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' as geometry);
+--SELECT polygon 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- degenerate polygons
--INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0,0.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 0.0, 0.0 0.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 0.0, 0.0 0.0))');
--INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0,1.0),(0.0,1.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 1.0, 1.0 1.0, 0.0 1.0))');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 1.0, 0.0 1.0, 0.0 1.0, 0.0
1.0))');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 2.0, 0.0 1.0, 0.0 1.0, 0.0
1.0, 0.0 2.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 1.0, 1.0 1.0, 0.0 1.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 1.0, 0.0 1.0, 0.0 1.0, 0.0
1.0))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 2.0, 0.0 1.0, 0.0 1.0, 0.0
1.0, 0.0 2.0))');
-- bad polygon input strings
-INSERT INTO POLYGON_TBL(f1) VALUES ('0.0');
+--INSERT INTO POLYGON_TBL(f1) VALUES ('0.0'); Expected ERROR =
!ParseException: Unknown type: '(' Instead it puts nil and then causes problems
INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0 0.0');
INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2)');
INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2,3');
INSERT INTO POLYGON_TBL(f1) VALUES ('asdf');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon(0.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 0.0)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0,1,2))');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0 1, 2 3)');
-INSERT INTO POLYGON_TBL(f1) VALUES ('polygon(asdf)');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON(0.0)');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 0.0)');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0,1,2))');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0 1, 2 3)');
+INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON(asdf)');
SELECT '' AS four, POLYGON_TBL.* FROM POLYGON_TBL;
CREATE VIEW POLYGON_TBL_VW AS SELECT f1, cast(f1 as varchar(244)) as txt FROM
POLYGON_TBL;
SELECT * FROM POLYGON_TBL_VW;
--- overlap
+-- intersect
SELECT '' AS three, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 && '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 && 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 && 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+--overlap
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
- WHERE overlaps(p.f1, 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
+ WHERE st_overlaps(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
-- left overlap
SELECT '' AS four, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 &< '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 &< 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 &< 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- right overlap
SELECT '' AS two, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 &> '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 &> 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 &> 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- left of
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 << '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 << 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 << 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- right of
SELECT '' AS zero, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 >> '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 >> 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 >> 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- contained
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 @ polygon '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 @ 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 @ 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-- same
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 ~= polygon '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 ~= 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 ~= 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
- WHERE equals(p.f1, 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
+ WHERE st_equals(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
-- contains
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 ~ polygon '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 ~ 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ WHERE p.f1 ~ 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
- WHERE contains(p.f1, 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
+ WHERE st_contains(p.f1, 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))');
--
-- polygon logic
@@ -129,45 +130,45 @@ SELECT '' AS one, p.*
--
-- left of
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' << polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "false";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' << polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "false";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') <<
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-- left overlap
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' &< polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "true";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' &< polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "true";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') &<
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "true";
-- right overlap
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' &> polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "true";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' &> polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "true";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') &>
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "true";
-- right of
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' >> polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "false";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' >> polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "false";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') >>
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-- contained in
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' @ polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "false";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' @ polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "false";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') @
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-- contains
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' ~ polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "false";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' ~ polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "false";
-SELECT Contains(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') ~
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
+SELECT ST_Contains(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"false";
-- same
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' ~= polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "false";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' ~= polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "false";
-SELECT Equals(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') ~=
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
+SELECT ST_Equals(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))'),
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS "false";
-- overlap
--SELECT polygon '(2.0,0.0),(2.0,4.0),(0.0,0.0)' && polygon
'(3.0,1.0),(3.0,3.0),(1.0,0.0)' AS "true";
-SELECT polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))' && polygon
'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))' AS "true";
-SELECT Overlaps(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "true";
+SELECT ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))') &&
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "true";
+SELECT ST_Overlaps(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"true";
-- test some more functions
-SELECT Crosses(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-SELECT Disjoint(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-SELECT Distance(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "0";
-SELECT Intersects(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-SELECT Touches(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
-SELECT Within(polygon 'polygon((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))',
polygon 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))') AS "false";
+SELECT ST_Crosses(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"false";
+SELECT ST_Disjoint(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"false";
+SELECT ST_Distance(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS "0";
+SELECT ST_Intersects(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"true";
+SELECT ST_Touches(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0
0.0))'), ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS
"false";
+SELECT ST_Within(ST_WKTToSQL('POLYGON((2.0 0.0, 2.0 4.0, 0.0 0.0, 2.0 0.0))'),
ST_WKTToSQL('POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))')) AS "false";
DROP VIEW POLYGON_TBL_VW;
diff --git a/sql/test/pg_regress/Tests/polygon.stable.err
b/sql/test/pg_regress/Tests/polygon.stable.err
--- a/sql/test/pg_regress/Tests/polygon.stable.err
+++ b/sql/test/pg_regress/Tests/polygon.stable.err
@@ -29,130 +29,57 @@ stderr of test 'polygon` in directory 's
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 0.0, 0.0 0.0))');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 0.0, 0.0 0.0))');
ERROR = !IllegalArgumentException: Invalid number of points in LinearRing
found 2 - must be 0 or >= 4
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 1.0, 1.0 1.0, 0.0
1.0))');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 1.0, 1.0 1.0, 0.0
1.0))');
ERROR = !IllegalArgumentException: Invalid number of points in LinearRing
found 3 - must be 0 or >= 4
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('0.0');
-ERROR = !ParseException: Expected word but encountered number: '0'
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0 0.0');
ERROR = !ParseException: Unknown type: '('
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2)');
ERROR = !ParseException: Unknown type: '('
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2,3');
ERROR = !ParseException: Unknown type: '('
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('asdf');
ERROR = !ParseException: Unknown type: 'ASDF'
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon(0.0)');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON(0.0)');
ERROR = !ParseException: Expected word but encountered number: '0'
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0.0 0.0)');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 0.0)');
ERROR = !IllegalArgumentException: point array must contain 0 or >1 elements
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0,1,2))');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0,1,2))');
ERROR = !ParseException: Expected number but encountered ','
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon((0 1, 2 3)');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0 1, 2 3)');
ERROR = !IllegalArgumentException: Points of LinearRing do not form a closed
linestring
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('polygon(asdf)');
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
+QUERY = INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON(asdf)');
ERROR = !ParseException: Expected 'Z', 'M', 'ZM', 'EMPTY' or '(' but
encountered : 'ASDF'
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = SELECT '' AS three, p.*
- FROM POLYGON_TBL_VW p
- -- WHERE p.f1 && '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 && 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-ERROR = !syntax error, unexpected '&' in: "select '' as three, p.*
- ! from polygon_tbl_vw p
- !-- WHERE p.f1 && '(3.0,1.0),("
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = SELECT '' AS four, p.*
- FROM POLYGON_TBL_VW p
- -- WHERE p.f1 &< '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 &< 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-ERROR = !syntax error, unexpected COMPARISON in: "select '' as four, p.*
- ! from polygon_tbl_vw p
- !-- WHERE p.f1 &< '(3.0,1.0),("
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
-QUERY = SELECT '' AS two, p.*
- FROM POLYGON_TBL_VW p
- -- WHERE p.f1 &> '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 &> 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-ERROR = !syntax error, unexpected COMPARISON in: "select '' as two, p.*
- ! from polygon_tbl_vw p
- !-- WHERE p.f1 &> '(3.0,1.0),(3"
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = SELECT '' AS one, p.*
FROM POLYGON_TBL_VW p
-- WHERE p.f1 << '(3.0,1.0),(3.0,3.0),(1.0,0.0)';
- WHERE p.f1 << 'polygon((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
-ERROR = !SELECT: no such binary operator 'left_shift(polygon,char)'
-MAPI = (monetdb) /var/tmp/mtest-19968/.s.monetdb.34183
+ WHERE p.f1 << 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))';
+ERROR = !SELECT: no such binary operator 'left_shift(geometry,char)'
+MAPI = (monetdb) /var/tmp/mtest-3190/.s.monetdb.34607
QUERY = SELECT '' AS zero, p.*
FROM POLYGON_TBL_VW p
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
