[
https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu...
]
Paul Richardson commented on TEIIDDES-2550:
-------------------------------------------
Hey [~daan-isaac],
I have attached a project created in Designer to try and replicate your problem. However,
when I open the Transformation Editor of the table in the view, the SQL parses
sucessfully. Can you try it on your system and confirm there is an issue. If not, can you
provide a project in a similar fashion that does replicate the error please.
Thanks.
parseTimestamp function in Transformation Editor gives
StringIndexOutOfBounds Exception
---------------------------------------------------------------------------------------
Key: TEIIDDES-2550
URL:
https://issues.jboss.org/browse/TEIIDDES-2550
Project: Teiid Designer
Issue Type: Bug
Components: Modeling, Transformations
Affects Versions: 9.1
Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1
Reporter: Daan Creemers
Assignee: Paul Richardson
Fix For: 9.2, 9.0.3
Attachments: TestParseTimestamp.tar.gz
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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)