[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2782.
----------------------------------
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Windows 7 Enterprise
> Reporter: Matej Kralik
> Assignee: Ted Jones
> Priority: Critical
> Labels: release_notes
> Fix For: 11.1.3
>
> Attachments: XmlStagingProject.zip, endOfFile.mkv
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
[JBoss JIRA] (TEIIDDES-3177) Add relational extension property "sequence" to support FunctionMethod object type in latest Teiid
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3177?page=com.atlassian.jira.plu... ]
Matej Kralik reopened TEIIDDES-3177:
------------------------------------
The value disappears after the new "Function Sequence" property lost focus.
> Add relational extension property "sequence" to support FunctionMethod object type in latest Teiid
> --------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-3177
> URL: https://issues.jboss.org/browse/TEIIDDES-3177
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Extension Framework, Teiid Integration
> Affects Versions: 11.1
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 11.1.2
>
>
> Teiid 10.x translator logic added a new extension property called "sequence" for an object type of FunctionMethod.
> Designer's relational model does not have that object type, so need to add the property to the relational.mxd and add the logic to expose the property of procedure's isFunction == TRUE and import/export that value via -vdb.xml and DDL features.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
[JBoss JIRA] (TEIIDDES-2865) JDBC importer imports MSSQL Server datatype numeric(9, [0-9]) as bigdecimal with zero precision
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2865?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2865:
-----------------------------------
Labels: release_notes (was: )
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2865
> URL: https://issues.jboss.org/browse/TEIIDDES-2865
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0, 9.0.5, 9.0.6, 9.0.7
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Labels: release_notes
> Fix For: 11.1.2
>
> Attachments: debTest2Import.png, debtestImport.png, importedColumns.png
>
>
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly.
> You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds
> user - mss_eds
> password - mss_eds
> table - debtest2, both columns are numeric(9,2)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
[JBoss JIRA] (TEIIDDES-2865) JDBC importer imports MSSQL Server datatype numeric(9, [0-9]) as bigdecimal with zero precision
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2865?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2865.
----------------------------------
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2865
> URL: https://issues.jboss.org/browse/TEIIDDES-2865
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0, 9.0.5, 9.0.6, 9.0.7
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Labels: release_notes
> Fix For: 11.1.2
>
> Attachments: debTest2Import.png, debtestImport.png, importedColumns.png
>
>
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly.
> You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds
> user - mss_eds
> password - mss_eds
> table - debtest2, both columns are numeric(9,2)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years