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

[PostGIS]

#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
Resolution:              |   Keywords:
-------------------------+---------------------
Description changed by zhangyijun:

Old description:

> 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

New description:

 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#comment:1>
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.