[QGIS-trac] Re: [Quantum GIS] #2010: wrong values inserted on the table

[Quantum GIS]

#2010: wrong values inserted on the table
--------------------------------------------------------------+-------------
        Reporter:  pcav                                       |         Owner:  nobody       
            Type:  bug                                        |        Status:  closed       
        Priority:  critical: causes crash or data corruption  |     Milestone:  Version 1.4.0
       Component:  Data Provider                              |       Version:  HEAD         
      Resolution:  invalid                                    |      Keywords:               
Platform_version:                                             |      Platform:  All          
        Must_fix:  No                                         |   Status_info:  0            
--------------------------------------------------------------+-------------
Changes (by timlinux):

  * status:  new => closed
  * resolution:  => invalid

Comment:

 We believe QGIS is behaving correctly from our tests. For example if you
 enter 1.12 for the last column QGIS stores the value correctly. Numers
 greater than or equal to 10 will have their decimal precision truncated to
 1 place because the field with is 4 and (10 = 2, . = 1, 1 = 1). i.e the
 '.' in the number seems to consume one of the allocated places in the
 number length.

 We are closing this bug as invalid as QGIS seems to be behaving according
 to the constraints of the dbf format.

 {{{
 timlinux at timvaio:/tmp/PUD_STATO_ATTUALE$ dbfdump -h PUD_STATO_ATTUALE.dbf
 Field 0: Type=String, Title=`COD_ISTAT', Width=6, Decimals=0
 Field 1: Type=Integer, Title=`NUM_PROGR', Width=4, Decimals=0
 Field 2: Type=String, Title=`TIPO_CONC', Width=8, Decimals=0
 Field 3: Type=Integer, Title=`TIPO_ATTIV', Width=2, Decimals=0
 Field 4: Type=Integer, Title=`ACCESS_DIS', Width=1, Decimals=0
 Field 5: Type=Double, Title=`FRONTE_MAR', Width=4, Decimals=2
 COD_ISTAT NUM_PROGR TIPO_CONC TIPO_ATTIV ACCESS_DIS FRONTE_MAR
 (NULL)    (NULL)      NUMERO1f  18         2          10.20
 (NULL)    (NULL)      due       11         3          11.30
 (NULL)    (NULL)      NUMERO1f  18         2          10.20
 (NULL)    (NULL)      NUMERO1f  18         2          10.20
 Test        12      test      12         1          1.12
 }}}

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