February 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2014) 8.4 Release Work

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2014?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2014 at 2/20/14 3:09 PM: ----------------------------------------------------------------- New Features: TEIIDDES-1863 - native type property to procedure *OUT* parameters TEIIDDES-1794 - ability to define virtual table as *global temporary table* FIXES Targetted for 8.3.2 TEIIDDES-1613 : *Not yet started work....* TEIIDDES-1808 : https://github.com/Teiid-Designer/teiid-designer/commit/425a85df5f889e274... TEIIDDES-1904 : *Not yet started work....* TEIIDDES-1961 : https://github.com/Teiid-Designer/teiid-designer/commit/72e12001cc89bbe9c... https://github.com/Teiid-Designer/teiid-designer/commit/cf926a257b4af974b... TEIIDDES-1990 : https://github.com/Teiid-Designer/teiid-designer/commit/679bf850c72d76976... TEIIDDES-2036 : *Not yet fixed, but simple update to build.properties in teiid client plugins* TEIIDDES-2040 : https://github.com/Teiid-Designer/teiid-designer/commit/cde60c57fed0d1ee2... TEIIDDES-2042 : https://github.com/Teiid-Designer/teiid-designer/commit/2970f241548c7f9f4... TEIIDDES-2045 : https://github.com/Teiid-Designer/teiid-designer/commit/e2f895d76ea8a22a7... TEIIDDES-2053 : https://github.com/Teiid-Designer/teiid-designer/commit/13487fae7c9e7a2f2... TEIIDDES-2055: https://github.com/Teiid-Designer/teiid-designer/commit/1893d980e37c531b2... was (Author: blafond): New Features: TEIIDDES-1863 - native type property to procedure *OUT* parameters TEIIDDES-1794 - ability to define virtual table as *global temporary table* FIXES Targetted for 8.3.2 TEIIDDES-1613 : *Not yet started work....* TEIIDDES-1808 : https://github.com/Teiid-Designer/teiid-designer/commit/425a85df5f889e274... TEIIDDES-1904 : *Not yet started work....* TEIIDDES-1961 : https://github.com/Teiid-Designer/teiid-designer/commit/72e12001cc89bbe9c... https://github.com/Teiid-Designer/teiid-designer/commit/cf926a257b4af974b... TEIIDDES-1990 : https://github.com/Teiid-Designer/teiid-designer/commit/679bf850c72d76976... TEIIDDES-2036 : *Not yet fixed, but simple update to build.properties in teiid client plugins* TEIIDDES-2040 : https://github.com/Teiid-Designer/teiid-designer/commit/cde60c57fed0d1ee2... TEIIDDES-2042 : https://github.com/Teiid-Designer/teiid-designer/commit/2970f241548c7f9f4... TEIIDDES-2045 : https://github.com/Teiid-Designer/teiid-designer/commit/e2f895d76ea8a22a7... TEIIDDES-2053 : https://github.com/Teiid-Designer/teiid-designer/commit/13487fae7c9e7a2f2... > 8.4 Release Work > ---------------- > > Key: TEIIDDES-2014 > URL: https://issues.jboss.org/browse/TEIIDDES-2014 > Project: Teiid Designer > Issue Type: Task > Components: Release Work > Affects Versions: 8.4 > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Blocker > Fix For: 8.4 > > > Work related to 8.4.0 release including: > * Version upgrades > * Copyright changes > * build/publish > * documentation -- 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-2055) HTTP 406 Importing Generated REST Service as Source

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2055?page=com.atlassian.jira.plu... ] Ted Jones updated TEIIDDES-2055: -------------------------------- Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/pull/292 > HTTP 406 Importing Generated REST Service as Source > --------------------------------------------------- > > Key: TEIIDDES-2055 > URL: https://issues.jboss.org/browse/TEIIDDES-2055 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 8.3.1 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.4, 8.3.2 > > Attachments: ws-rest-connection-profile-properties-editor.png, ws-rest-connection-profile-wizard.png > > > I generated a REST service from Designer and then tried to use as a source. I received a 406 (Not acceptable) error. -- 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-2055) HTTP 406 Importing Generated REST Service as Source

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2055?page=com.atlassian.jira.plu... ] Ted Jones resolved TEIIDDES-2055. --------------------------------- Resolution: Done > HTTP 406 Importing Generated REST Service as Source > --------------------------------------------------- > > Key: TEIIDDES-2055 > URL: https://issues.jboss.org/browse/TEIIDDES-2055 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 8.3.1 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.4, 8.3.2 > > Attachments: ws-rest-connection-profile-properties-editor.png, ws-rest-connection-profile-wizard.png > > > I generated a REST service from Designer and then tried to use as a source. I received a 406 (Not acceptable) error. -- 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: --------------------------------------- The char issue at the translator level has been moved to TEIID-2858 > 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: char-length-property-change-warning.png, 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: --------------------------------------- Because of the convert(x,x) issue, I would think there needs to be a solution in the translator such that if it can be detected that its for a char column and that it does not do the convert. Otherwise, the convert will negate the use of an index. > 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: char-length-property-change-warning.png, 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)

[ https://issues.jboss.org/browse/TEIIDDES-2062?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2062. ------------------------------------ Resolution: Done Done: https://github.com/Teiid-Designer/teiid-designer/commit/bb957d091ca126dd3... > 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 Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2061: ---------------------------------------- First commit: https://github.com/Teiid-Designer/teiid-designer/commit/0ebc3dc0d17d15db9... > 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: char-length-property-change-warning.png, 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 updated TEIIDDES-2061: ----------------------------------- Attachment: char-length-property-change-warning.png Now catching and cancelling the property change if length == 1 for char and logging a Warning message shone in attachment > 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: char-length-property-change-warning.png, 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 Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Debbie Steigner commented on TEIIDDES-2061: ------------------------------------------- Also from customer WIth the most recent change I now have a query that doesn't work unless I TRIM the field (because criteria does not match without including the trailing spaces) > 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 Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Debbie Steigner commented on TEIIDDES-2061: ------------------------------------------- Pasting comments from the customer on the case regarding setting it to string: For an experiment I changed the physical datatype to string and reconciled the view model. I then execuated a query against view model then set plan debug. the following is from the console log: ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[PCURAM.CONCERNROLEALTERNATEID]) TupleLimit(groups=[]) Project(groups=[PCURAM.CONCERNROLEALTERNATEID]) Source(groups=[PCURAM.CONCERNROLEALTERNATEID]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[PCURAM.CONCERNROLEALTERNATEID], props={MODEL_ID=Schema name=PCURAM, nameInSource=null, uuid=mmuuid:809a2833-6057-4f6b-b676-e2be8d8ff9a0, OUTPUT_COLS=[PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEID, convert(PCURAM.CONCERNROLEALTERNATEID.ALTERNATEID, string), convert(PCURAM.CONCERNROLEALTE RNATEID.TYPECODE, string), PCURAM.CONCERNROLEALTERNATEID.STARTDATE, PCURAM.CONCERNROLEALTERNATEID.ENDDATE, convert(PCURAM.CONCERNROLEALTERNATEID.STATUSCODE, string), PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEALTERNATEID, PCURAM.CONCERNROLEALTERNATEID.COMMENTS, PCURAM.CONCERNROLEALTERNATEID.VERSIONNO, PCURAM.CONCERNROLEALTERNATEID.LASTWRITTEN], EST_CARDINALITY=100.0, EST_COL_STATS={PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEID=[-1.0, -1.0], convert(PCURAM.CONCERNROLEALTERNATEID.ALTERNATEID, string)=[-1.0, -1.0], convert(PCURAM.CONCERNROLEALTERNATEID.TYPECODE, string)=[-1.0, -1.0], PCURAM.CONCERNRO LEALTERNATEID.STARTDATE=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEID, convert(PCURAM.CONCERNROLEALTERNATEID.ALTERNATEID, string), convert(PCURAM.CONCERNROLEALTERNATEID.TYPECODE, string), PCURAM.CONCERNROLEALTERNATEID.STARTDATE, PCURAM.CONCERNROLEALTERNATEID.E NDDATE, convert(PCURAM.CONCERNROLEALTERNATEID.STATUSCODE, string), PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEALTERNATEID, PCURAM.CONCERNROLEALTERNATEID.COMMENTS, PCURAM.CONCERNROLEALTERNATEID.VERSIONNO, PCURAM.CONCERNROLEALTERNATEID.LASTWRITTEN FROM PCURAM.CONCERNROLEALTERNATEID LIMIT 100}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEID, convert(PCURAM.CONCERNROLEALTERNATEID.ALTERNATEID, string), convert(PCURAM.CONCERNROLEALTERNATEID.TYPECODE, string), PCURAM.CONCERNROLEALTERNATEID.STARTDATE, PCURAM.CONCERNROLEALTERNATEID.ENDDATE, convert(PCURAM.CONCERNROLEALTERNATEI D.STATUSCODE, string), PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEALTERNATEID, PCURAM.CONCERNROLEALTERNATEID.COMMENTS, PCURAM.CONCERNROLEALTERNATEID.VERSIONNO, PCURAM.CONCERNROLEALTERNATEID.LASTWRITTEN] SELECT g_0.CONCERNROLEID AS c_0, convert(g_0.ALTERNATEID, string) AS c_1, convert(g_0.TYPECODE, str ing) AS c_2, g_0.STARTDATE AS c_3, g_0.ENDDATE AS c_4, convert(g_0.STATUSCODE, string) AS c_5, g_0.CONCERNROLEALTERNATEID AS c_6, g_0.COMMENTS AS c_7, g_0.VERSIONNO AS c_8, g_0.LASTWRITTEN AS c_9 FROM PCURAM.CONCERNROLEALTERNATEID AS g_0 LIMIT 100 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEID, convert(PCURAM.CONCERNROLEALTERNATEID.ALTERNATEID, string), convert(PCURAM.CONCERNROLEALTERNATEID.TYPECODE, string), PCURAM.CONCERNROLEALTERNATEID.STARTDATE, PCURAM.CONCERNROLEALTERNATEID.ENDDATE, convert(PCURAM.CONCERNROLEALTERNATEI D.STATUSCODE, string), PCURAM.CONCERNROLEALTERNATEID.CONCERNROLEALTERNATEID, PCURAM.CONCERNROLEALTERNATEID.COMMENTS, PCURAM.CONCERNROLEALTERNATEID.VERSIONNO, PCURAM.CONCERNROLEALTERNATEID.LASTWRITTEN] SELECT g_0.CONCERNROLEID AS c_0, convert(g_0.ALTERNATEID, string) AS c_1, convert(g_0.TYPECODE, str ing) AS c_2, g_0.STARTDATE AS c_3, g_0.ENDDATE AS c_4, convert(g_0.STATUSCODE, string) AS c_5, g_0.CONCERNROLEALTERNATEID AS c_6, g_0.COMMENTS AS c_7, g_0.VERSIONNO AS c_8, g_0.LASTWRITTEN AS c_9 FROM PCURAM.CONCERNROLEALTERNATEID AS g_0 LIMIT 100 ============================================================================ As you can see it rewrote the char fields with convert(xx,string) so if any of these fields are indexed the index would NOT get used... > 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