[Geoserver-devel] [JIRA] (GEOS-9507) Geoserver wrapes column and table names in quotes while sending SQL queries

_Failed_to_Retrieve · February 19, 2020, 9:39am

Feofilakt created an issue

Geoserver wrapes column and table names in quotes while sending SQL queries

Issue Type:	Bug
Affects Versions:	2.15.0
Assignee:	Unassigned
Created:	19/Feb/20 10:39 AM
Priority:	Medium
Reporter:	Feofilakt

Geoserver wrapes column and table names in quotes when sending SQL queries. It is unexpected behavior because DBMS may treated this situation in a special way.

For example, WFS-T transaction:

	&lt;wfs:Insert&gt;
		&lt;feature:LOG xmlns:feature="http://www.opengeospatial.net/blabla"&gt;
			&lt;feature:user_name&gt;name1&lt;/feature:user_name&gt;
			...
		&lt;/feature:LOG&gt;
	&lt;/wfs:Insert&gt;

and part of generated SQL query:
INSERT INTO "blabla"."blabla" ( "user_name", ...) VALUES ( $1, ...)

must be:
INSERT INTO blabla.blabla ( user_name, ...) VALUES ( $1, ...)

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#100121-sha1:96a3924)