Different result with same table and same query in various PostGIS versions

[zhangyijun]

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