[Geoserver-devel] [JIRA] (GEOS-10234) WMS GetFeatureInfo fails for layer backed by VIEW tables

Giacomo Guarguaglini created an issue

GeoServer / BugGEOS-10234

WMS GetFeatureInfo fails for layer backed by VIEW tables

Issue Type:

BugBug

Affects Versions:

2.19.2

Assignee:

Unassigned

Components:

WMS

Created:

16/Sep/21 1:57 PM

Environment:

GeoServer 2.19.2
Postgres 10
Postgis 2.4

1 DB Table with several features, say POI
1 DB View on this table filtering some feature, say POIView
1 GeoServer Store on DB
1 GeoServer layer on POI, say POILayer
1 GeoServer layer on POIView, say POIViewLayer

Priority:

MediumMedium

Reporter:

Giacomo Guarguaglini

After the configuration described above, we use the layer preview to see the result:

  1. the WMS preview for POILayer works as expected
  2. the WMS GetFeatureInfo for POILayer works as expected returning N features
  3. the WMS preview for *POIViewLayer works as expected
  4. the WMS GetFeatureInfo for *POIViewLayer * doesn’t returning 0 features

Note:
we checked the SQL query on postgres that are both correct and work well in pgAdmin
We didn’t find errors in log

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS


This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100177-sha1:149c709)

Atlassian logo