[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