[Geoserver-devel] [JIRA] (GEOS-9433) Wrong WMS results if preparedStatements is enabled on postgis store

GeoServer GeoServer Developer
,
1

lorenzo.pini created an issue

GeoServer / BugGEOS-9433

Wrong WMS results if preparedStatements is enabled on postgis store

Issue Type:

BugBug

Affects Versions:

2.16.1

Assignee:

Unassigned

Attachments:

bad.PNG, bad_detail.png, good.PNG, good_detail.png, test_data_plain.zip

Created:

13/Dec/19 1:59 PM

Environment:

Windows 10
JVM Version Oracle Corporation: 1.8.0_161 (Java HotSpot™ 64-Bit Server VM)
Java Rendering Engine org.marlin.pisces.MarlinRenderingEngine

Priority:

MediumMedium

Reporter:

lorenzo.pini

I stumbled a strange bug that prevents the data I have on a postgis database to be rendered via WMS.

I tested this bug with the latest 2.16.1 Platform Independent Binary

A data sample is attached (test_data_plain.zip)

To reproduce:

  1. Import the data sample in a postgis database
  2. Create a new postgis store pointing to the database
  3. Ensure the “preparedStatements” option is NOT enabled
  4. Save and Publish the only table “metopa” as a new layer
  5. Compute bounds from data and assign the default “point” style
  6. Preview the layer, the data should be visible
  7. Go back to the store and enable the “preparedStatements” option
  8. Preview the layer again, notice the preview is different and it is hardly showing any data

I attached screenshots of a “good” and a “bad” preview

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#100116-sha1:c5e7184)

Atlassian logo