[PostGIS] #5836: Different result with same table and same query in various PostGIS versions

PostGIS trac at osgeo.org
Mon Jan 13 19:46:56 PST 2025


#5836: Different result with same table and same query in various PostGIS versions
------------------------+---------------------
 Reporter:  zhangyijun  |      Owner:  pramsey
     Type:  defect      |     Status:  new
 Priority:  medium      |  Milestone:
Component:  postgis     |    Version:  3.5.x
 Keywords:              |
------------------------+---------------------
 Hi! Have a nice day
 It seems we got different results with same table and same query,

 The TABLE is:
 [https://github.com/maplibre/martin/blob/935c6b624fde3a7ba48443ff66e4cf6312b6ef1e/tests/fixtures/tables/table_source.sql]
 you could execute this sql to init the table.

 The QUERY is :

 {{{
 SELECT
       ST_AsMVT(tile, 'table_source', 4096, 'geom')
     FROM (
       SELECT
         ST_AsMVTGeom(
             ST_Transform(ST_CurveToLine("geom"::geometry), 3857),
             ST_TileEnvelope($1::integer, $2::integer, $3::integer),
             4096, 64, true
         ) AS geom
         , "gid"
       FROM
         "public"."table_source"
       WHERE
         "geom" && ST_Transform(ST_TileEnvelope($1::integer, $2::integer,
 $3::integer, margin => 0.015625), 4326)

     ) AS tile;
 }}}

 The RESULT is different with postgis/postgis:14-3.3 and
 postgis/postgis:14-3.5 DOCKER IMAGES.

 z 1 x 1 y 1 => (BLOB) 2 bytes with postgis/postgis:14-3.3
 z 1 x 1 y 1 => (BLOB) 607 bytes with postgis/postgis:14-3.5

 z 1 x 1 y 0 => (BLOB) 2 bytes with postgis/postgis:14-3.3
 z 1 x 1 y 0 => (BLOB) 1.18 KB with postgis/postgis:14-3.5
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5836>
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.


More information about the postgis-tickets mailing list