[Geoserver-devel] [JIRA] (GEOS-10791) SQL server error when executing a WFST insert request in a table with a GENERATED ALWAYS column

GeoServer GeoServer Developer
1

Rob Egelmeer created an issue

GeoServer / BugGEOS-10791

SQL server error when executing a WFST insert request in a table with a GENERATED ALWAYS column

Issue Type:

BugBug

Affects Versions:

2.21.2

Assignee:

Unassigned

Attachments:

WFST_insert_error.txt

Components:

SQLServer

Created:

13/Dec/22 4:40 PM

Priority:

MediumMedium

Reporter:

Rob Egelmeer

Preforming a WFST insert request in a SQL server table with temporal tables does not work. The insert query tries to insert a value into a generated always column.

In the attachment there is a part of the geotools logging with the insert query and the SQL server exception. This is the WFST request I made:

<wfs:Transaction
xmlns:muteren=“muteren” service=“WFS” version=“1.0.0”
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc=“http://www.opengis.net/ogc"
xmlns:gml=“http://www.opengis.net/gml"
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation=“http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd" >
[wfs:Insert|wfs:Insert]
[muteren:invoer_od_geografische_locatie|muteren:invoer_od_geografische_locatie]
<referentie>test</referentie>
<maand>Januari</maand>
<jaar>3333</jaar>
<historisch>N</historisch>
<gebruiker>robe</gebruiker>
<created_at>2022-12-13</created_at>
<updated_at>2022-12-13</updated_at>
<geom>
<gml:Polygon srsName=“http://www.opengis.net/gml/srs/epsg.xml#28992">
[gml:outerBoundaryIs|gml:outerBoundaryIs]
[gml:LinearRing|gml:LinearRing]
<gml:coordinates decimal=”.” cs=”,” ts=” ">98283.68,508144.8 98206.4,508003.68 98428.16,508107.84 98283.68,508144.8</gml:coordinates>
</gml:LinearRing>
</gml:outerBoundaryIs>
</gml:Polygon>
</geom>
</muteren:invoer_od_geografische_locatie>
</wfs:Insert>
</wfs:Transaction>

More informatie about the temporal tables in SQL server can be found on this page:

[Temporal Tables - SQL Server | Microsoft Learn|https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver16&amp;viewFallbackFrom=sql-server-ver16 ]

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#100212-sha1:99773b8)

Atlassian logo