June 2018 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN updated TEIIDDES-3208: ------------------------------------ Attachment: nativeprocparams.png > Support virtual / foreign procedure with VARIADIC parameter > ----------------------------------------------------------- > > Key: TEIIDDES-3208 > URL: https://issues.jboss.org/browse/TEIIDDES-3208 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 11.1 > Environment: Operating system: Windows 10. > Reporter: SHI HONG CHIN > Assignee: Barry LaFond > Fix For: 11.2 > > Attachments: nativeprocparams.png > > > I wanted to create a native query procedure which support unlimited number of object type parameters. > According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name: > {code:java} > CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) > RETURNS (x string); > {code} > In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure. > Please add this feature to Teiid Designer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3209) Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3209?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-3209: ------------------------------------------ To fully understand the scenario is that the user is importing against an odata source using the Teiid connection importer. Then in the metadata that is created by the Designer the nameInSource is double quoted. If that's the case, that is not correct. > Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like > ------------------------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-3209 > URL: https://issues.jboss.org/browse/TEIIDDES-3209 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > > Teiid Connection importer quotes reserved word columns but for odata and odata4 translators the odata ws datasources don't like the quotes. Can the importer have different behavior for just those 2 translators? -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3208: ---------------------------------------- [~cshong] Note that the documentation for VARARGS procedure property is: {code} Indicates that the last argument of the function can be repeated 0 to any number of times. default false. It is more proper to use a VARIADIC parameter. {code} So you should be able to set the VARARGS = true property, deploy our VDB and the last parameter will be treated as VARIADIC > Support virtual / foreign procedure with VARIADIC parameter > ----------------------------------------------------------- > > Key: TEIIDDES-3208 > URL: https://issues.jboss.org/browse/TEIIDDES-3208 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 11.1 > Environment: Operating system: Windows 10. > Reporter: SHI HONG CHIN > Assignee: Barry LaFond > Fix For: 11.2 > > > I wanted to create a native query procedure which support unlimited number of object type parameters. > According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name: > {code:java} > CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) > RETURNS (x string); > {code} > In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure. > Please add this feature to Teiid Designer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3209) Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3209?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-3209: ---------------------------------------- [~dsteigne] Typically in Teiid if there is a period in table name or reserved word (usually when using a fully qualified name) then it gets quoted. In OData a period not allowed in the entity names. The workaround is not to use fully qualified names in translators during the import. If there are duplicates and such they need to be manually edited out. > Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like > ------------------------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-3209 > URL: https://issues.jboss.org/browse/TEIIDDES-3209 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > > Teiid Connection importer quotes reserved word columns but for odata and odata4 translators the odata ws datasources don't like the quotes. Can the importer have different behavior for just those 2 translators? -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3209) Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3209?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3209: ---------------------------------------- [~dsteigne] Designer's source models are mostly not translator/connection aware, so all reserved words are treated the same and double quoted. Does the use-case involve archive VDBs or dynamic VDBs? maybe runtime/deployment can tweak the metadata based on translator type? ([~shawkins]) > Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like > ------------------------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-3209 > URL: https://issues.jboss.org/browse/TEIIDDES-3209 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > > Teiid Connection importer quotes reserved word columns but for odata and odata4 translators the odata ws datasources don't like the quotes. Can the importer have different behavior for just those 2 translators? -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3208: ----------------------------------- Fix Version/s: 11.2 > Support virtual / foreign procedure with VARIADIC parameter > ----------------------------------------------------------- > > Key: TEIIDDES-3208 > URL: https://issues.jboss.org/browse/TEIIDDES-3208 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 11.1 > Environment: Operating system: Windows 10. > Reporter: SHI HONG CHIN > Fix For: 11.2 > > > I wanted to create a native query procedure which support unlimited number of object type parameters. > According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name: > {code:java} > CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) > RETURNS (x string); > {code} > In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure. > Please add this feature to Teiid Designer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-3208: -------------------------------------- Assignee: Barry LaFond > Support virtual / foreign procedure with VARIADIC parameter > ----------------------------------------------------------- > > Key: TEIIDDES-3208 > URL: https://issues.jboss.org/browse/TEIIDDES-3208 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 11.1 > Environment: Operating system: Windows 10. > Reporter: SHI HONG CHIN > Assignee: Barry LaFond > Fix For: 11.2 > > > I wanted to create a native query procedure which support unlimited number of object type parameters. > According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name: > {code:java} > CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) > RETURNS (x string); > {code} > In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure. > Please add this feature to Teiid Designer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3208: ---------------------------------------- Designer currently exposes the *VARARGS* boolean property for a procedure. For archive VDBs (and models), the procedure's metadata should behave as if the last paramater is VARIADIC. However, importing/exporting Dynamic VDBs containing VARIADIC parameter will set the VARARGS to true. This will require modify the DDL importer to detect VARIADIC and set the VARARGS value and export DDL by converting back. > Support virtual / foreign procedure with VARIADIC parameter > ----------------------------------------------------------- > > Key: TEIIDDES-3208 > URL: https://issues.jboss.org/browse/TEIIDDES-3208 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 11.1 > Environment: Operating system: Windows 10. > Reporter: SHI HONG CHIN > > I wanted to create a native query procedure which support unlimited number of object type parameters. > According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name: > {code:java} > CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) > RETURNS (x string); > {code} > In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure. > Please add this feature to Teiid Designer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3209) Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like

by Debbie Steigner (JIRA)

Debbie Steigner created TEIIDDES-3209: ----------------------------------------- Summary: Teiid Connection importer quotes column names that are SQL reserved words but odata/odata4 datasources don't like Key: TEIIDDES-3209 URL: https://issues.jboss.org/browse/TEIIDDES-3209 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 11.1.3 Reporter: Debbie Steigner Assignee: Barry LaFond Teiid Connection importer quotes reserved word columns but for odata and odata4 translators the odata ws datasources don't like the quotes. Can the importer have different behavior for just those 2 translators? -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3207) Data Tools Result View error in Eclipse Photon M6

by Nick Boldt (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3207?page=com.atlassian.jira.plu... ] Nick Boldt commented on TEIIDDES-3207: -------------------------------------- #YouWereSoRight * New snapshot build: http://download.eclipse.org/datatools/updates/1.14.101-SNAPSHOT/repositor... * New JBT TP: https://dev-platform-jenkins.rhev-ci-vms.eng.rdu2.redhat.com/job/jbosstoo... building... results will be here: http://download.jboss.org/jbosstools/targetplatforms/jbosstoolstarget/4.8... (If Integration Stack is using any earlier TP version, it should be updated to use that one.) > Data Tools Result View error in Eclipse Photon M6 > ------------------------------------------------- > > Key: TEIIDDES-3207 > URL: https://issues.jboss.org/browse/TEIIDDES-3207 > Project: Teiid Designer > Issue Type: Bug > Components: Eclipse Integration > Affects Versions: 11.2 > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Blocker > Fix For: 11.2 > > Attachments: td1.png, td2.png, td3.png, td4.png > > > While testing initial Designer upgrade to Photon target platform, my initial test produced an odd error opening the SQL Results View from the Data Tools Eclipse feature. > I then installed basic Eclipse IDE for Java Developers version and added/installed the *Database Development* category. > Opening the Database Development perspective then opening the *SQL Results* view throws the same error below: > {code} > Root exception: > java.lang.NoSuchMethodError: org.apache.lucene.index.IndexWriter.addDocument(Ljava/lang/Iterable;)J > at org.eclipse.datatools.sqltools.result.internal.index.ResultHistoryLuceneIndex.addResults(ResultHistoryLuceneIndex.java:139) > at org.eclipse.datatools.sqltools.result.ResultsViewPlugin.start(ResultsViewPlugin.java:117) > at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:779) > at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:1) > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 5 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues June 2018