Opened 15 years ago

Closed 15 years ago

#583 closed defect (fixed)

SQLServerSpatial: Prevent adding system columns to existing tables

Reported by: brentrobinson Owned by: brentrobinson
Priority: minor Milestone: 3.5.0
Component: FDO API Version: 3.4.0
Severity: 3 Keywords: SQLServerSpatial Apply Schema existing table
Cc: External ID:

Description

Steps to reproduce:

  • create a SQLServer 2008 datastore. Must be FDO-enabled.
  • using the attached sql script, create a table in the datastore.
  • using the attached FDO API code, load the attached XML file and apply its feature schema and schema mappings. The ApplySchema fails with the following errors:

Schema Schema has errors; cannot apply it Cannot add column revisionnumber to table test23.Schema.Roads; this RDBMS does not support adding not-null columns Cannot add column classid to table test23.Schema.Roads; this RDBMS does not support adding not-null columns

Attachments (3)

Road.cpp​ (904 bytes ) - added by brentrobinson 15 years ago.
Road.sql​ (915 bytes ) - added by brentrobinson 15 years ago.
Road.xml​ (7.3 KB ) - added by brentrobinson 15 years ago.

Download all attachments as: .zip

Change History (6)

by brentrobinson, 15 years ago

Attachment: Road.cpp​ added

by brentrobinson, 15 years ago

Attachment: Road.sql​ added

by brentrobinson, 15 years ago

Attachment: Road.xml​ added

comment:1 by brentrobinson, 15 years ago

Status: new → assigned

comment:2 by brentrobinson, 15 years ago

Revision: 5069 Author: brentrobinson Date: 9:29:14 AM, Wednesday, November 11, 2009 Message: Ticket#583: Modified ApplySchema to skip adding system columns to existing tables, since the user did not explicitly ask for them.

Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoApplySchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_foreign1_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_foreign2_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_foreign_out1_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_foreign_out2_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_overrides3_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_overrides_out1_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_overrides_out2_master.txt Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/SimplePropertyDefinition.cpp

comment:3 by brentrobinson, 15 years ago

Resolution: → fixed
Status: assigned → closed
Note: See TracTickets for help on using tickets.