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

parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: