[JBoss JIRA] (TEIID-3135) Result of query depends on Locale
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-3135?page=com.atlassian.jira.plugin...
]
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)
3764
days inactive
3764
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)