Bug 1144256
| Summary: | Result of query depends on Locale | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> | ||||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |||||||
| Severity: | unspecified | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.1.0 | CC: | felias, vhalbert | ||||||
| Target Milestone: | ER3 | Keywords: | QA-Closed | ||||||
| Target Release: | 6.1.0 | ||||||||
| Hardware: | x86_64 | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2016-02-10 08:53:40 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Embargoed: | |||||||||
| Attachments: |
|
||||||||
Created attachment 939096 [details]
log for oracle 10
Same query has no problem, if underlying source is file (e.g. *.xlsx). Steven Hawkins <shawkins> updated the status of jira TEIID-3135 to Resolved Steven Hawkins <shawkins> updated the status of jira TEIID-3135 to Closed |
Created attachment 939095 [details] log for mysql 5.5 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 Steps to reproduce: 1. change default locale to sk_SK or cs_CZ (fedora 20: terminal -> export LC_ALL=sk_SK.utf8) 2. start DV server (in same terminal window) 3. connect to some VDB wich is connected to relational DB and run query (at least one column with double value is needed): SELECT <double-value-column> FROM <your-table> WHERE <double-value-column> = -24 4. e.g. VDB with underlying DB mysql 5.5: Exception (root): com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax... 5. e.g. VDB with underlying DB oracle 10: Exception (root): java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis