[postgis-tickets] [PostGIS] #3742: mvt regress failure on debbie and winnie

[PostGIS]

#3742: mvt regress failure on debbie and winnie
----------------------+----------------------------
  Reporter:  robe     |      Owner:  Björn Harrtell
      Type:  defect   |     Status:  assigned
  Priority:  blocker  |  Milestone:  PostGIS 2.4.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+----------------------------

Comment (by robe):

 okay I upgraded debbie's 9.4 as well which was at 9.4.5 before and was
 passing.
 still passes after the upgrade to


 {{{
 PostgreSQL 9.4.11 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
 5.2.1-22) 5.2.1 20151010, 64-bit
 }}}

 since I used the same script to compile both the new 9.3 and 9.4, I think
 that rules out how I'm compiling and all that seems to also rule out
 microversion.


 But here's another interesting twist.  I just compiled postgis on my
 windows 7 64-bit against 9.6, and it fails mvt test as well same
 difference.


 {{{

 Creating database 'postgis_reg'
 Loading PostGIS into 'postgis_reg'
 Loading SFCGAL into 'postgis_reg'
 PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit
   Postgis 2.4.0dev - r15360 - 2017-04-23 17:41:51
   scripts 2.4.0dev r15360
   GEOS: 3.6.1-CAPI-1.10.1 r4317
   PROJ: Rel. 4.9.1, 04 March 2015
   SFCGAL: 1.3.0


 +++ /projects/postgis/tmp/2.4_pg9.6w64/test_120_out     2017-04-23
 13:45:34.273093800 -0400
 @@ -25,8 +25,8 @@
  TA6|GisKBHRlc3QSDhIEAAABARgBIgQJMt4/GgJjMRoCYzIiAigBIgIwASiAIHgC
 TA7|Gk4KBHRlc3QSDBICAAAYASIECTTcPxIMEgIAARgBIgQJMt4/EgwSAgABGAEiBAk03D8aAmMxIgsK
  CW90aGVydGVzdCIGCgR0ZXN0KIAgeAI=
 -TA8|GkUKBHRlc3QSDBICAAAYASIECTLePxIMEgIAARgBIgQJNNw/EgwSAgACGAEiBAk03D8aAmMxIgIo
 -ASICKAEiAigCKIAgeAI=
 +TA8|GkEKBHRlc3QSDBICAAAYASIECTLePxIMEgIAABgBIgQJNNw/EgwSAgABGAEiBAk03D8aAmMxIgIo
 +ASICKAIogCB4Ag==
  TU2
  ERROR:  pgis_asmvt_transfn: parameter row cannot be other than a rowtype
  TU3

 }}}

 winnie's 9.6 64-bit run:


 {{{
 PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit
   Postgis 2.4.0dev - r15360 - 2017-04-23 17:53:51
   scripts 2.4.0dev r15360
   GEOS: 3.6.1-CAPI-1.10.1 r4317
   PROJ: Rel. 4.9.1, 04 March 2015
   SFCGAL: 1.3.0

 Running tests

 :
 mvt .. ok
 geobuf .. ok
 }}}


 So clearly PostgreSQL version (even micro) does not seem to be issue.  Why
 winnie's 9.6 passes and mine fails -- when we are setup mostly the same is
 very puzzling.

 I'm suspecting mischievous spirits haunting things :)

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3742#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.