Changeset: 18d5f384d738 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=18d5f384d738 Modified Files: geom/sql/functions/Tests/ST_MakeBox2D.test Branch: mtest Log Message:
Same issue diffs (84 lines): diff --git a/geom/sql/functions/Tests/ST_MakeBox2D.test b/geom/sql/functions/Tests/ST_MakeBox2D.test --- a/geom/sql/functions/Tests/ST_MakeBox2D.test +++ b/geom/sql/functions/Tests/ST_MakeBox2D.test @@ -1,5 +1,7 @@ -statement error +query T nosort select ST_MakeBox2D(ST_Point(-989502.1875, 528439.5625), ST_Point(-987121.375 ,529933.1875)) +---- +BOX (-989502.1875 528439.5625, -987121.375 529933.1875) query T rowsort select ST_MakeBox2D(ST_Point(-989502.1875, 528439.5625), null) @@ -15,11 +17,69 @@ CREATE TABLE t(geom GEOMETRY(POINT)) statement ok INSERT INTO t VALUES(ST_Point(10, 20)), (ST_Point(30, 40)), (ST_Point(50, 60)), (ST_Point(70, 80)) -statement error +query TT nosort SELECT geom AS "P", ST_MakeBox2D(geom, ST_Point(90, 90)) AS "BOX2D" FROM t +---- +POINT (10 20) +BOX (10 20, 90 90) +POINT (30 40) +BOX (30 40, 90 90) +POINT (50 60) +BOX (50 60, 90 90) +POINT (70 80) +BOX (70 80, 90 90) -statement error +query TTT nosort SELECT g1.geom AS "P1", g2.geom AS "P2", ST_MakeBox2D(g1.geom, g2.geom) AS "BOX2D" FROM t g1, t g2 +---- +POINT (10 20) +POINT (10 20) +BOX (10 20, 10 20) +POINT (10 20) +POINT (30 40) +BOX (10 20, 30 40) +POINT (10 20) +POINT (50 60) +BOX (10 20, 50 60) +POINT (10 20) +POINT (70 80) +BOX (10 20, 70 80) +POINT (30 40) +POINT (10 20) +BOX (10 20, 30 40) +POINT (30 40) +POINT (30 40) +BOX (30 40, 30 40) +POINT (30 40) +POINT (50 60) +BOX (30 40, 50 60) +POINT (30 40) +POINT (70 80) +BOX (30 40, 70 80) +POINT (50 60) +POINT (10 20) +BOX (10 20, 50 60) +POINT (50 60) +POINT (30 40) +BOX (30 40, 50 60) +POINT (50 60) +POINT (50 60) +BOX (50 60, 50 60) +POINT (50 60) +POINT (70 80) +BOX (50 60, 70 80) +POINT (70 80) +POINT (10 20) +BOX (10 20, 70 80) +POINT (70 80) +POINT (30 40) +BOX (30 40, 70 80) +POINT (70 80) +POINT (50 60) +BOX (50 60, 70 80) +POINT (70 80) +POINT (70 80) +BOX (70 80, 70 80) statement ok DROP TABLE t _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
