Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2550

parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception

XMLWordPrintable

    • Hide

      Create a new Teiid Meta Model (relational view model). Add a table with Transformation SQL: SELECT parseTimestamp('18:10:20', 'HH:mm:ss'). The transformation editor of the table gives 'ERROR: java.lang.StringIndexOutOfBoundsException: String index out of range: 1'

      Show
      Create a new Teiid Meta Model (relational view model). Add a table with Transformation SQL: SELECT parseTimestamp('18:10:20', 'HH:mm:ss'). The transformation editor of the table gives 'ERROR: java.lang.StringIndexOutOfBoundsException: String index out of range: 1'

      When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error.

      When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result.

        1. ParseTimestamp-Project.png
          ParseTimestamp-Project.png
          183 kB
        2. TestParseTimestamp.tar.gz
          27 kB

              parichar@redhat.com Paul Richardson
              daan-isaac_jira Daan Creemers (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: