Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3135

Result of query depends on Locale

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7.1, 8.9
    • 8.7
    • None
    • None
    • Hide

      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

      Show
      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

    Description

      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

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: