[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:comment-tabpanel&focusedCommentId=13004280#comment-13004280 ] 

Steven Hawkins commented on TEIID-3135:
---------------------------------------

There is logic in the literal handling that looks to see if the double value is out of some bounds and instead uses formatting - which is localized.  This does not look correct as it does not account for negative values and does not account for the locale.  It will not occur with positive values greater that .001 and less that 10^7.  

> 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
>
> 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)