[Fdo-trac] [fdo-trac] #840: Insert feature fails on table with computed column

FDO trac_fdo at osgeo.org
Tue Jul 10 04:17:20 PDT 2012


#840: Insert feature fails on table with computed column
---------------------------------+------------------------------------------
   Reporter:  gBecker            |       Owner:  danstoica
       Type:  defect             |      Status:  new      
   Priority:  major              |   Milestone:  3.7.0    
  Component:  SQLServer Spatial  |     Version:  3.6.0    
   Severity:  3                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------

Comment(by gBecker):

 Here is the script for creating the table:

 CREATE TABLE [dbo].[Erschliessungen](
         [ID] [int] IDENTITY(1,1) NOT NULL,
         [ObjektID] [int] NOT NULL,
         [StrassenID] [int] NULL,
         [Abschnitt] [int] NULL,
         [Unterabschnitt] [int] NULL,
         [UnterabschnittTeil] [nvarchar](5) NULL,
         [Reinigungsklasse] [int] NULL,
         [Laenge] [float] NOT NULL,
         [Breite] [float] NOT NULL,
         [Reinigung] [bit] NOT NULL,
         [Flaeche]  AS ([laenge]*[breite]) PERSISTED NOT NULL,
         [Aussetzung] [int] NULL,
         [Geometrie] [geometry] NULL,
         [GeaendertAm] [datetime] NOT NULL,
  CONSTRAINT [PK_Erschliessungen] 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]

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/840#comment:1>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list