Changeset: d2f7441ee7d0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d2f7441ee7d0
Modified Files:
geom/sql/Tests/geometryType.sql
geom/sql/Tests/geometryType.stable.out
Branch: geo
Log Message:
more checks in geometryType mTest
diffs (148 lines):
diff --git a/geom/sql/Tests/geometryType.sql b/geom/sql/Tests/geometryType.sql
--- a/geom/sql/Tests/geometryType.sql
+++ b/geom/sql/Tests/geometryType.sql
@@ -56,5 +56,38 @@ select st_geometrytype(st_geomfromtext('
select st_geometrytype(st_geomfromtext('multilinestring((10 10, 20 20, 30 30),
(40 40, 50 50, 60 60))'));
select st_geometrytype(st_geomfromtext('multipolygon(((10 10, 20 20, 30 30, 10
10),(100 100, 200 200, 300 300, 100 100)))'));
+create table points_tbl(g geometry(point));
+insert into points_tbl values (st_pointfromtext('point(10 10)'));
+select geometrytype(g) from points_tbl;
+select st_geometrytype(g) from points_tbl;
+drop table points_tbl;
+create table lines_tbl(g geometry(linestring));
+insert into lines_tbl values (st_linefromtext('linestring(10 10, 20 20, 30
30)'));
+select geometrytype(g) from lines_tbl;
+select st_geometrytype(g) from lines_tbl;
+drop table lines_tbl;
+create table polygons_tbl(g geometry(polygon));
+insert into polygons_tbl values (st_polygonfromtext('polygon((10 10, 20 20, 30
30, 10 10))'));
+select geometrytype(g) from polygons_tbl;
+select st_geometrytype(g) from polygons_tbl;
+drop table polygons_tbl;
+
+create table points_tbl(g geometry(pointz));
+insert into points_tbl values (st_pointfromtext('point(10 10 10)'));
+select geometrytype(g) from points_tbl;
+select st_geometrytype(g) from points_tbl;
+drop table points_tbl;
+
+create table lines_tbl(g geometry(linestringz));
+insert into lines_tbl values (st_linefromtext('linestring(10 10 10, 20 20 20,
30 30 30)'));
+select geometrytype(g) from lines_tbl;
+select st_geometrytype(g) from lines_tbl;
+drop table lines_tbl;
+
+create table polygons_tbl(g geometry(polygonz));
+insert into polygons_tbl values (st_polygonfromtext('polygon((10 10 10, 20 20
20, 30 30 30, 10 10 10))'));
+select geometrytype(g) from polygons_tbl;
+select st_geometrytype(g) from polygons_tbl;
+drop table polygons_tbl;
diff --git a/geom/sql/Tests/geometryType.stable.out
b/geom/sql/Tests/geometryType.stable.out
--- a/geom/sql/Tests/geometryType.stable.out
+++ b/geom/sql/Tests/geometryType.stable.out
@@ -376,6 +376,102 @@ Ready.
% clob # type
% 15 # length
[ "ST_MultiPolygon" ]
+#create table points_tbl(g geometry(point));
+#insert into points_tbl values (st_pointfromtext('point(10 10)'));
+[ 1 ]
+#select geometrytype(g) from points_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 5 # length
+[ "POINT" ]
+#select st_geometrytype(g) from points_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 8 # length
+[ "ST_Point" ]
+#drop table points_tbl;
+#create table lines_tbl(g geometry(linestring));
+#insert into lines_tbl values (st_linefromtext('linestring(10 10, 20 20, 30
30)'));
+[ 1 ]
+#select geometrytype(g) from lines_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 10 # length
+[ "LINESTRING" ]
+#select st_geometrytype(g) from lines_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 13 # length
+[ "ST_Linestring" ]
+#drop table lines_tbl;
+#create table polygons_tbl(g geometry(polygon));
+#insert into polygons_tbl values (st_polygonfromtext('polygon((10 10, 20 20,
30 30, 10 10))'));
+[ 1 ]
+#select geometrytype(g) from polygons_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 7 # length
+[ "POLYGON" ]
+#select st_geometrytype(g) from polygons_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 10 # length
+[ "ST_Polygon" ]
+#drop table polygons_tbl;
+#create table points_tbl(g geometry(pointz));
+#insert into points_tbl values (st_pointfromtext('point(10 10 10)'));
+[ 1 ]
+#select geometrytype(g) from points_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 5 # length
+[ "POINT" ]
+#select st_geometrytype(g) from points_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 8 # length
+[ "ST_Point" ]
+#drop table points_tbl;
+#create table lines_tbl(g geometry(linestringz));
+#insert into lines_tbl values (st_linefromtext('linestring(10 10 10, 20 20 20,
30 30 30)'));
+[ 1 ]
+#select geometrytype(g) from lines_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 10 # length
+[ "LINESTRING" ]
+#select st_geometrytype(g) from lines_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 13 # length
+[ "ST_Linestring" ]
+#drop table lines_tbl;
+#create table polygons_tbl(g geometry(polygonz));
+#insert into polygons_tbl values (st_polygonfromtext('polygon((10 10 10, 20 20
20, 30 30 30, 10 10 10))'));
+[ 1 ]
+#select geometrytype(g) from polygons_tbl;
+% sys.L # table_name
+% geometrytype_g # name
+% clob # type
+% 7 # length
+[ "POLYGON" ]
+#select st_geometrytype(g) from polygons_tbl;
+% sys.L # table_name
+% st_geometrytype_g # name
+% clob # type
+% 10 # length
+[ "ST_Polygon" ]
+#drop table polygons_tbl;
# 16:36:27 >
# 16:36:27 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
