[QGIS-trac] Re: [Quantum GIS] #3857: Shapefile cannot be saved if joined table contains field names longer than 10 characters

[Quantum GIS]

#3857: Shapefile cannot be saved if joined table contains field names longer than
10 characters
-------------------------------------+--------------------------------------
   Reporter:  bnotter                |              Owner:               
       Type:  bug                    |             Status:  new          
   Priority:  minor: annoyance       |          Milestone:  Version 1.7.0
  Component:  Vectors                |            Version:  Trunk        
   Keywords:  table join, shapefile  |   Platform_version:  Ubuntu 10.10 
   Platform:  Linux                  |           Must_fix:  No           
Status_info:  0                      |  
-------------------------------------+--------------------------------------
Changes (by bnotter):

  * priority:  major: does not work as expected => minor: annoyance


Comment:

 Sorry, my observation on this bug was not correct:

 The problem is not, as described above, that too long field names are not
 truncated, but that if they are truncated, they may not be unique anymore.
 This in itself is not a bug but expected behavior.

 However, what could be expected is that if tables are joined, the
 resulting combined attribute table would not contain both the join field
 in the joined table AND the target field in the layer it is joined to, but
 only one of them (since both contain the same information anyway). Because
 often, the join field and the target field are named the same. If that is
 the case, the resulting combined attribute table cannot be exported, and
 this will force the user to rename one of the fields and set up the join
 afresh.

 I would therefore propose to only keep the target field in the resulting
 combined table in order to avoid this problem.

 I'm also changing the priority of this bug down to "minor: annoyance".

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/3857#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS supporting GDAL/OGR, PostGIS, and GRASS formats, and Web Services