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.
Note:
See TracTickets
for help on using tickets.