tickets.sql tests fail

[strk]

The tests for #260, #304, #657 and #1398 all fail as of r9037

[strk]

Git bisect blames r9029 for this, done for #1538

[pramsey]

Not For Me. What are the actual regression failures?

[strk]

-----------------------------------------------------------------------------
--- tickets_expected    2012-02-06 13:56:37.000000000 +0100
+++ /tmp/pgis_reg_32108/test_65_out     2012-02-06 20:43:25.000000000 +0100
@@ -50,7 +50,7 @@
 #241|0
 #254|010700000000000000
 #259|
-#260|1667701
+#260|0
 #261|0
 #262|POINT(-119.5434 34.9438)|t|t|t
 #262|POINT(-119.5452 34.9442)|t|t|t
@@ -65,7 +65,17 @@
 #277|<gml:Point><gml:coordinates>1,1e+308</gml:coordinates></gml:Point>
 #299|2
 #304
-#304.a|21
+POINT(-170 -80)|32702|NaN|NaN
+POINT(-170 -70)|32702|NaN|NaN
+POINT(-170 -60)|32702|NaN|NaN
+POINT(-170 -50)|32702|NaN|NaN
+POINT(-170 -40)|32702|NaN|NaN
+POINT(-170 -30)|32702|NaN|NaN
+POINT(-170 -20)|32702|NaN|NaN
+POINT(-170 -10)|32702|NaN|NaN
+POINT(-170 0)|32702|0|0
+POINT(-170 10)|32602|NaN|NaN
+#304.a|29
 #304.b|1
 #408|IllegalArgumentException: point array must contain 0 or >1 elements
 NOTICE:  IllegalArgumentException: point array must contain 0 or >1 elements
@@ -166,9 +176,9 @@
 </#1320>
 #1344|25
 #1385|
-#657.1|-166.78
-#657.2|10.00
-#657.3|t
+ERROR:  Distance must be between 0 and 1.4822e-323
+ERROR:  Distance must be between 0 and 1.4822e-323
+ERROR:  Distance must be between 0 and 1.4822e-323
 #1305.1|POINT(10 10)
 #1305.2|t
 #1305.3|t
@@ -193,5 +203,5 @@
 #1489|MULTIPOINT EMPTY|0|MULTILINESTRING EMPTY|0|MULTIPOLYGON EMPTY|0|GEOMETRYCOLLECTION EMPTY|0
 ERROR:  AddToPROJ4SRSCache: couldn't parse proj4 string: '': (null)
 #1038|
-#1398a|POINT(-119.093153 45.632669)
-#1398b|POINT(-160.137654 77.091608)
+ERROR:  Distance must be between 0 and 1.4822e-323
+ERROR:  Distance must be between 0 and 1.4822e-323

[pramsey]

What's your proj version?

[strk]

POSTGIS="2.0.0alpha4SVN" GEOS="3.3.2dev-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.6" USE_STATS

[pramsey]

Is it possible that the proj includes files you are building against are different that the proj .so file you are linking against? The errors say to me: the spheroid is being initialized with the wrong numbers, but the only mechanism I can see for that to happen would be if the interpretation of the PJ struct is incorrect somehow.

[pramsey]

Which incidentally is a fine example of why to not use the private API, but doesn't help me in the current term get access to the proj spheroid parameters.

[strk]

It is _very_ likely, more than possible, especially because proj4 doesn't have a "make uninstall" rule ( ​http://trac.osgeo.org/proj/ticket/144 ).

But still, previous postgis revision didn't suffer from this regression.

[pramsey]

It wouldn't because it didn't look directly into the PJ structure. If you could confirm that this is the problem I can at least stop worrying about the cause of the regression and most towards thinking about a solution.

[strk]

annoying enough it turns out that "4.7.1 released 23 September 2009" is indeed PROJ trunk, advertising itself as such …

Dropping the new lib and the new header fixes the regression. Can't build with _only_ proj4 trunk due to the other bug you can now be thinking about a solution for