[QGIS-trac] Re: [Quantum GIS] #2410: field calculator results may violate spatialite type contraints

[Quantum GIS]

#2410: field calculator results may violate spatialite type contraints
-------------------------------------+--------------------------------------
        Reporter:  anitagraser       |         Owner:  nobody             
            Type:  bug               |        Status:  new                
        Priority:  minor: annoyance  |     Milestone:  Version 1.5.0      
       Component:  GUI               |       Version:  HEAD               
      Resolution:                    |      Keywords:  spatialite, editing
Platform_version:                    |      Platform:  All                
        Must_fix:  No                |   Status_info:  1                  
-------------------------------------+--------------------------------------
Changes (by lutra):

 * cc: esseffe (added)

Comment:

 A few notes (tested on both linux and xp with qgis trunk and the
 spatialite sample dataset):

 *) add a spatialite vector, open attributes properties and add a column.
 Save changes. If you open the attribute table the new column do not show
 (not even in the field calculator). You need to remove the layer and add
 it again to see the new column (and be able to populate it).

 *) as consequence if you add spatialite layer, toggle editing, open the
 field calculator and try to populate a new column, qgis will fail


 {{{
 Could not commit changes to layer Towns

 Errors: SUCCESS: 1 attribute(s) added.
   ERROR: 8101 attribute value change(s) not applied.
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2410#comment:3>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats