February 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1863) Add native type to procedure parameters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1863?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-1863 at 2/10/14 10:38 AM: ------------------------------------------------------------------ If this is the indexed property for the new "native_type", I'm assuming that Teiid can handle the "REF CURSOR" value without it being in double-quotes? {code} X mmuuid:8b03ca8c-96f5-45d0-944b-a84dadffb8ce {http://www.teiid.org/ext/r... CURSOR 1 /TEIIDDES-1794/SampleRelationa.xmi newParameter_1 ¡10 {code} was (Author: blafond): If this is the indexed property for the new "native_type", I'm assuming that Teiid can handle the "REF CURSOR" value without it being in double-quotes? X mmuuid:8b03ca8c-96f5-45d0-944b-a84dadffb8ce {http://www.teiid.org/ext/r... CURSOR 1 /TEIIDDES-1794/SampleRelationa.xmi newParameter_1 ¡10 > Add native type to procedure parameters > --------------------------------------- > > Key: TEIIDDES-1863 > URL: https://issues.jboss.org/browse/TEIIDDES-1863 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 8.4 > > > TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1863) Add native type to procedure parameters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1863?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-1863 at 2/10/14 10:37 AM: ------------------------------------------------------------------ If this is the indexed property for the new "native_type", I'm assuming that Teiid can handle the "REF CURSOR" value without it being in double-quotes? X mmuuid:8b03ca8c-96f5-45d0-944b-a84dadffb8ce {http://www.teiid.org/ext/r... CURSOR 1 /TEIIDDES-1794/SampleRelationa.xmi newParameter_1 ¡10 was (Author: blafond): If this is the indexed property for the new "native_type", I'm assuming that Teiid can handle the "REF CURSOR" value without it being in double-quotes? *X mmuuid:8b03ca8c-96f5-45d0-944b-a84dadffb8ce {http://www.teiid.org/ext/relational/2012}native_type REF CURSOR 1 /TEIIDDES-1794/SampleRelationa.xmi newParameter_1 ¡10 * > Add native type to procedure parameters > --------------------------------------- > > Key: TEIIDDES-1863 > URL: https://issues.jboss.org/browse/TEIIDDES-1863 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 8.4 > > > TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1863) Add native type to procedure parameters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1863?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1863: ---------------------------------------- If this is the indexed property for the new "native_type", I'm assuming that Teiid can handle the "REF CURSOR" value without it being in double-quotes? *X mmuuid:8b03ca8c-96f5-45d0-944b-a84dadffb8ce {http://www.teiid.org/ext/relational/2012}native_type REF CURSOR 1 /TEIIDDES-1794/SampleRelationa.xmi newParameter_1 ¡10 * > Add native type to procedure parameters > --------------------------------------- > > Key: TEIIDDES-1863 > URL: https://issues.jboss.org/browse/TEIIDDES-1863 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 8.4 > > > TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1794) Designer support for global temporary tables

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1794?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1794: ---------------------------------------- Will global temp tables be allowed for both physical and virtual models or ? > Designer support for global temporary tables > -------------------------------------------- > > Key: TEIIDDES-1794 > URL: https://issues.jboss.org/browse/TEIIDDES-1794 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Mark Addleman > Assignee: Barry LaFond > Fix For: 8.4 > > > Teiid has added support for a global temporary tables - they share a common definition, but each session has their own instance. Internally this is modeled as a virtual table (without a transformation) with a table type of "TemporaryTable" (int code 6). If you provided matching index metadata we would recognize the entry as a global temporary table. > Alternatively extension metadata could be used. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1863) Add native type to procedure parameters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1863?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1863: ----------------------------------- Fix Version/s: 8.4 (was: 8.5) > Add native type to procedure parameters > --------------------------------------- > > Key: TEIIDDES-1863 > URL: https://issues.jboss.org/browse/TEIIDDES-1863 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 8.4 > > > TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2043) Add native type to procedure parameters

by Steven Hawkins (JIRA)

Steven Hawkins created TEIIDDES-2043: ---------------------------------------- Summary: Add native type to procedure parameters Key: TEIIDDES-2043 URL: https://issues.jboss.org/browse/TEIIDDES-2043 Project: Teiid Designer Issue Type: Enhancement Components: Modeling, Teiid Integration Reporter: Steven Hawkins Assignee: Barry LaFond Fix For: 8.5 TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1794) Designer support for global temporary tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1794?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-1794: ------------------------------------------ I'm referring to the constant used when we read the table type from the table record entry. If the table type is set to 6, then we'll know that it's a global temporary table. > Designer support for global temporary tables > -------------------------------------------- > > Key: TEIIDDES-1794 > URL: https://issues.jboss.org/browse/TEIIDDES-1794 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Mark Addleman > Assignee: Barry LaFond > Fix For: 8.4 > > > Teiid has added support for a global temporary tables - they share a common definition, but each session has their own instance. Internally this is modeled as a virtual table (without a transformation) with a table type of "TemporaryTable" (int code 6). If you provided matching index metadata we would recognize the entry as a global temporary table. > Alternatively extension metadata could be used. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1794) Designer support for global temporary tables

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1794?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1794: ---------------------------------------- Not sure what "int code 6" means. Designers metadata indexer defines index types as letters using constants defined in: *IndexConstants* > Designer support for global temporary tables > -------------------------------------------- > > Key: TEIIDDES-1794 > URL: https://issues.jboss.org/browse/TEIIDDES-1794 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Mark Addleman > Assignee: Barry LaFond > Fix For: 8.4 > > > Teiid has added support for a global temporary tables - they share a common definition, but each session has their own instance. Internally this is modeled as a virtual table (without a transformation) with a table type of "TemporaryTable" (int code 6). If you provided matching index metadata we would recognize the entry as a global temporary table. > Alternatively extension metadata could be used. -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2042) Preview Parser on Flat File Import Wizard shows incorrect data

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2042?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2042: ---------------------------------------- Fixed in 8.4 with: https://github.com/Teiid-Designer/teiid-designer/commit/2970f241548c7f9f4... > Preview Parser on Flat File Import Wizard shows incorrect data > -------------------------------------------------------------- > > Key: TEIIDDES-2042 > URL: https://issues.jboss.org/browse/TEIIDDES-2042 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.7.4, 8.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 8.4, 8.3.2 > > Attachments: sample.csv > > > Using the "Parse Selected Row" inside of the File Source(Flat) importer ignores, blanks. I'm attaching a sample.csv. > i.e. > AgencyId,Area,CaseNumber,CaseStatusCode,CaseTypeCode > 714,,,ACTI,M > The parser in the importer, will give results: > AgencyId=714 > Area=ACTI > CaseNumber=M > it should be > AgencyId=714 > Area= > CaseNumber= > CaseStatusCode=ACTI > CaseTypeCode=M -- 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1863) Add native type to procedure parameters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1863?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1863: ----------------------------------- Fix Version/s: 8.5 (was: 8.4) > Add native type to procedure parameters > --------------------------------------- > > Key: TEIIDDES-1863 > URL: https://issues.jboss.org/browse/TEIIDDES-1863 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 8.5 > > > TEIID-2644 adds out parameter cursor handling for oracle, and adds a native type property to procedure parameters (just like regular columns). That is not currently in the index metadata. This value would need to be captured on import and either a new index version used, or an extension property (with additional Teiid handling), or the vdb.xml can use alter statements to add an option. -- 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, 2 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 February 2014