[teiid-issues] [JBoss JIRA] (TEIID-3135) Result of query depends on Locale

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3135.
-----------------------------------
    Fix Version/s: 8.7.1
                   8.9
       Resolution: Done


Updated the logic to test the value based upon the absolute value and use the us locale for the formatting.

This does bring up an issue that the format is not generally what you want for approximate numeric literals and any platform that supports scientific notation we should use the scientific notation literal instead.  For now only the Teiid source was updated to support scientific notation, but this should be checked for the other sources as well.

> Result of query depends on Locale
> ---------------------------------
>
>                 Key: TEIID-3135
>                 URL: https://issues.jboss.org/browse/TEIID-3135
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7
>         Environment: OS: fedora 20
> arch: x86_64
> java: sun 1.7, openjdk 1.7
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 8.7.1, 8.9
>
>
> Description: Some kind of queries ends with SQL syntax error (or incorrect result) because of real numbers are translated to locale-specific-string (e.g. -24 => -24,0 for sk_SK locale).
> Testing environment:
> a) Locale: sk_SK (Slovakia), cs_CZ(Czech)
> b) OS: fedora 20
> c) arch: x86_64
> d) java: sun 1.7, openJDK_1.7



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)