[fdo-trac] #507: SQLServerSpatial: infinite loop when insert to table with trigger.

[FDO]

#507: SQLServerSpatial: infinite loop when insert to table with trigger.
---------------------------------+------------------------------------------
   Reporter:  brentrobinson      |       Owner:  brentrobinson                                                     
       Type:  defect             |      Status:  new                                                               
   Priority:  major              |   Milestone:  3.5.0                                                             
  Component:  SQLServer Spatial  |     Version:  3.5.0                                                             
   Severity:  2                  |    Keywords:  SQL Server 2008 SQLServerSpatial insert trigger hang infinite loop
External_id:                     |  
---------------------------------+------------------------------------------
 An infinite loop occurs in the following situation:

 - datastore has two tables, each with an autoincremented primary key
 column

 - Table A has a trigger that fires on row insertion. The trigger adds a
 row to Table B

 - The SQLServerSpatial provider adds a feature to Table A via FdoIInsert.

 The SQLServerSpatial provider then hangs with an infinite loop in the SQL
 Server driver (below the ODBC interface).

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/507>
FDO <http://fdo.osgeo.org/>
Feature Data Objects