gpkg_ogr_contents.feature_count can not be updated when started with empty table

[andreglauser]

What is the bug?

If a table is created empty and features are added afterwards gpkg_ogr_contents.feature_count can not be updated because NULL + 1 results to "NULL"

In a GPKG the column feature_count of the table gpkg_ogr_contents is created with a default of NULL. For new tables triggers are created to manage gpkg_ogr_contents.feature_count with ..SET feature_count = feature_count + 1... In case the existing value of feature_count is NULL the triggers are not able to increment the number from NULL to 1.

• Creation of gpkg_ogr_contents
• Creation of Trigger for tables

Steps to reproduce the issue

With QGIS: Create a Geopackage with an new layer. Add some features. Check the data of gpkg_ogr_contents.

With follwing example for the table "new_table" the behaviour can be simulated.

SELECT 
	feature_count + 1 
FROM gpkg_ogr_contents
WHERE lower(table_name) = lower('new_table')

Versions and provenance

Windows 11
GDAL 3.9.3, released 2024/10/07
QGIS 3.34 and 3.40

Additional context

No response