[fdo][FDO114][New] SqlServer: Fix 810181.01 Update geometry causes error (port ...

[Gavin Cramer]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO114

Type
 Task

Artifact ID
 FDO114 (SqlServer: Fix 810181.01 Update geometry causes error (port R066-GC1))

Reported by
 Gavin Cramer
 gavincramer (gavin.cramer at autodesk.com)

New artifact details:
---------------------------------------------------------

- Summary set to new value
  SqlServer: Fix 810181.01 Update geometry causes error (port R066-GC1)
- Artifact Status set to new value
  New
- Artifact created
- Description set to new value
  This makes sure that both spatial index columns are bound during an Update 
command.  Depending on the geometry value, SI entries may have either one or two 
key values; the second bind (to NULL) wasn't happening if there was only one 
value.

This also fixes an previously undetected defect in the handling of FeatId 
columns when the table's primary key doesn't include FeatId.  This can affect any of the FDO Rdbms providers.  Some internal 
logic was always adding the FeatId to the property value list, even when it 
wasn't part of the Update SQL statement.  The only unit test of this situation 
happened to always use single-SI geometry values, so the targetted geometry 
defect covered up the FeatId defect.  We were actually getting string-ified 
feature numbers in SI columns that were supposed to be NULL, which could explain 
some extra features being observed in certain primary spatial queries in the 
past.  The FeatId logic was changed to only bind FeatId if it is a primary key.
- Task Priority set to new value
  Medium

---------------------------------------------------------
This message was automatically generated by Project Tracker.