Opened 6 years ago

Closed 6 years ago

#5930 closed defect (fixed)

MS SQL Spatial provider doesn't include geometry column name in Update statement

Reported by: sleschinski Owned by: tamas
Priority: normal Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: mssql
Cc: tamas

Description

According to my testing OGRLayer::SetFeature? call with MS SQL Spatial provider results in the update statement without geometry column:

UPDATE [dbo].[waterways] SET geometry::STGeomFromWKB...

Which perhaps should be something like this instead:

UPDATE [dbo].[waterways] SET [ogr_geometry] = geometry::STGeomFromWKB...

I also checked the source. It may be related to line 924 in ogrmssqlspatialtablelayer.cpp in this commit: https://github.com/OSGeo/gdal/commit/1d4b8cdbf5a35d97fd450cec87f43973b6e4fa8e

Change History (4)

comment:1 Changed 6 years ago by Even Rouault

Cc: tamas added
Component: defaultOGR_SF
Keywords: mssql added

comment:2 Changed 6 years ago by tamas

Owner: changed from warmerdam to tamas

comment:3 Changed 6 years ago by tamas

Fixed in r28981

comment:4 Changed 6 years ago by tamas

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.