February 2014 - teiid-designer-issues

[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: --------------------------------------- based on description, that's not the issue. The importer is ok, its the translator reading the char data, that's truncating. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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 edited comment on TEIIDDES-2061 at 2/19/14 2:36 PM: ---------------------------------------------------------------- based on description, that's not the issue. The importer is ok, its the translator (or maybe higher in the engine) reading the char data, that's truncating. was (Author: van.halbert): based on description, that's not the issue. The importer is ok, its the translator reading the char data, that's truncating. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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: --------------------------------------- not really. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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 Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Johnathon Lee commented on TEIIDDES-2061: ----------------------------------------- If I understand correctly, [~vhalbert] you were arguing my char[x] to varchar[x] statement. I've amended the description. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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 Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Johnathon Lee updated TEIIDDES-2061: ------------------------------------ Description: 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]. was: 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+] to see if a conversion to varchar[n+] is needed. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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 disagree, char(length) in the database should be supported. Designer works right in importing as char and capturing its length and that its fixed. That is the basis for char versus varchar, is that char is for fixed length values. The server / translator should be changed so support the length of a char, and not chop off at 1 char. We can't go making existing databases change the char(length) columns to fix us. Its an existing feature. > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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+] to see if a conversion to varchar[n+] is needed. -- 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-1992) Designer generates wrong view model transformations for some services

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1992?page=com.atlassian.jira.plu... ] Ramesh Reddy reopened TEIIDDES-1992: ------------------------------------ > Designer generates wrong view model transformations for some services > --------------------------------------------------------------------- > > Key: TEIIDDES-1992 > URL: https://issues.jboss.org/browse/TEIIDDES-1992 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 8.3 > Reporter: Van Halbert > Assignee: Ted Jones > Priority: Critical > Fix For: 8.3.1 > > > When generating web service view from WSDL, the designer incorrectly adds the namespace to the request. The request [1] declares the "tns" prefix but since the namespace is not added to the actual request it generates [2]. > User can workaround this by directly modifying the request [3]. > [1] > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT XMLELEMENT(NAME getPeopleByName, XMLNAMESPACES('http://www.jboss.org/jbossas/dv/PeopleJaxws' AS tns)) AS xml_out; > END > [2] Caused by: javax.xml.ws.ProtocolException: Remote javax.xml.ws.soap.SOAPFaultException: Unexpected wrapper element getPeopleByName found. Expected {http://www.jboss.org/jbossas/dv/PeopleJaxws}getPeopleByName. > [3] > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT XMLELEMENT(NAME getPeopleByName, XMLNAMESPACES(DEFAULT 'http://www.jboss.org/jbossas/dv/PeopleJaxws')) AS xml_out; > END -- 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 RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2061: ---------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1067128 > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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+] to see if a conversion to varchar[n+] is needed. -- 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 Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Johnathon Lee updated TEIIDDES-2061: ------------------------------------ Attachment: testErrors.vdb vdb for example in description > char[n+] field is truncated by importer > --------------------------------------- > > Key: TEIIDDES-2061 > URL: https://issues.jboss.org/browse/TEIIDDES-2061 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.3.1 > Reporter: Johnathon Lee > 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+] to see if a conversion to varchar[n+] is needed. -- 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 Johnathon Lee (JIRA)

Johnathon Lee created TEIIDDES-2061: --------------------------------------- Summary: char[n+] field is truncated by importer Key: TEIIDDES-2061 URL: https://issues.jboss.org/browse/TEIIDDES-2061 Project: Teiid Designer Issue Type: Feature Request Components: Import/Export Affects Versions: 8.3.1 Reporter: Johnathon Lee 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+] to see if a conversion to varchar[n+] is needed. -- 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