February 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3042) Error during import DDL which contains udf function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3042?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3042: ---------------------------------------- This is a one line fix .. a null check and the use case is importing a procedure that doesn't have a Result Set in it... like with a UDF > Error during import DDL which contains udf function > ---------------------------------------------------- > > Key: TEIIDDES-3042 > URL: https://… [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3042) Error during import DDL which contains udf function

by Matej Kralik (JIRA)

Matej Kralik created TEIIDDES-3042: -------------------------------------- Summary: Error during import DDL which contains udf function Key: TEIIDDES-3042 URL: https://issues.jboss.org/browse/TEIIDDES-3042 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Import/Export Affects Versions: 10.0.2 Reporter: Matej Kralik Attachments: screenshot1.png, udfProject.zip I have DDL … [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2589) The model extension definition "relational" found in model is a different version than the one in the registry.

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2589?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2589. ---------------------------------- Ok, I am closing this JIRA and the last issue from this bug report will be solved in TEIIDDES-3041. > The model extension definition "relational" found in model is a different version than the one in the registry. > --------------------------------------------------------------------------------------------------------------- > > … [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2621) Support for array datatype

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2621?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2621: ------------------------------------------ For index metadata we'll need the column runtime type to include the array glyph - integer[][] Support for this was added to the runtime with TEIID-4776 > Support for array datatype > -------------------------- > > Key: TEIIDDES-2621 > URL: https://issues.jboss.org/browse/… [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-2185: ------------------------------------- Thanks [~mmakovy] > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release, Web … [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2880: ---------------------------------------- There may be a way to deploy the UDF jar to the server by Designer. We do auto-deploy JDBC drivers if required for creating data sources, so maybe the process would be the same. > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > … [View More] Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005) [View Less]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2880: ----------------------------------- Fix Version/s: 11.0.2 > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: … [View More]Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005) [View Less]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2940) Moving model out of folder breaks imports

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2940?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2940: ----------------------------------- Fix Version/s: 11.0.2 > Moving model out of folder breaks imports > ----------------------------------------- > > Key: TEIIDDES-2940 > URL: https://issues.jboss.org/browse/TEIIDDES-2940 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 &… [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2185: ---------------------------------------- Sorry I didn't notice that I can update the example by myself. I replaced the archive at jboss.org. Marking this as closed. > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > … [View More]

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2185. ---------------------------------- > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release, Web Services Support > … [View More]

8 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2017