Opened 11 years ago

Closed 10 years ago

Last modified 10 years ago

#4490 closed defect (fixed)

MSSQL Driver does use respect LAUNDER option when adding fields

Reported by: jpalmer Owned by: tamas
Priority: normal Milestone:
Component: OGR_SF Version: 1.9.2
Severity: normal Keywords: MSSQL
Cc: tamas

Description

When created a layer using the MSSQL2008 driver the table name is laundered but when the fields are added the non laundered table name is used in the ALTER table statement.

i.e ogr2ogr -f MSSQLSpatial "MSSQL:server =localhost;database=test;trusted_connection=yes" test-data.vrt

SQL run:

CREATE TABLE [dbo].[test_data] ([ogr_fid] [int] IDENTITY(1,1) NOT NULL, [ogr_geometry] [geometry] NULL, CONSTRAINT [PK_test_data] PRIMARY KEY CLUSTERED ([ogr_fid] ASC))

ALTER TABLE [dbo].[test-data]] ADD [id] int

Change History (4)

comment:1 by Even Rouault, 11 years ago

Cc: tamas added
Component: defaultOGR_SF

comment:2 by tamas, 11 years ago

Owner: changed from warmerdam to tamas

comment:3 by tamas, 10 years ago

Resolution: fixed
Status: newclosed

Fixed in trunk (r25690) and branch-1.9 (r25689)

comment:4 by tamas, 10 years ago

Version: 1.8.11.9.2
Note: See TracTickets for help on using tickets.