[Fdo-trac] [fdo-trac] #852: Cannot insert features into SQL Server

[FDO]

#852: Cannot insert features into SQL Server
---------------------------------+------------------------------------------
   Reporter:  jng                |       Owner:  danstoica
       Type:  defect             |      Status:  new      
   Priority:  blocker            |   Milestone:  3.7.0    
  Component:  SQLServer Spatial  |     Version:  3.7.0    
   Severity:  1                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------
 There is a showstopping defect in the SQL Server provider that makes it
 impossible to insert features into a SQL Server Feature Source in MapGuide
 in both transactional and non-transactional modes.

 Attached is a simple .net program demonstrating the problem

 The `MapGuideTest` data store is a foreign schema with a table `GeomTest`,
 created with the following DDL:

 {{{

 CREATE TABLE [dbo].[GeomTest](
         [ID] [int] IDENTITY(1,1) NOT NULL,
         [Geom] [geometry] NULL,
  CONSTRAINT [PK_GeomTest] PRIMARY KEY CLUSTERED
 (
         [ID] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY =
 OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY]
 GO
 CREATE SPATIAL INDEX [SPATIAL_GeomTest] ON [dbo].[GeomTest]
 (
         [Geom]
 )USING  GEOMETRY_GRID
 WITH (
 BOUNDING_BOX =(3462000, 5542000, 3486000, 5566000), GRIDS =(LEVEL_1 =
 MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM),
 CELLS_PER_OBJECT = 16, PAD_INDEX  = OFF, SORT_IN_TEMPDB = OFF,
 DROP_EXISTING = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON
 [PRIMARY]

 }}}

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