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

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


# 01:16:29 >  
# 01:16:29 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-14037" "--port=37208"
# 01:16:29 >  

#SELECT ST_IsSimple(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));
% . # table_name
# .%2 # table_name
% % # name
# %2 # name
% boolean # type
% 5 # length
[ true  ]
#SELECT ST_IsSimple(ST_GeomFromText('LINESTRING(1 1,2 2,2 3.5,1 3,1 2,2 1)'));
% . # table_name
# .%2 # table_name
% % # name
# %2 # 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
# sys.%1 # table_name
% % # name
# %1 # name
% boolean # type
% 5 # length
[ true  ]
#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
# sys.%1 # 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
# sys.%1 # 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)))"   ]

# 01:16:29 >  
# 01:16:29 >  "Done."
# 01:16:29 >