Opened 13 years ago

#3914 new defect

Problems using a TAB in the DATA configuration clause

Reported by: geographika Owned by: hobu
Priority: normal Milestone:
Component: Input - Native MS SQL Server Support Version: 5.6
Severity: normal Keywords: tab data mssql
Cc:

Description

When using a subselect clause such as the following:

DATA "GEOM FROM (SELECT myid, geom FROM table) tbl USING UNIQUE myid USING SRID=4326"

If there is a tab character anywhere following tbl then any text after the tab is ignored. This causes errors such as

Query error. No primary key defined for table, or primary key contains more that one column

as the unique field is ignored. If a tab is placed before the USING SRID=4326 then the projection is ignored which can lead to a blank map.

Tabs were added using Notepad on Windows.

Change History (0)

Note: See TracTickets for help on using tickets.