SQL server error when executing a WFST insert request in a table with a GENERATED ALWAYS column
Description
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:
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
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: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