Statistics about stdout of test 'ST_IsSimple` in directory 'geom/sql/functions`:
         42 lines,       217 words,       833 chars   in lines not matching '^$|^(\| |)#|^=`
=        42 lines,       217 words,       833 chars   in lines not matching '^$|^(\| |)#`
#        92 lines,       484 words,      2952 chars   in all lines

stdout of test 'ST_IsSimple` in directory 'geom/sql/functions` itself:


# 14:37:11 >  
# 14:37:11 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=38572" "--set" "mapi_usock=/var/tmp/mtest-4305/.s.monetdb.38572" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_functions" "--set" "mal_listing=0"
# 14:37:11 >  

# MonetDB 5 server v11.20.0
# This is an unreleased version
# Serving database 'mTests_geom_sql_Tests_functions', using 8 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 15.356 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://sibuyan.da.cwi.nl:38572/
# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-4305/.s.monetdb.38572
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded


# 14:37:11 >  
# 14:37:11 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-4305" "--port=38572"
# 14:37:11 >  

#SELECT ST_IsSimple(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));
% . # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ false ]
#SELECT ST_IsSimple(ST_GeomFromText('LINESTRING(1 1,2 2,2 3.5,1 3,1 2,2 1)'));
% . # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ false ]
#create table geo (g geometry(polygon, 4326));
#insert into geo values(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))', 4326));
[ 1     ]
#select st_IsSimple(g) from geo;
% sys. # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ false ]
#drop table geo;
#create table geo (g geometry(linestring, 4326));
#insert into geo values(ST_GeomFromText('LINESTRING(1 1,2 2,2 3.5,1 3,1 2,2 1)', 4326));
[ 1     ]
#select st_IsSimple(g) from geo;
% sys. # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ false ]
#drop table geo;
#create table geo (g geometry(multipoint, 4326));
#insert into geo values (st_mpointfromtext('multipoint(10 10, 20 20, 30 30)', 4326));
[ 1     ]
#insert into geo values (st_mpointfromtext('multipoint(10 10, 20 20, 10 5)', 4326));
[ 1     ]
#select st_isvalid(g) from geo;
% sys. # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ true  ]
[ true  ]
#drop table geo;
#SELECT geom AS "GEOMETRY" FROM geometries WHERE id<11 AND ST_IsSimple(geom);
% sys. # table_name
% GEOMETRY # name
% geometry # type
% 0 # length
[ "POINT (10 20)"       ]
[ "LINESTRING (10 20, 30 40, 50 60)"    ]
[ "LINESTRING (10 20, 30 40, 50 60, 80 60, 60 40, 10 20)"       ]
[ "POLYGON ((10 10, 10 20, 20 20, 20 10, 10 10))"       ]
[ "MULTIPOINT (10 20, 30 40)"   ]
[ "MULTILINESTRING ((30 40, 40 50), (50 60, 60 70))"    ]
[ "MULTIPOLYGON (((10 10, 10 20, 20 20, 20 10, 10 10), (30 30, 30 40, 40 40, 40 30, 30 30)))"   ]

# 14:37:12 >  
# 14:37:12 >  "Done."
# 14:37:12 >