[PostGIS] #5909: Server crashes when ST_ValueCount is called with table and column names but the table is empty

[PostGIS]

#5909: Server crashes when ST_ValueCount is called with table and column names but
the table is empty
----------------------+---------------------------
  Reporter:  dmyzl    |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.5.4
 Component:  raster   |    Version:  3.5.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Also crashes on


 {{{
 PostgreSQL 17.2 on x86_64-windows, compiled by msvc-19.42.34435, 64-bit
 POSTGIS="3.5.2 3.5.2" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0"
 SFCGAL="SFCGAL 1.5.2, CGAL 5.6.1, BOOST 1.84.0" PROJ="8.2.1
 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=C:\Windows\ServiceProfiles\NetworkService\AppData\Local/proj
 DATABASE_PATH=C:\Program
 Files\PostgreSQL\17\share\contrib\postgis-3.5\proj\proj.db" (compiled
 against PROJ 8.2.1) GDAL="GDAL 3.9.2, released 2024/08/13" LIBXML="2.12.5"
 LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
 RASTER
 }}}

 and


 {{{
 PostgreSQL 17.2 (Ubuntu 17.2-1.pgdg24.04+1) on x86_64-pc-linux-gnu,
 compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
 POSTGIS="3.5.1 48ab069" [EXTENSION] PGSQL="170" GEOS="3.12.1-CAPI-1.18.1"
 SFCGAL="SFCGAL 1.5.1, CGAL 5.6, BOOST 1.83.0" PROJ="9.4.0
 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"
 (compiled against PROJ 9.4.0) GDAL="GDAL 3.8.4, released 2024/02/08"
 LIBXML="2.9.14" LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0
 (Internal)" RASTER
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5909#comment:3>
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.