Opened 11 years ago

Closed 11 years ago

#2472 closed defect (fixed)

Regress failure on debbie testing PostgreSQL 8.4

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.5
Component: postgis Version: 2.0.x
Keywords: Cc:

Description

pramsey,

It appears some of your sweeping regress changes don't seem to work on PostgreSQL 8.4.

 PostgreSQL 8.4.17 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.4.5-8) 4.4.5, 64-bit
 Postgis 2.0.5SVN - r11943 - 2013-09-06 23:58:06
   GEOS: 3.3.10dev-CAPI-1.7.10
   PROJ: Rel. 4.7.1, 23 September 2009

Running tests

 loader/Point ....................... ok 
 loader/PointM ....................... ok 
 loader/PointZ ....................... ok 
 loader/MultiPoint ....................... ok 
 loader/MultiPointM ....................... ok 
 loader/MultiPointZ ....................... ok 
 loader/Arc ....................... ok 
 loader/ArcM ....................... ok 
 loader/ArcZ ....................... ok 
 loader/Polygon ....................... ok 
 loader/PolygonM ....................... ok 
 loader/PolygonZ ....................... ok 
 loader/TSTPolygon ......... ok 
 loader/TSIPolygon ......... ok 
 loader/TSTIPolygon ......... ok 
 loader/PointWithSchema ..... ok 
 loader/NoTransPoint ......... ok 
 loader/NotReallyMultiPoint ............... ok 
 loader/MultiToSinglePoint ......... ok 
 loader/ReprojectPts ........ ok 
 loader/ReprojectPtsGeog ........ ok 
 loader/Latin1 .... ok 
 binary .. ok 
 regress .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_24_diff)
-----------------------------------------------------------------------------
--- regress_expected	2013-09-06 15:57:17.000000000 -0700
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_24_out	2013-09-06 16:59:20.000000000 -0700
@@ -154,7 +154,7 @@
 148|LINESTRING(0 0,5 0,10 0)
 149|GEOMETRYCOLLECTION EMPTY
 150|SRID=6;GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)))
-151|\x01030000000100000005000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000000000000000000000000000000000000000
+151|\001\003\000\000\000\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000
 152|4326
 152.1|t
 152.2|4326
@@ -167,7 +167,7 @@
 159|MULTIPOLYGON EMPTY
 160|MULTIPOINT(1 1)
 161|MULTILINESTRING((0 0,1 1),(2 2,3 3))
-162|\x010200000003000000f771d98de33826c00000000000004440f771d98de33826c000000000008051400000000000805140f771d98de33826c0
+162|\001\002\000\000\000\003\000\000\000\367q\331\215\3438&\300\000\000\000\000\000\000D@\367q\331\215\3438&\300\000\000\000\000\000\200Q@\000\000\000\000\000\200Q@\367q\331\215\3438&\300
 163|POLYGON((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))
 164|POLYGON((0 0 0,1 0 0,1 1 0,0 1 0,0 0 1))
 ERROR:  geometry contains non-closed rings
-----------------------------------------------------------------------------
 regress_index .. ok 
 regress_index_nulls .. ok 
 lwgeom_regress .. ok 
 regress_lrs .. ok 
 removepoint .. ok 
 setpoint .. ok 
 simplify .. ok 
 snaptogrid .. ok 
 summary .. ok 
 affine .. ok 
 empty .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_35_diff)
-----------------------------------------------------------------------------
--- empty_expected	2013-09-06 15:57:17.000000000 -0700
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_35_out	2013-09-06 16:59:22.000000000 -0700
@@ -23,13 +23,13 @@
 T3.16|
 T3.17|
 T3.18|
-ST_Buffer(empty, tolerance) == empty|\x010300000000000000
-ST_Union(geometry, empty) == geometry|\x0103000000010000000400000000000000000000000000000000000000000000000000244000000000000000000000000000001440000000000000144000000000000000000000000000000000
-ST_Union(empty, empty) == empty|\x010300000000000000
-ST_Intersection(geometry, empty) == geometry|\x010300000000000000
-ST_Intersection(empty, empty) == empty|\x010300000000000000
-ST_Difference(geometry, empty) == geometry|\x0103000000010000000400000000000000000000000000000000000000000000000000244000000000000000000000000000001440000000000000144000000000000000000000000000000000
-ST_Difference(empty, geometry) == empty|\x010300000000000000
+ST_Buffer(empty, tolerance) == empty|\001\003\000\000\000\000\000\000\000
+ST_Union(geometry, empty) == geometry|\001\003\000\000\000\001\000\000\000\004\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000\000\000\000\000\000\000\000\000\024@\000\000\000\000\000\000\024@\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000
+ST_Union(empty, empty) == empty|\001\003\000\000\000\000\000\000\000
+ST_Intersection(geometry, empty) == geometry|\001\003\000\000\000\000\000\000\000
+ST_Intersection(empty, empty) == empty|\001\003\000\000\000\000\000\000\000
+ST_Difference(geometry, empty) == geometry|\001\003\000\000\000\001\000\000\000\004\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000\000\000\000\000\000\000\000\000\024@\000\000\000\000\000\000\024@\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000
+ST_Difference(empty, geometry) == empty|\001\003\000\000\000\000\000\000\000
 ST_Distance(geometry, empty) == NULL|
 ST_DWithin(geometry, empty, tolerance) == FALSE|f
 ST_Within(geometry, empty) == FALSE|f
-----------------------------------------------------------------------------
 measures .. ok 
 legacy .. ok 
 long_xact .. ok 
 ctors .. ok 
 sql-mm-serialize .. ok 
 sql-mm-circularstring .. ok 
 sql-mm-compoundcurve .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_42_diff)
-----------------------------------------------------------------------------
--- sql-mm-compoundcurve_expected	2013-09-06 15:57:17.000000000 -0700
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_42_out	2013-09-06 16:59:23.000000000 -0700
@@ -66,11 +66,11 @@
 public.compoundcurve.the_geom_3dz effectively removed.
 public.compoundcurve.the_geom_3dm effectively removed.
 public.compoundcurve.the_geom_2d effectively removed.
-valid wkt compound curve 1|\x0109000000020000000102000000030000009fe5797057376340e09398b1b2373bc05aae0a165f0963409f6760a2493d3dc0db6286dfb057634082d8a1b32f843ec0010200000004000000db6286dfb057634082d8a1b32f843ec075b4e4d0c60c634031fa5d1a371540c0d7197ced9b636340a3cb59a7630a41c050f4a72ac0fb6240974769fce3cf41c0
-valid wkt compound curve 2|\x0109000000010000000102000000060000009fe5797057376340e09398b1b2373bc05aae0a165f0963409f6760a2493d3dc0db6286dfb057634082d8a1b32f843ec075b4e4d0c60c634031fa5d1a371540c0d7197ced9b636340a3cb59a7630a41c050f4a72ac0fb6240974769fce3cf41c0
-valid wkt compound curve 3|\x0109000000010000000102000000030000000ce586d73cf36240bbc46888f0523bc0102e91c951e76240df90a1bec0f841c0f970c100ffd7624074ade6ce86cd3bc0
-valid wkt compound curve 4|\x0109000000020000000102000000030000009fe5797057376340e09398b1b2373bc05aae0a165f0963409f6760a2493d3dc0db6286dfb057634082d8a1b32f843ec0010800000005000000db6286dfb057634082d8a1b32f843ec0db6286dfb057634082d8a1b32f843ec075b4e4d0c60c634031fa5d1a371540c0d7197ced9b636340a3cb59a7630a41c050f4a72ac0fb6240974769fce3cf41c0
-valid wkt compound curve 5|\x010900000003000000010800000003000000468280e724bc6340bf4b46210b973bc0f890aea18d8063402d9664151d483cc0eed64bb6ee726340903ca5bda0863ac0010200000004000000eed64bb6ee726340903ca5bda0863ac09fe5797057376340e09398b1b2373bc05aae0a165f0963409f6760a2493d3dc0db6286dfb057634082d8a1b32f843ec0010800000005000000db6286dfb057634082d8a1b32f843ec0db6286dfb057634082d8a1b32f843ec075b4e4d0c60c634031fa5d1a371540c0d7197ced9b636340a3cb59a7630a41c050f4a72ac0fb6240974769fce3cf41c0
+valid wkt compound curve 1|\001\011\000\000\000\002\000\000\000\001\002\000\000\000\003\000\000\000\237\345ypW7c@\340\223\230\261\2627;\300Z\256\012\026_\011c@\237g`\242I==\300\333b\206\337\260Wc@\202\330\241\263/\204>\300\001\002\000\000\000\004\000\000\000\333b\206\337\260Wc@\202\330\241\263/\204>\300u\264\344\320\306\014c@1\372]\0327\025@\300\327\031|\355\233cc@\243\313Y\247c\012A\300P\364\247*\300\373b@\227Gi\374\343\317A\300
+valid wkt compound curve 2|\001\011\000\000\000\001\000\000\000\001\002\000\000\000\006\000\000\000\237\345ypW7c@\340\223\230\261\2627;\300Z\256\012\026_\011c@\237g`\242I==\300\333b\206\337\260Wc@\202\330\241\263/\204>\300u\264\344\320\306\014c@1\372]\0327\025@\300\327\031|\355\233cc@\243\313Y\247c\012A\300P\364\247*\300\373b@\227Gi\374\343\317A\300
+valid wkt compound curve 3|\001\011\000\000\000\001\000\000\000\001\002\000\000\000\003\000\000\000\014\345\206\327<\363b@\273\304h\210\360R;\300\020.\221\311Q\347b@\337\220\241\276\300\370A\300\371p\301\000\377\327b@t\255\346\316\206\315;\300
+valid wkt compound curve 4|\001\011\000\000\000\002\000\000\000\001\002\000\000\000\003\000\000\000\237\345ypW7c@\340\223\230\261\2627;\300Z\256\012\026_\011c@\237g`\242I==\300\333b\206\337\260Wc@\202\330\241\263/\204>\300\001\010\000\000\000\005\000\000\000\333b\206\337\260Wc@\202\330\241\263/\204>\300\333b\206\337\260Wc@\202\330\241\263/\204>\300u\264\344\320\306\014c@1\372]\0327\025@\300\327\031|\355\233cc@\243\313Y\247c\012A\300P\364\247*\300\373b@\227Gi\374\343\317A\300
+valid wkt compound curve 5|\001\011\000\000\000\003\000\000\000\001\010\000\000\000\003\000\000\000F\202\200\347$\274c@\277KF!\013\227;\300\370\220\256\241\215\200c@-\226d\025\035H<\300\356\326K\266\356rc@\220<\245\275\240\206:\300\001\002\000\000\000\004\000\000\000\356\326K\266\356rc@\220<\245\275\240\206:\300\237\345ypW7c@\340\223\230\261\2627;\300Z\256\012\026_\011c@\237g`\242I==\300\333b\206\337\260Wc@\202\330\241\263/\204>\300\001\010\000\000\000\005\000\000\000\333b\206\337\260Wc@\202\330\241\263/\204>\300\333b\206\337\260Wc@\202\330\241\263/\204>\300u\264\344\320\306\014c@1\372]\0327\025@\300\327\031|\355\233cc@\243\313Y\247c\012A\300P\364\247*\300\373b@\227Gi\374\343\317A\300
 ERROR:  incontinuous compound curve
 ERROR:  incontinuous compound curve
 ERROR:  geometry must have an odd number of points
@@ -80,8 +80,8 @@
 valid wkb compound curve 4|COMPOUNDCURVE((153.72942375 -27.2175704,152.29285719 -29.23940482,154.74034096 -30.51635287),CIRCULARSTRING(154.74034096 -30.51635287,154.74034096 -30.51635287,152.39926953 -32.16574411,155.11278414 -34.08116619,151.86720784 -35.62414508))
 valid wkb compound curve 5|COMPOUNDCURVE(CIRCULARSTRING(157.87950492 -27.59001358,156.01728901 -28.28169378,155.59163966 -26.52589021),(155.59163966 -26.52589021,153.72942375 -27.2175704,152.29285719 -29.23940482,154.74034096 -30.51635287),CIRCULARSTRING(154.74034096 -30.51635287,154.74034096 -30.51635287,152.39926953 -32.16574411,155.11278414 -34.08116619,151.86720784 -35.62414508))
 null response|
-minpoints issues - pass|\x01090000000100000001020000000200000000000000000000000000000000000000000000000000f03f000000000000f03f
-minpoints issues - pass|\x010900000001000000010800000003000000000000000000000000000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f
+minpoints issues - pass|\001\011\000\000\000\001\000\000\000\001\002\000\000\000\002\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?
+minpoints issues - pass|\001\011\000\000\000\001\000\000\000\001\010\000\000\000\003\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?
 ERROR:  geometry requires more points
 ERROR:  geometry requires more points
 ERROR:  geometry requires more points
-----------------------------------------------------------------------------
 sql-mm-curvepoly .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_43_diff)
-----------------------------------------------------------------------------
--- sql-mm-curvepoly_expected	2013-09-06 15:57:17.000000000 -0700
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_43_out	2013-09-06 16:59:23.000000000 -0700
@@ -71,11 +71,11 @@
 public.curvepolygon.the_geom_3dm effectively removed.
 public.curvepolygon.the_geom_3dz effectively removed.
 public.curvepolygon.the_geom_4d effectively removed.
-valid wkt curve polygon 1|\x010a00000001000000010200000007000000ccdf061ad9f3614054093e6d99093ec0ab9085dbb6dd614081540229216040c0ebd7a828c33e62409bf026782a7e41c0000000c06bb2624000000020adb440c08e632f616ead6240c9f7b0bf1dd33dc09011eec0de4362407dd6672f76323ec0ccdf061ad9f3614054093e6d99093ec0
-valid wkt curve polygon 2|\x010a00000002000000010200000007000000ccdf061ad9f3614054093e6d99093ec0ab9085dbb6dd614081540229216040c0ebd7a828c33e62409bf026782a7e41c0000000c06bb2624000000020adb440c08e632f616ead6240c9f7b0bf1dd33dc09011eec0de4362407dd6672f76323ec0ccdf061ad9f3614054093e6d99093ec00102000000060000006844c4fe011b6240342e2993e0423fc0d45daf9d93066240c4a0c305d62240c000000080ac31624000000020fbbe40c0000000e0107f6240000000c0a10440c04e1c0c14624c6240bf3fb6405c793fc06844c4fe011b6240342e2993e0423fc0
-valid wkt curve polygon 3|\x010a00000001000000010800000007000000ccdf061ad9f3614054093e6d99093ec0ab9085dbb6dd614081540229216040c0ebd7a828c33e62409bf026782a7e41c0000000c06bb2624000000020adb440c08e632f616ead6240c9f7b0bf1dd33dc09011eec0de4362407dd6672f76323ec0ccdf061ad9f3614054093e6d99093ec0
-valid wkt curve polygon 4|\x010a00000002000000010800000007000000ccdf061ad9f3614054093e6d99093ec0ab9085dbb6dd614081540229216040c0ebd7a828c33e62409bf026782a7e41c0000000c06bb2624000000020adb440c08e632f616ead6240c9f7b0bf1dd33dc09011eec0de4362407dd6672f76323ec0ccdf061ad9f3614054093e6d99093ec00102000000060000006844c4fe011b6240342e2993e0423fc0d45daf9d93066240c4a0c305d62240c000000080ac31624000000020fbbe40c0000000e0107f6240000000c0a10440c04e1c0c14624c6240bf3fb6405c793fc06844c4fe011b6240342e2993e0423fc0
-valid wkt curve polygon 5|\x010a00000002000000010200000007000000ccdf061ad9f3614054093e6d99093ec0ab9085dbb6dd614081540229216040c0ebd7a828c33e62409bf026782a7e41c0000000c06bb2624000000020adb440c08e632f616ead6240c9f7b0bf1dd33dc09011eec0de4362407dd6672f76323ec0ccdf061ad9f3614054093e6d99093ec00109000000030000000108000000030000006844c4fe011b6240342e2993e0423fc0d45daf9d93066240c4a0c305d62240c000000080ac31624000000020fbbe40c001020000000200000000000080ac31624000000020fbbe40c0000000e0107f6240000000c0a10440c0010800000003000000000000e0107f6240000000c0a10440c04e1c0c14624c6240bf3fb6405c793fc06844c4fe011b6240342e2993e0423fc0
+valid wkt curve polygon 1|\001\012\000\000\000\001\000\000\000\001\002\000\000\000\007\000\000\000\314\337\006\032\331\363a@T\011>m\231\011>\300\253\220\205\333\266\335a@\201T\002)!`@\300\353\327\250(\303>b@\233\360&x*~A\300\000\000\000\300k\262b@\000\000\000 \255\264@\300\216c/an\255b@\311\367\260\277\035\323=\300\220\021\356\300\336Cb@}\326g/v2>\300\314\337\006\032\331\363a@T\011>m\231\011>\300
+valid wkt curve polygon 2|\001\012\000\000\000\002\000\000\000\001\002\000\000\000\007\000\000\000\314\337\006\032\331\363a@T\011>m\231\011>\300\253\220\205\333\266\335a@\201T\002)!`@\300\353\327\250(\303>b@\233\360&x*~A\300\000\000\000\300k\262b@\000\000\000 \255\264@\300\216c/an\255b@\311\367\260\277\035\323=\300\220\021\356\300\336Cb@}\326g/v2>\300\314\337\006\032\331\363a@T\011>m\231\011>\300\001\002\000\000\000\006\000\000\000hD\304\376\001\033b@4.)\223\340B?\300\324]\257\235\223\006b@\304\240\303\005\326"@\300\000\000\000\200\2541b@\000\000\000 \373\276@\300\000\000\000\340\020\177b@\000\000\000\300\241\004@\300N\034\014\024bLb@\277?\266@\\y?\300hD\304\376\001\033b@4.)\223\340B?\300
+valid wkt curve polygon 3|\001\012\000\000\000\001\000\000\000\001\010\000\000\000\007\000\000\000\314\337\006\032\331\363a@T\011>m\231\011>\300\253\220\205\333\266\335a@\201T\002)!`@\300\353\327\250(\303>b@\233\360&x*~A\300\000\000\000\300k\262b@\000\000\000 \255\264@\300\216c/an\255b@\311\367\260\277\035\323=\300\220\021\356\300\336Cb@}\326g/v2>\300\314\337\006\032\331\363a@T\011>m\231\011>\300
+valid wkt curve polygon 4|\001\012\000\000\000\002\000\000\000\001\010\000\000\000\007\000\000\000\314\337\006\032\331\363a@T\011>m\231\011>\300\253\220\205\333\266\335a@\201T\002)!`@\300\353\327\250(\303>b@\233\360&x*~A\300\000\000\000\300k\262b@\000\000\000 \255\264@\300\216c/an\255b@\311\367\260\277\035\323=\300\220\021\356\300\336Cb@}\326g/v2>\300\314\337\006\032\331\363a@T\011>m\231\011>\300\001\002\000\000\000\006\000\000\000hD\304\376\001\033b@4.)\223\340B?\300\324]\257\235\223\006b@\304\240\303\005\326"@\300\000\000\000\200\2541b@\000\000\000 \373\276@\300\000\000\000\340\020\177b@\000\000\000\300\241\004@\300N\034\014\024bLb@\277?\266@\\y?\300hD\304\376\001\033b@4.)\223\340B?\300
+valid wkt curve polygon 5|\001\012\000\000\000\002\000\000\000\001\002\000\000\000\007\000\000\000\314\337\006\032\331\363a@T\011>m\231\011>\300\253\220\205\333\266\335a@\201T\002)!`@\300\353\327\250(\303>b@\233\360&x*~A\300\000\000\000\300k\262b@\000\000\000 \255\264@\300\216c/an\255b@\311\367\260\277\035\323=\300\220\021\356\300\336Cb@}\326g/v2>\300\314\337\006\032\331\363a@T\011>m\231\011>\300\001\011\000\000\000\003\000\000\000\001\010\000\000\000\003\000\000\000hD\304\376\001\033b@4.)\223\340B?\300\324]\257\235\223\006b@\304\240\303\005\326"@\300\000\000\000\200\2541b@\000\000\000 \373\276@\300\001\002\000\000\000\002\000\000\000\000\000\000\200\2541b@\000\000\000 \373\276@\300\000\000\000\340\020\177b@\000\000\000\300\241\004@\300\001\010\000\000\000\003\000\000\000\000\000\000\340\020\177b@\000\000\000\300\241\004@\300N\034\014\024bLb@\277?\266@\\y?\300hD\304\376\001\033b@4.)\223\340B?\300
 ERROR:  geometry contains non-closed rings
 ERROR:  geometry contains non-closed rings
 ERROR:  geometry contains non-closed rings
-----------------------------------------------------------------------------
 sql-mm-general .. ok 
 sql-mm-multicurve .. ok 
 sql-mm-multisurface .. ok 
 polyhedralsurface .. ok 
 polygonize .. ok 
 postgis_type_name .. ok 
 out_geometry .. ok 
 out_geography .. ok 
 in_gml .. ok 
 in_kml .. ok 
 iscollection .. ok 
 regress_ogc .. ok 
 regress_ogc_cover .. ok 
 regress_ogc_prep .. ok 
 regress_bdpoly .. ok 
 regress_proj .. ok 
 regress_management .. ok 
 dump .. ok 
 dumppoints .. ok 
 wmsservers .. ok 
 wkt .. ok 
 wkb .. ok 
 tickets .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_66_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2013-09-06 15:57:17.000000000 -0700
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_66_out	2013-09-06 16:59:27.000000000 -0700
@@ -23,7 +23,7 @@
 #122|CIRCULARSTRING(220268 150415,220227 150505,220227 150406)
 #124a|COMPOUNDCURVE(CIRCULARSTRING(0 0,1 1,1 0),(1 0,30 5),CIRCULARSTRING(30 5,34 56,67 89))
 ERROR:  incontinuous compound curve
-#145a|\x0103000020e610000000000000
+#145a|\001\003\000\000 \346\020\000\000\000\000\000\000
 #145b|0
 #146|0|t|GEOMETRYCOLLECTION(LINESTRING(0 0,-1 -1),MULTIPOINT(1 2,2 3))
 ERROR:  Invalid hex string, length (267) has to be a multiple of two!
@@ -47,7 +47,7 @@
 #213|17
 #234|COMPOUNDCURVE((0 0,1 1))
 #241|0
-#254|\x010700000000000000
+#254|\001\007\000\000\000\000\000\000\000
 #259|
 #260|1667701
 #261|0
@@ -105,8 +105,8 @@
 #681e|
 #681f|
 #681g|
-#682|\x0103000020e610000000000000
-#683|\x0103000020e610000000000000
+#682|\001\003\000\000 \346\020\000\000\000\000\000\000
+#683|\001\003\000\000 \346\020\000\000\000\000\000\000
 #684,#2109|SRID=4326;POINT EMPTY
 #2109|SRID=3395;POINT EMPTY
 #685|0103000020E610000000000000
@@ -115,18 +115,18 @@
 #689|f
 #690
 010200000003000000F771D98DE33826C00000000000004440F771D98DE33826C000000000008051400000000000805140F771D98DE33826C0
-#693a|\x0103000060e61000000100000005000000ea95b20c71c851c02b1895d409204540000000000000f03f9cc420b072c851c0c7bab88d062045400000000000000840b1506b9a77c851c08e75711b0d20454000000000000000c0ff21fdf675c851c0f2d24d6210204540000000000000f03fea95b20c71c851c02b1895d4092045400000000000000000
-#693b|\x0103000060e61000000100000007000000ea95b20c71c851c0aa605452272045400000000000000000386744696fc851c04703780b2420454000000000000034408638d6c56dc851c04703780b2420454000000000000034c08638d6c56dc851c0e3a59bc42020454000000000000014408638d6c56dc851c08048bf7d1d20454000000000000010409cc420b072c851c04703780b242045400000000000001840ea95b20c71c851c0aa605452272045400000000000003e40
+#693a|\001\003\000\000`\346\020\000\000\001\000\000\000\005\000\000\000\352\225\262\014q\310Q\300+\030\225\324\011 E@\000\000\000\000\000\000\360?\234\304 \260r\310Q\300\307\272\270\215\006 E@\000\000\000\000\000\000\010@\261Pk\232w\310Q\300\216uq\033\015 E@\000\000\000\000\000\000\000\300\377!\375\366u\310Q\300\362\322Mb\020 E@\000\000\000\000\000\000\360?\352\225\262\014q\310Q\300+\030\225\324\011 E@\000\000\000\000\000\000\000\000
+#693b|\001\003\000\000`\346\020\000\000\001\000\000\000\007\000\000\000\352\225\262\014q\310Q\300\252`TR' E@\000\000\000\000\000\000\000\0008gDio\310Q\300G\003x\013$ E@\000\000\000\000\000\0004@\2068\326\305m\310Q\300G\003x\013$ E@\000\000\000\000\000\0004\300\2068\326\305m\310Q\300\343\245\233\304  E@\000\000\000\000\000\000\024@\2068\326\305m\310Q\300\200H\277}\035 E@\000\000\000\000\000\000\020@\234\304 \260r\310Q\300G\003x\013$ E@\000\000\000\000\000\000\030@\352\225\262\014q\310Q\300\252`TR' E@\000\000\000\000\000\000>@
 #694
 ERROR:  Shell is not a line
 #695
 ERROR:  First argument must be a LINESTRING
-#696|\x010f000080060000000103000080010000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000010300008001000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000000000000000000001030000800100000005000000000000000000000000000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000000001030000800100000005000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000010300008001000000050000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000103000080010000000500000000000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f
+#696|\001\017\000\000\200\006\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\001\003\000\000\200\001\000\000\000\005\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\360?
 #720|MULTIPOINT(-1113194.91 4838471.4,-1113194.91 7326837.72,-1113194.91 11028513.63,556597.45 4838471.4,556597.45 7326837.72,556597.45 11028513.63,2226389.82 4838471.4,2226389.82 7326837.72,2226389.82 11028513.63,3896182.18 4838471.4,3896182.18 7326837.72,3896182.18 11028513.63,5565974.54 4838471.4,5565974.54 7326837.72,5565974.54 11028513.63)
-#723|\x0101000020e61000006284f068e33826c00000000000004440
-#723|\x0107000020e610000000000000
-#723|\x0107000020e610000000000000
-#723|\x0101000020e61000006284f068e33826c00100000000804b40
+#723|\001\001\000\000 \346\020\000\000b\204\360h\3438&\300\000\000\000\000\000\000D@
+#723|\001\007\000\000 \346\020\000\000\000\000\000\000
+#723|\001\007\000\000 \346\020\000\000\000\000\000\000
+#723|\001\001\000\000 \346\020\000\000b\204\360h\3438&\300\001\000\000\000\000\200K@
 #804|<gml:Point srsName="urn:ogc:def:crs:EPSG::4326"><gml:pos srsDimension="2">0 0</gml:pos></gml:Point>
 #845|t
 #834|GEOMETRYCOLLECTION(POINT(0 0 5),LINESTRING(10 10 5,10 0 5))
@@ -182,7 +182,7 @@
 #1453.2|f
 #1454|t
 #1414|CURVEPOLYGON Z EMPTY
-#1478|\x01040000200100000000000000
+#1478|\001\004\000\000 \001\000\000\000\000\000\000\000
 #745|GEOMETRYCOLLECTION(POLYGON((-72 42 1,-70 43 1,-71 41 1,-72 42 1)))
 #1450|POINT|POLYGON
 #1482|4326
@@ -217,7 +217,7 @@
 #1697.2|0
 #1697.3|1024
 #1734.1|1026
-#1755|\x01e9030000000000000040554000000000008041400000000000000000
+#1755|\001\351\003\000\000\000\000\000\000\000@U@\000\000\000\000\000\200A@\000\000\000\000\000\000\000\000
 #1776|POLYGON((0 0,10 0,10 10,0 0))|POLYGON((0 0,10 0,10 10,0 0))
 #1791|4.7
 ERROR:  ST_Segmentize: invalid max_distance 0 (must be >= 0)
-----------------------------------------------------------------------------
 typmod .. ok 
 remove_repeated_points .. ok 
 split .. ok 
 relate .. ok 
 bestsrid .. ok 
 concave_hull .. ok 
 hausdorff .. ok 
 regress_buffer_params .. ok 
 offsetcurve .. ok 
 relatematch .. ok 
 isvaliddetail .. ok 
 sharedpaths .. ok 
 snap .. ok 
 node .. ok 
 unaryunion .. ok 
 clean .. ok 
 relate_bnr .. ok 
 in_geojson .. ok 
 uninstall .. ok (3699)

Run tests: 85
Failed: 5

Seems to be the difference in bytea that PostgreSQL 9.0 default to hex and 8.4 is escape. We might need to set as an extra flag I guess for 2.0 testing. 2.1+ is a non-issue since the minimum we support in 2.1 is 9.0

Change History (2)

comment:1 by pramsey, 11 years ago

Oh fart, of course, they changed the bytea representation at 9.0. What a PITA

comment:2 by pramsey, 11 years ago

Resolution: fixed
Status: newclosed

Bah, fixed at r11954

Note: See TracTickets for help on using tickets.