Changeset: f098c9b6af60 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f098c9b6af60 Added Files: geom/sql/Tests/grid.modules geom/sql/Tests/grid.sql Modified Files: geom/sql/Tests/All Branch: grid Log Message:
Added some tests diffs (36 lines): diff --git a/geom/sql/Tests/All b/geom/sql/Tests/All --- a/geom/sql/Tests/All +++ b/geom/sql/Tests/All @@ -4,3 +4,4 @@ #HAVE_GEOM?dwithin #HAVE_GEOM?nPoints #HAVE_GEOM?dumpPoints +grid diff --git a/geom/sql/Tests/grid.modules b/geom/sql/Tests/grid.modules new file mode 100644 --- /dev/null +++ b/geom/sql/Tests/grid.modules @@ -0,0 +1,2 @@ +geom +grid diff --git a/geom/sql/Tests/grid.sql b/geom/sql/Tests/grid.sql new file mode 100644 --- /dev/null +++ b/geom/sql/Tests/grid.sql @@ -0,0 +1,16 @@ +CREATE TABLE points1(x BIGINT, y BIGINT); +CREATE TABLE points2(x BIGINT, y BIGINT); + +INSERT INTO points1 VALUES (100, 100), (150, 100), (100, 150), (150,150); +INSERT INTO points2 VALUES (99, 101), (149, 149), (101, 180), (149,151); + +-- selection +SELECT * FROM points1 p1 WHERE [p1.x, p1.y] distance [ 99, 99, 5]; +SELECT * FROM points1 p1 WHERE [p1.x, p1.y] distance [125,150,30]; +SELECT * FROM points2 p2 WHERE [p2.x, p2.y] distance [150,150, 5]; + +-- join +--SELECT * FROM points1 p1, points2 p2 WHERE [p1.x, p1.y] distance [p2.x, p2.x, 5] ORDER BY p1.x, p1.y; + +DROP TABLE points1; +DROP TABLE points2; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
