Opened 12 years ago

Closed 7 years ago

#840 closed defect (fixed)

Insert feature fails on table with computed column

Reported by: gBecker Owned by: danstoica
Priority: major Milestone: 3.7.0
Component: SQLServer Spatial Version: 3.6.0
Severity: 3 Keywords:
Cc: External ID:

Description

When trying to insert a feature into a table with a computed column the insertion fails because this column/property must have been "NOT NULL".

I also tried to set a dummy value for this column but this fails, too, because computed columns couldn't be set.

So, my conclusion is that this must be a failure. I would have supposed that the property for the computed column must be marked as ReadOnly, but it wasn't. ReadOnly attribute was set to "false".

Change History (2)

comment:1 by gBecker, 12 years ago

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]

comment:2 by jng, 7 years ago

Resolution: fixed
Status: newclosed

Considering this fixed due to fix for #920

Note: See TracTickets for help on using tickets.