Tobias Warneke (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A99d6c509-ff9c-4d17-8554-ad6ab816fbe5
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
) / Bug (
https://osgeo-org.atlassian.net/browse/GEOS-10326?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
) GEOS-10326 (
https://osgeo-org.atlassian.net/browse/GEOS-10326?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
) viewParams are automatically upper cased for SQL View Layer (
https://osgeo-org.atlassian.net/browse/GEOS-10326?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
)
Issue Type: Bug Affects Versions: 2.18.4 Assignee: Unassigned Created:
08/Dec/21 10:18 AM Priority: Medium Reporter: Tobias Warneke (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A99d6c509-ff9c-4d17-8554-ad6ab816fbe5
)
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.
(
https://osgeo-org.atlassian.net/browse/GEOS-10326#add-comment?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10326#add-comment?atlOrigin=eyJpIjoiYmI4OWZlN2ZmZjliNGE1ZWJkOTM5ODY3NDM1MTg1ZDMiLCJwIjoiaiJ9
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100183-
sha1:f6eba4b )
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel