[kexi] [Bug 352363] New: Broken floating-point constants in queries

[Jarosław Staniek]

https://bugs.kde.org/show_bug.cgi?id=352363

            Bug ID: 352363
           Summary: Broken floating-point constants in queries
           Product: kexi
           Version: 2.9.7
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Queries
          Assignee: kexi-bugs at kde.org
          Reporter: staniek at kde.org
                CC: adam at piggz.co.uk, inksi at fables.co.za

Floating-point constants are not correctly parser in the SQL view of the Kexi
query designer.
Fractional part is parser as integer without remembering the leading zeros.

Example:
- 1.2 is parsed as a pair of integers: (1, 2). This is OK.
- 1.002 is parsed as a pair of integers: (1, 2). This is not OK since the value
decoded back to floating point is: 1.2.


Reproducible: Always

Steps to Reproduce:
1. Open a new query design and type "SELECT 1.002" in the SQL view
2. Go to the data view

Actual Results:  
1.2 is displayed

Expected Results:  
1.002 is displayed

A workaround for Kexi <= 2.9.7 is: use the following notation e.g. for 1.002
constant: 1002/1000.

The bug is driver-independent.

-- 
You are receiving this mail because:
You are the assignee for the bug.