December 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3136) PK's are not imported from JDBC source when import FK's is turned off

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3136?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3136. ---------------------------------- Resolution: Done > PK's are not imported from JDBC source when import FK's is turned off > ---------------------------------------------------------------------- > > Key: TEIIDDES-3136 > URL: https://issues.jboss.org/browse/TEIIDDES-3136 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1.1 > > > If Import FK's is turned OFF (unchecked) then PK's are not imported as part of the table schema. > RelationalModelProcessorImpl.createPrimaryKey() method is checking for includeFKs & includeInexes options and returning if both are false. Need to remove this check and let PK's be imported either way. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3136) PK's are not imported from JDBC source when import FK's is turned off

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3136?page=com.atlassian.jira.plu... ] Matej Kralik reopened TEIIDDES-3136: ------------------------------------ > PK's are not imported from JDBC source when import FK's is turned off > ---------------------------------------------------------------------- > > Key: TEIIDDES-3136 > URL: https://issues.jboss.org/browse/TEIIDDES-3136 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1.1 > > > If Import FK's is turned OFF (unchecked) then PK's are not imported as part of the table schema. > RelationalModelProcessorImpl.createPrimaryKey() method is checking for includeFKs & includeInexes options and returning if both are false. Need to remove this check and let PK's be imported either way. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 3 months

1
0
0 / 0

[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: ----------------------------------- Attachment: debTest2Import.png debtestImport.png importedColumns.png > 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 > Fix For: 11.1, 11.1.1 > > 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)

8 years, 3 months

1
0
0 / 0

[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 reopened TEIIDDES-2865: ------------------------------------ Imported columns have set the value of the numeric precision same as the value of the length (importedColumns.png) but numeric precision and length of the column are different values. In the JDBC importer, the values column_size and decimal_digits are different. >From example: debtest1 (debTestImport.png) coulmn id - column_size: 18 - decimal_digits: 0 column bigdecimalvalue - column_size: 9 - decimal_digits: 0 debtest2 (debTest2Import.png) coulmn id - columnSize: 9 - decimal_digits: 2 column bigdecimalvalue - columnSize: 9 - decimal_digits: 2 I used DB from the description. In my point of view, the precision value should be set according to decimal_digits. > 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 > Fix For: 11.1, 11.1.1 > > 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)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2493) Check for spaces in the parent directory Flat File connection importer

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2493?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2493: ----------------------------------- Labels: release_notes (was: ) > Check for spaces in the parent directory Flat File connection importer > ---------------------------------------------------------------------- > > Key: TEIIDDES-2493 > URL: https://issues.jboss.org/browse/TEIIDDES-2493 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1, 11.1.1 > > Attachments: screenshot.png > > > Add a check to make sure there are no spaces in the ParentDirectory or root directory path when Flat File Connection Profile is chosen. > ==================== > The problem is manifested on the server when attempting to query the datasource. On datasource creation, the resource adapter is written to the standalone.xml like this. > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} > The embedded space in the ParentDirectory property value is problematic. > Need to determine whether to (1) disallow a path with spaces or (2) allow it, replacing the space with the appropriate control code ie {code:java} {code} - like this > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2493) Check for spaces in the parent directory Flat File connection importer

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2493?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2493. ---------------------------------- > Check for spaces in the parent directory Flat File connection importer > ---------------------------------------------------------------------- > > Key: TEIIDDES-2493 > URL: https://issues.jboss.org/browse/TEIIDDES-2493 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1, 11.1.1 > > Attachments: screenshot.png > > > Add a check to make sure there are no spaces in the ParentDirectory or root directory path when Flat File Connection Profile is chosen. > ==================== > The problem is manifested on the server when attempting to query the datasource. On datasource creation, the resource adapter is written to the standalone.xml like this. > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} > The embedded space in the ParentDirectory property value is problematic. > Need to determine whether to (1) disallow a path with spaces or (2) allow it, replacing the space with the appropriate control code ie {code:java} {code} - like this > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3135) The System Catalog is out of date with the System tables exposed in a VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3135?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3135. ---------------------------------- Resolution: Done > The System Catalog is out of date with the System tables exposed in a VDB > ------------------------------------------------------------------------- > > Key: TEIIDDES-3135 > URL: https://issues.jboss.org/browse/TEIIDDES-3135 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1.1 > > > The System Catalog in Teiid Designer is out-of-date with the System tables exposed via a VDB. Example is the Sysadmin.usage table. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3135) The System Catalog is out of date with the System tables exposed in a VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3135?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-3135: ----------------------------------- Labels: release_notes (was: ) > The System Catalog is out of date with the System tables exposed in a VDB > ------------------------------------------------------------------------- > > Key: TEIIDDES-3135 > URL: https://issues.jboss.org/browse/TEIIDDES-3135 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1.1 > > > The System Catalog in Teiid Designer is out-of-date with the System tables exposed via a VDB. Example is the Sysadmin.usage table. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3135) The System Catalog is out of date with the System tables exposed in a VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3135?page=com.atlassian.jira.plu... ] Matej Kralik reopened TEIIDDES-3135: ------------------------------------ > The System Catalog is out of date with the System tables exposed in a VDB > ------------------------------------------------------------------------- > > Key: TEIIDDES-3135 > URL: https://issues.jboss.org/browse/TEIIDDES-3135 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1.1 > > > The System Catalog in Teiid Designer is out-of-date with the System tables exposed via a VDB. Example is the Sysadmin.usage table. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3135) The System Catalog is out of date with the System tables exposed in a VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3135?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3135. ---------------------------------- > The System Catalog is out of date with the System tables exposed in a VDB > ------------------------------------------------------------------------- > > Key: TEIIDDES-3135 > URL: https://issues.jboss.org/browse/TEIIDDES-3135 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.1.1 > > > The System Catalog in Teiid Designer is out-of-date with the System tables exposed via a VDB. Example is the Sysadmin.usage table. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2017