From ef57b7405a3be389c1e4d3036e90c2cac448e7bc Mon Sep 17 00:00:00 2001 From: Paul Ramsey Date: Sun, 4 Oct 2015 15:59:37 +0000 Subject: [PATCH] Force output to little endian, #3314 git-svn-id: http://svn.osgeo.org/postgis/trunk@14182 b70326c6-7e19-0410-871a-916f4a2858ee --- regress/sfcgal/regress.sql | 4 ++-- regress/sfcgal/tickets.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/regress/sfcgal/regress.sql b/regress/sfcgal/regress.sql index cdadfdb02..d469bc750 100644 --- a/regress/sfcgal/regress.sql +++ b/regress/sfcgal/regress.sql @@ -246,7 +246,7 @@ select '149', ST_AsText(ST_segmentize('GEOMETRYCOLLECTION EMPTY'::geometry, 0.5) select '150', ST_AsEWKT(ST_ForceCollection(ST_setsrid('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'::geometry, 6))); -select '151', ST_MakeEnvelope(0, 0, 1, 1, 4326); +select '151', encode(ST_AsEWKB(ST_MakeEnvelope(0, 0, 1, 1, 4326),'ndr'),'hex'); select '152', ST_SRID(ST_MakeEnvelope(0, 0, 1, 1, 4326)); select '152.1', ST_SRID(ST_MakeEnvelope(0, 0, 1, 1)) = ST_SRID('POINT(0 0)'::geometry); select '152.2', ST_SRID(ST_SetSRID(ST_MakeEnvelope(0, 0, 1, 1), 4326)); @@ -260,7 +260,7 @@ select '158', ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECT select '159', ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 0, 1 1), POINT(1 1)),LINESTRING(2 2, 3 3))',3)); select '160', ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 0, 1 1), POINT(1 1)),LINESTRING(2 2, 3 3))',1)); select '161', ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 0, 1 1), GEOMETRYCOLLECTION(POINT(1 1))),LINESTRING(2 2, 3 3))',2)); -select '162', ST_MakeLine(ST_GeomFromText('POINT(-11.1111111 40)'),ST_GeomFromText('LINESTRING(-11.1111111 70,70 -11.1111111)')) As result; +select '162', encode(ST_AsEWKB(ST_MakeLine(ST_GeomFromText('POINT(-11.1111111 40)'),ST_GeomFromText('LINESTRING(-11.1111111 70,70 -11.1111111)')),'ndr'),'hex') As result; select '163', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 0))'); select '164', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 1))'); select '165', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0.1 1))'); diff --git a/regress/sfcgal/tickets.sql b/regress/sfcgal/tickets.sql index 4f1a0362d..ba9206c9f 100644 --- a/regress/sfcgal/tickets.sql +++ b/regress/sfcgal/tickets.sql @@ -374,7 +374,7 @@ SELECT '#689', ST_CoveredBy(ST_GeomFromText('POLYGON EMPTY'), ST_GeomFromText('L -- #690 -- SELECT '#690'; -SELECT ST_MakeLine(ST_GeomFromText('POINT(-11.1111111 40)'), ST_GeomFromText('LINESTRING(-11.1111111 70,70 -11.1111111)')) As result; +SELECT encode(ST_AsEWKB(ST_MakeLine(ST_GeomFromText('POINT(-11.1111111 40)'), ST_GeomFromText('LINESTRING(-11.1111111 70,70 -11.1111111)')),'ndr'),'hex') As result; -- #693 -- SELECT '#693a', ST_AsText(ST_GeomFromEWKT('SRID=4326;POLYGONM((-71.1319 42.2503 1,-71.132 42.2502 3,-71.1323 42.2504 -2,-71.1322 42.2505 1,-71.1319 42.2503 0))')); -- 2.40.0