[Geoserver-devel] [JIRA] (GEOS-10326) viewParams are automatically upper cased for SQL View Layer

GeoServer GeoServer Developer
1

Tobias Warneke created an issue

GeoServer / BugGEOS-10326

viewParams are automatically upper cased for SQL View Layer

Issue Type:

BugBug

Affects Versions:

2.18.4

Assignee:

Unassigned

Created:

08/Dec/21 10:18 AM

Priority:

MediumMedium

Reporter:

Tobias Warneke

I created a parameterized sql view layer. It works so far with a SQL like this:

select geom from mytable where id=%id%

Now within my request I construct something like

http://server/geoserver/myworkspace/ows?SERVICE=WMS&LAYERS=mylayer&... &VIEWPARAMS=id:5&...

Within GeoServers log I see witin RawKvp, that my parameters are read by the server, but the viewparam is not put into my SQL.

At the end of this GetMap log output I see a line

 ViewParams = [{ID=5}]

The parameter name is suddenly uppercased.

So if I change my SQL to

select geom from mytable where id=%ID%

and make the parameter name in the layer configuration uppercased as well, all works fine, even if I request my viewparams in lower case.

I consider this a bug. Or is this by intention?

Unfortunately I could not locate the problematic code line.

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#100183-sha1:f6eba4b)

Atlassian logo