Opened 13 years ago

Closed 5 years ago

#1391 closed defect (wontfix)

dbf driver: implicit duplicate column names

Reported by: mmetz Owned by: grass-dev@…
Priority: normal Milestone: 7.0.7
Component: Database Version: svn-releasebranch64
Keywords: dbf driver Cc:
CPU: All Platform: All

Description

The dbf driver in lib/external/shapelib limits the length of column names to 10 characters. Longer names are silently truncated to 10 characters without checking for duplicates. The dbf driver in db/drivers/dbf limits the length of column names to 20 characters and passes these too long names to lib/external/shapelib. This limit should be changed to 10 characters, otherwise column names longer than 10 characters with the first 10 characters being identical will result in identical column names in the dbf file. These identical column names create all sorts of (cryptic) problems, unfortunately without any warning or error.

It may be necessary to add routines to create unambiguous column names, or at least suggest alternative names to the user, e.g. as cnames option for v.in.ogr. Currently, add_column() in db/drivers/dbf/column.c will fail in case of duplicate column names with an error message but not a fatal error.

Change History (4)

comment:1 by martinl, 8 years ago

Milestone: 7.0.07.0.5

comment:2 by neteler, 8 years ago

Milestone: 7.0.57.0.6

comment:3 by neteler, 6 years ago

Milestone: 7.0.67.0.7

comment:4 by martinl, 5 years ago

Resolution: wontfix
Status: newclosed
Note: See TracTickets for help on using tickets.