View Issue Details

IDProjectCategoryView StatusLast Update
0007814VALENTINA STUDIOTool - Data Editorpublic2016-11-23 18:27
ReporterSergey PashkovAssigned ToSergey Pashkov 
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version6.6.x 
Target Version6.6.xFixed in Version6.6.x 
Summary0007814: [SQLite] Values of REAL fields are not formatted properly sometimes
DescriptionInsert value 62.48 to the REAL field.
View table in the Data Editor: value is shown like 62.4799999999
Additional InformationThat happens because of the approximation of IEEE floating point numbers.
https://en.wikipedia.org/wiki/IEEE_floating_point

http://valentina-db.com/en/discussions/2544-wrong-amounts-after-csv-import
TagsNo tags attached.
Working with DB:SQLite Local DB
Version of your DB

Activities

Sergey Pashkov

Sergey Pashkov

2016-11-23 18:27

developer   ~0009355

Fixed in 6.6.4

Issue History

Date Modified Username Field Change
2016-11-23 18:24 Sergey Pashkov New Issue
2016-11-23 18:24 Sergey Pashkov Status new => assigned
2016-11-23 18:24 Sergey Pashkov Assigned To => Sergey Pashkov
2016-11-23 18:25 Sergey Pashkov Summary [SQLite] Values of REAL fields is not formatted properly sometimes => [SQLite] Values of REAL fields are not formatted properly sometimes
2016-11-23 18:27 Sergey Pashkov Note Added: 0009355
2016-11-23 18:27 Sergey Pashkov Status assigned => resolved
2016-11-23 18:27 Sergey Pashkov Fixed in Version => 6.6.x
2016-11-23 18:27 Sergey Pashkov Resolution open => fixed