February 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2063) Is there a way to provide option to change views when source data type is changed

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2063: ------------------------------------- Summary: Is there a way to provide option to change views when source data type is changed Key: TEIIDDES-2063 URL: https://issues.jboss.org/browse/TEIIDDES-2063 Project: Teiid Designer Issue Type: Feature Request Components: Modeling Affects Versions: 8.3.1 Reporter: Van Halbert Also at issue is when a data source column type needs to be changed in the source model, but the views also need to be changed. Is there a way to replicate the change upstream (so to speak) to all the dependent views? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2061: ------------------------------------------ Sorry to be pedantic, but everyone needs to make sure to not just say char, int, etc., but to be specific as to the domain in which the data type term is applicable. > If we're converting from char[n] to String, I thought that was the solution to NOT truncate. Just to clarify, we're saying that the importer will import a database char[n] where n is != 1 to a Teiid String, which is not typically truncated (but may be in some situations with long string values). > So why a rule to say it will be truncated. His intent is likely to highlight a modeling error with using a Teiid char possibly introduced by this bug or unintentionally by the user. > Can there also be a rule put in place in designer such that if char data type is used, that length cannot be changed from 1? That would also help. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2062) ResourceException validing resource when other project recently closed

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2062: -------------------------------------- Summary: ResourceException validing resource when other project recently closed Key: TEIIDDES-2062 URL: https://issues.jboss.org/browse/TEIIDDES-2062 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 8.3.1 Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 8.4, 8.3.2 After closing a project, performed some imports, deleting objects etc. which forced validation. Received the following: {code} !ENTRY org.teiid.designer.core 4 0 2014-02-19 15:34:53.593 !MESSAGE Resource '/ImportTest' is not open. !STACK 1 org.eclipse.core.internal.resources.ResourceException: Resource '/ImportTest' is not open. at org.eclipse.core.internal.resources.Project.checkAccessible(Project.java:150) at org.eclipse.core.internal.resources.Resource.accept(Resource.java:62) at org.eclipse.core.internal.resources.Resource.accept(Resource.java:52) at org.eclipse.core.internal.resources.Resource.accept(Resource.java:124) at org.eclipse.core.internal.resources.Resource.accept(Resource.java:108) at org.teiid.designer.core.workspace.ModelWorkspaceImpl.getModelResources(ModelWorkspaceImpl.java:461) at org.teiid.designer.core.workspace.ModelWorkspaceImpl.getEmfResources(ModelWorkspaceImpl.java:479) at org.teiid.designer.core.builder.ModelBuildUtil.getWorkspaceResourcesInScope(ModelBuildUtil.java:286) at org.teiid.designer.core.builder.ModelBuildUtil.validateResources(ModelBuildUtil.java:703) {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2061: --------------------------------------- Can there also be a rule put in place in designer such that if char data type is used, that length cannot be changed from 1? > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2061: --------------------------------------- I'm confused by the 2 statements. If we're converting from char[n] to String, I thought that was the solution to NOT truncate. So why a rule to say it will be truncated. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2061 at 2/19/14 4:12 PM: ----------------------------------------------------------------- So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *The Teiid runtime datatype char only recognizes a length of 1. Any additional characters will be truncated. Suggest changing datatype to string.* was (Author: blafond): So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *The Teiid runtime datatype for char only recognizes a length of 1. Any additional characters will be truncated.Suggest changing datatype to string.* > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2061: ------------------------------------------ Barry, your warning above should read - "the Teiid runtime datatype char" not "the Teiid runtime datatype for char" The Teiid char type was never intended to represent the database char type. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2061 at 2/19/14 4:05 PM: ----------------------------------------------------------------- So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *the Teiid runtime datatype for char only recognizes a length one. Additional characters will be truncated.Suggest changing datatype to string.* was (Author: blafond): So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2061 at 2/19/14 4:06 PM: ----------------------------------------------------------------- So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *The Teiid runtime datatype for char only recognizes a length of 1. Any additional characters will be truncated.Suggest changing datatype to string.* was (Author: blafond): So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *the Teiid runtime datatype for char only recognizes a length one. Additional characters will be truncated.Suggest changing datatype to string.* > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2061) char[n+] field is truncated by importer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2061: ------------------------------------------ Van, what resolution are you looking for beyond Barry's last comment or my slight clarification? > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: testErrors.vdb > > > truncation of Char[>1] fields to one character. > reproduction with simple VDB (to be attached): > SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR"; > the "asChar" field only returns a "C" and the asVarChar returns the complete value. > That is the expected behavior, per the Data Virtualization Reference Manual, char datatype is a single Unicode character (java.lang.Character). However, the importer may need to check for the occurrence of char[n+] and not assume char[1]. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

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 February 2014