Geopackage raster table with dots in the name cannot be added

Description

If a Geopackage raster table name contains dots, it cannot be added as layer and will throw errors:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:///Users/stefan/sources/bigtiff/gpkg/relief.with.dots.gpkg and hints Hints: REPOSITORY = org.geoserver.catalog.CatalogRepository@22dc6844 EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@62d09328[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] System defaults: STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@710b18a6 FORCE_AXIS_ORDER_HONORING = http GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl COMPARISON_TOLERANCE = 1.0E-8

Error log:

24 Jun 17:46:59 DEBUG [org.geotools.geopkg] - SELECT a.*, c.organization_coordsys_id, c.definition FROM gpkg_contents a, gpkg_spatial_ref_sys c WHERE a.srs_id = c.srs_id AND a.data_type = ?
24 Jun 17:46:59 WARN [org.geotools.geopkg.mosaic] - org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near ".": syntax error)
java.io.IOException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near ".": syntax error) at org.geotools.geopkg.GeoPackage.tiles(GeoPackage.java:1107)

Environment

macOS Mojave, OpenJDK 8

Assignee

Unassigned

Reporter

Stefan Ziegler

Triage

None

Fix versions

None

Affects versions

Components

Priority

Medium
Configure