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