[JBoss JIRA] (TEIIDDES-2548) xml encoding/decoding destroys a sql query for Transformation in a view model
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2548?page=com.atlassian.jira.plu... ]
Andrej Šmigala closed TEIIDDES-2548.
------------------------------------
> xml encoding/decoding destroys a sql query for Transformation in a view model
> ------------------------------------------------------------------------------
>
> Key: TEIIDDES-2548
> URL: https://issues.jboss.org/browse/TEIIDDES-2548
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors
> Affects Versions: 9.0.1, 9.1, 9.0.2
> Environment: JBDS 8.1.0
> Reporter: hisao furuichi
> Assignee: Paul Richardson
> Labels: release_notes, verified_jbdsis-8.0.3.CR1
> Fix For: 9.1, 9.0.3
>
>
> In a sql query for transformation in a view model, If user writes "ESCAPE '\u0000'" and save it, it will saved as "ESCAPE '�'" and can not open the view model anymore with parse exception.
> The reason why user wants to set "ESCAPE '\u0000' is a workaround for this jira ticket, TEIIDDES-2217.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ]
Andrej Šmigala commented on TEIIDDES-2550:
------------------------------------------
Removed fix version 9.0.3 as this issue is reported with Teiid Designer 9.1
> 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
>
> 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)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2550:
-------------------------------------
Fix Version/s: (was: 9.0.3)
> 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
>
> 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)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2552) REST connection profile wizard creates URL with parameters in wrong order
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2552?page=com.atlassian.jira.plu... ]
Andrej Šmigala reopened TEIIDDES-2552:
--------------------------------------
While it is now possible to move the parameters into the correct order using the up and down buttons, it should not be required, since it makes no sense to have URI parameters after query parameters. Designer should automatically add any new URI parameters before any existing query parameters.
> REST connection profile wizard creates URL with parameters in wrong order
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2552
> URL: https://issues.jboss.org/browse/TEIIDDES-2552
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 9.0.3, 9.2
>
> Attachments: Newconnectionprofile_001.png
>
>
> When defining parameters for REST connection profile, they are added to the URL in the order they are defined. This results in wrong URL in case a Query parameter is defined before a URI parameter.
> The URI parameters should always be added to the URL before the Query parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2553) Changing parameter types in REST connection results in wrong URL
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2553?page=com.atlassian.jira.plu... ]
Andrej Šmigala closed TEIIDDES-2553.
------------------------------------
> Changing parameter types in REST connection results in wrong URL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2553
> URL: https://issues.jboss.org/browse/TEIIDDES-2553
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Labels: releaase_notes, verified_jbdsis-8.0.3.CR1
> Fix For: 9.0.3, 9.2
>
>
> Changing the type of a parameter in the REST connection profile causes the generated URL to be wrong. Also, the Preview URL is not updated after changing the type, only after some other action (testing connection, changing the default value etc).
> Furthermore, removing the paramters does not work if the type of the parameter has been changed.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 9 months