From b798e45d87fe3418119acc727bc8a18b0acf23fc Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Tue, 17 Jan 2012 19:15:48 +0000 Subject: [PATCH] Test canonical binary output for geometry (#850) NOTE: big-endian machines are expected to fail this new test please send your actual output for a fix git-svn-id: http://svn.osgeo.org/postgis/trunk@8859 b70326c6-7e19-0410-871a-916f4a2858ee --- regress/Makefile.in | 1 + regress/binary.sql | 36 ++++++++++++++++++++++++++++++++++++ regress/binary_expected | Bin 0 -> 1971 bytes 3 files changed, 37 insertions(+) create mode 100644 regress/binary.sql create mode 100644 regress/binary_expected diff --git a/regress/Makefile.in b/regress/Makefile.in index 497b48684..3c0f84de8 100644 --- a/regress/Makefile.in +++ b/regress/Makefile.in @@ -60,6 +60,7 @@ TESTS = \ loader/ReprojectPts \ loader/ReprojectPtsGeog \ loader/Latin1 \ + binary \ regress \ regress_index \ regress_index_nulls \ diff --git a/regress/binary.sql b/regress/binary.sql new file mode 100644 index 000000000..0c90bb7fa --- /dev/null +++ b/regress/binary.sql @@ -0,0 +1,36 @@ +SET client_min_messages TO warning; +CREATE SCHEMA tm; + +CREATE TABLE tm.types (id serial, g geometry); + +INSERT INTO tm.types(g) values ('POINT EMPTY'); +INSERT INTO tm.types(g) values ('LINESTRING EMPTY'); +INSERT INTO tm.types(g) values ('POLYGON EMPTY'); +INSERT INTO tm.types(g) values ('MULTIPOINT EMPTY'); +INSERT INTO tm.types(g) values ('MULTILINESTRING EMPTY'); +INSERT INTO tm.types(g) values ('MULTIPOLYGON EMPTY'); +INSERT INTO tm.types(g) values ('GEOMETRYCOLLECTION EMPTY'); +INSERT INTO tm.types(g) values ('CIRCULARSTRING EMPTY'); +INSERT INTO tm.types(g) values ('COMPOUNDCURVE EMPTY'); +INSERT INTO tm.types(g) values ('CURVEPOLYGON EMPTY'); +INSERT INTO tm.types(g) values ('MULTICURVE EMPTY'); +INSERT INTO tm.types(g) values ('MULTISURFACE EMPTY'); +INSERT INTO tm.types(g) values ('POLYHEDRALSURFACE EMPTY'); +INSERT INTO tm.types(g) values ('TRIANGLE EMPTY'); +INSERT INTO tm.types(g) values ('TIN EMPTY'); + +-- all zm flags +INSERT INTO tm.types(g) +SELECT st_force_3dz(g) FROM tm.types WHERE id < 15 ORDER BY id; +INSERT INTO tm.types(g) +SELECT st_force_3dm(g) FROM tm.types WHERE id < 15 ORDER BY id; +INSERT INTO tm.types(g) +SELECT st_force_4d(g) FROM tm.types WHERE id < 15 ORDER BY id; + +-- known srid +INSERT INTO tm.types(g) +SELECT st_setsrid(g,1) FROM tm.types ORDER BY id; + +COPY ( SELECT g FROM tm.types ORDER BY id ) TO STDOUT WITH BINARY; + +DROP SCHEMA tm CASCADE; diff --git a/regress/binary_expected b/regress/binary_expected new file mode 100644 index 0000000000000000000000000000000000000000..f235b597a6103dd86a071600e9111b99f2cb41c1 GIT binary patch literal 1971 zcmZvb!A-+J00iw20x?)X2Pp*<5PVQ9c=1aqltL+#LMLIIh+}VTzcO=Y$+J?1=k0Fz z=nj3?l&9s_x?TS92^Te<)u_wo_35g{iyAL$T-R8>>+~5{_33quH#OeXcv~ai{CPAb zFpLTsF;pGd`s#k)lLhrYKJ-N~9=}qC|=k zDN3X$k)lM35-CdLBfp#RDMg7CCF(Loc}h_tMTrz8Qj|zhB1MT5B~p|~(LeU%-)b|) z9G~$=-!7(#GT)kckwV{EO%_l>#S&Ho{Y;mzVhO967g@r$Si*`WtXRT|C9GJ&iY2UA!ipuVSfZ%I;qh%ZY~Hso IPp=Q%FCwEt%m4rY literal 0 HcmV?d00001 -- 2.49.0