Changeset: 1a88054d60d4 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a88054d60d4
Added Files:
geom/sql/Tests/pg_regression/Tests/snaptogrid.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regress: snaptogrid
diffs (27 lines):
diff --git a/geom/sql/Tests/pg_regression/Tests/All
b/geom/sql/Tests/pg_regression/Tests/All
--- a/geom/sql/Tests/pg_regression/Tests/All
+++ b/geom/sql/Tests/pg_regression/Tests/All
@@ -21,4 +21,6 @@
#simplify #Unknown FUnctions: st_simplify
+#snaptogrid #Unknown Functions: st_snaptogrid
+
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/snaptogrid.sql
b/geom/sql/Tests/pg_regression/Tests/snaptogrid.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/snaptogrid.sql
@@ -0,0 +1,12 @@
+
+-- postgis-users/2006-January/010870.html
+CREATE TEMP TABLE tmp (orig geometry);
+INSERT INTO tmp (orig) VALUES
('01020000207D18000007000000D7A3701D641B3FC18B6CE7FB5A721841FA7E6A9C5E1B3FC191ED7C3F9872184139B4C816591B3FC1E3A59BC4D472184104560E4D891A3FC177BE9F1ABF7118417B14AEA7961A3FC18716D94E0C711841022B8716671B3FC1C74B370939721841D7A3701D641B3FC18B6CE7FB5A721841');
+
+-- Repeat tests with new function names.
+SELECT ST_snaptogrid(orig, 0.001) ~= ST_snaptogrid(ST_snaptogrid(orig, 0.001),
0.001) FROM tmp;
+SELECT ST_snaptogrid(orig, 0.005) ~= ST_snaptogrid(ST_snaptogrid(orig, 0.005),
0.005) FROM tmp;
+SELECT ST_snaptogrid(orig, 0.002) ~= ST_snaptogrid(ST_snaptogrid(orig, 0.002),
0.002) FROM tmp;
+SELECT ST_snaptogrid(orig, 0.003) ~= ST_snaptogrid(ST_snaptogrid(orig, 0.003),
0.003) FROM tmp;
+SELECT ST_snaptogrid(orig, 0.0002) ~= ST_snaptogrid(ST_snaptogrid(orig,
0.0002), 0.0002) FROM tmp;
+DROP TABLE tmp;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
