[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
[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
[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
[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
[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
[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
[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
[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
[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