Changeset: f3ad13ee0c6d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f3ad13ee0c6d Modified Files: geom/sql/Tests/All geom/sql/Tests/T13.sql geom/sql/Tests/T13.stable.out geom/sql/Tests/T14.sql geom/sql/Tests/T14.stable.out Branch: default Log Message:
Deduced a syntactically correct query from the incorrect T13 and T14. It now also produces the correct answer (although the polygon is traversed in a different order when I try it). diffs (61 lines): diff --git a/geom/sql/Tests/All b/geom/sql/Tests/All --- a/geom/sql/Tests/All +++ b/geom/sql/Tests/All @@ -30,8 +30,8 @@ T8 T10 T11 T12 -# T13 !syntax/parse error (incorrect query in document) -# T14 !syntax/parse error (incorrect query in document) +T13 +T14 T15 T16 # T17 no such unary operator 'startpoint(linestring)' diff --git a/geom/sql/Tests/T13.sql b/geom/sql/Tests/T13.sql --- a/geom/sql/Tests/T13.sql +++ b/geom/sql/Tests/T13.sql @@ -1,2 +1,2 @@ -- Conformance Item T13 -SELECT AsText(Boundary((boundary),101) FROM named_places WHERE name = 'Goose Island'; +SELECT AsText(Boundary(boundary)) FROM named_places WHERE name = 'Goose Island'; diff --git a/geom/sql/Tests/T13.stable.out b/geom/sql/Tests/T13.stable.out --- a/geom/sql/Tests/T13.stable.out +++ b/geom/sql/Tests/T13.stable.out @@ -27,10 +27,10 @@ Ready. #SELECT AsText(Boundary((boundary),101) FROM named_places WHERE name = 'Goose Island'; % sys.L # table_name -% astext_boundary # name +% boundary_boundary # name % clob # type -% 220 # length -[ "\"LINESTRING ((67.0000000000000000 13.0000000000000000, 67.0000000000000000 18.0000000000000000, 59.0000000000000000 18.0000000000000000, 59.0000000000000000 13.0000000000000000, 67.0000000000000000 13.0000000000000000))\"" ] +% 218 # length +[ "\"LINESTRING (67.0000000000000000 13.0000000000000000, 67.0000000000000000 18.0000000000000000, 59.0000000000000000 18.0000000000000000, 59.0000000000000000 13.0000000000000000, 67.0000000000000000 13.0000000000000000)\"" ] # 07:38:48 > # 07:38:48 > "Done." diff --git a/geom/sql/Tests/T14.sql b/geom/sql/Tests/T14.sql --- a/geom/sql/Tests/T14.sql +++ b/geom/sql/Tests/T14.sql @@ -1,2 +1,2 @@ -- Conformance Item T14 -SELECT AsText(Envelope((boundary),101) FROM named_places WHERE name = 'Goose Island'; +SELECT AsText(Envelope(boundary)) FROM named_places WHERE name = 'Goose Island'; diff --git a/geom/sql/Tests/T14.stable.out b/geom/sql/Tests/T14.stable.out --- a/geom/sql/Tests/T14.stable.out +++ b/geom/sql/Tests/T14.stable.out @@ -27,10 +27,10 @@ Ready. #SELECT AsText(Envelope((boundary),101) FROM named_places WHERE name = 'Goose Island'; % sys.L # table_name -% astext_boundary # name +% envelope_boundary # name % clob # type % 217 # length -[ "\"POLYGON ((67.0000000000000000 13.0000000000000000, 67.0000000000000000 18.0000000000000000, 59.0000000000000000 18.0000000000000000, 59.0000000000000000 13.0000000000000000, 67.0000000000000000 13.0000000000000000))\"" ] +[ "\"POLYGON ((59.0000000000000000 13.0000000000000000, 67.0000000000000000 13.0000000000000000, 67.0000000000000000 18.0000000000000000, 59.0000000000000000 18.0000000000000000, 59.0000000000000000 13.0000000000000000))\"" ] # 07:38:48 > # 07:38:48 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
