June 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2207?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2207: ----------------------------------- Attachment: testWebService.zip > Web Service Operation SQL valid in 8.3.2 but invalid in 8.5 > ----------------------------------------------------------- > > Key: TEIIDDES-2207 > URL: https://issues.jboss.org/browse/TEIIDDES-2207 > Project: Teiid Designer > Issue Type: Bug > Components: Validation, Web Services Support > Affects Versions: 8.5 > Reporter: Barry LaFond > Assignee: Paul Richardson > Priority: Critical > Fix For: 8.5 > > Attachments: testWebService.zip > > > Compared creating WS from source and view models in 8.3.2 vs 8.5. > See attached project set > 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer > 2) Created WS from PRoductsViews view model and WS operations contained an error. > Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL. > 8.3.2 SQL > {code} > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE string VARIABLES.IN_exampleVar; > VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]'); > SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView; > END > {code} > Same operation validated in 8.5 but results in validation error: > {code} > BEGIN > DECLARE string VARIABLES.IN_exampleVar; > VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]'); > SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView; > END > {code} > ERROR > {code} > ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions. > {code} -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2207: -------------------------------------- Summary: Web Service Operation SQL valid in 8.3.2 but invalid in 8.5 Key: TEIIDDES-2207 URL: https://issues.jboss.org/browse/TEIIDDES-2207 Project: Teiid Designer Issue Type: Bug Components: Validation, Web Services Support Affects Versions: 8.5 Reporter: Barry LaFond Assignee: Paul Richardson Priority: Critical Fix For: 8.5 Attachments: testWebService.zip Compared creating WS from source and view models in 8.3.2 vs 8.5. See attached project set 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer 2) Created WS from PRoductsViews view model and WS operations contained an error. Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL. 8.3.2 SQL {code} CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar; VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]'); SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView; END {code} Same operation validated in 8.5 but results in validation error: {code} BEGIN DECLARE string VARIABLES.IN_exampleVar; VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]'); SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView; END {code} ERROR {code} ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions. {code} -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2205) Remove table name error validation for names that include '.' delimiter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2205?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2205: ----------------------------------- Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/commit/15adf31e88f66501f... > Remove table name error validation for names that include '.' delimiter > ------------------------------------------------------------------------ > > Key: TEIIDDES-2205 > URL: https://issues.jboss.org/browse/TEIIDDES-2205 > Project: Teiid Designer > Issue Type: Bug > Components: Validation > Affects Versions: 8.3.3 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.5, 8.3.4 > > > Based on the discussion in TEIID-2993 we need to relax the constraint that prevents using the '.' delimiter in table names if the names aren't double quoted. > RelationalStringNameRule.validate() is calling: CoreValidationRulesUtil.validateForNonQuotedNameWithDelimeter(result, name); -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2205) Remove table name error validation for names that include '.' delimiter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2205?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2205. ------------------------------------ Resolution: Done done > Remove table name error validation for names that include '.' delimiter > ------------------------------------------------------------------------ > > Key: TEIIDDES-2205 > URL: https://issues.jboss.org/browse/TEIIDDES-2205 > Project: Teiid Designer > Issue Type: Bug > Components: Validation > Affects Versions: 8.3.3 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.5, 8.3.4 > > > Based on the discussion in TEIID-2993 we need to relax the constraint that prevents using the '.' delimiter in table names if the names aren't double quoted. > RelationalStringNameRule.validate() is calling: CoreValidationRulesUtil.validateForNonQuotedNameWithDelimeter(result, name); -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2201) DDL FILE importer generates inaccurate view model

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2201?page=com.atlassian.jira.plu... ] Mark Drilling resolved TEIIDDES-2201. ------------------------------------- Fix Version/s: 8.5 Resolution: Done Resolved issues 1 and 3 in the DDL importers. (1) Constraints are now generated and (3) NUMBER type is resolved. https://github.com/Teiid-Designer/teiid-designer/pull/371 Opened the related JIRA to address (2) comment statements not handled. This will be considered for next release. > DDL FILE importer generates inaccurate view model > ------------------------------------------------- > > Key: TEIIDDES-2201 > URL: https://issues.jboss.org/browse/TEIIDDES-2201 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.5 > Reporter: Tom Johnston > Assignee: Mark Drilling > Fix For: 8.5 > > Attachments: order_test_ddl.txt > > > Attaching simple ddl (Oracle from powerdesigner). When importing several issues occur. > 1) NO PK or FK created including no relationship shown > 2) comments on tables do not get imported as descriptions, NUMBER datatype comes in as object -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2206) Oracle DDL Importer should handle comment statements

by Mark Drilling (JIRA)

Mark Drilling created TEIIDDES-2206: --------------------------------------- Summary: Oracle DDL Importer should handle comment statements Key: TEIIDDES-2206 URL: https://issues.jboss.org/browse/TEIIDDES-2206 Project: Teiid Designer Issue Type: Enhancement Components: Import/Export Affects Versions: 8.5 Reporter: Mark Drilling Fix For: 8.6 Attachments: order_test_ddl.txt Request that Oracle DDL comment statements be processed. Use the comment for the object description. Currently the DDL parser does not handle this statement type. See attached DDL for an example. -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2206) Oracle DDL Importer should handle comment statements

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2206?page=com.atlassian.jira.plu... ] Mark Drilling updated TEIIDDES-2206: ------------------------------------ Attachment: order_test_ddl.txt > Oracle DDL Importer should handle comment statements > ---------------------------------------------------- > > Key: TEIIDDES-2206 > URL: https://issues.jboss.org/browse/TEIIDDES-2206 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 8.5 > Reporter: Mark Drilling > Fix For: 8.6 > > Attachments: order_test_ddl.txt > > > Request that Oracle DDL comment statements be processed. Use the comment for the object description. Currently the DDL parser does not handle this statement type. > See attached DDL for an example. -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2205) Remove table name error validation for names that include '.' delimiter

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2205: -------------------------------------- Summary: Remove table name error validation for names that include '.' delimiter Key: TEIIDDES-2205 URL: https://issues.jboss.org/browse/TEIIDDES-2205 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 8.3.3 Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 8.5, 8.3.4 Based on the discussion in TEIID-2993 we need to relax the constraint that prevents using the '.' delimiter in table names if the names aren't double quoted. RelationalStringNameRule.validate() is calling: CoreValidationRulesUtil.validateForNonQuotedNameWithDelimeter(result, name); -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2204) Viewing imported MED with dashes in NS prefix shows error

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2204?page=com.atlassian.jira.plu... ] Mark Drilling resolved TEIIDDES-2204. ------------------------------------- Resolution: Done Now treats validation of imported MED same as built-ins in the MED editor. https://github.com/Teiid-Designer/teiid-designer/pull/372 > Viewing imported MED with dashes in NS prefix shows error > --------------------------------------------------------- > > Key: TEIIDDES-2204 > URL: https://issues.jboss.org/browse/TEIIDDES-2204 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework > Affects Versions: 8.5 > Reporter: Mark Drilling > Assignee: Mark Drilling > Fix For: 8.5 > > > Noticed an error when viewing a few of the new dynamically generated (imported) MEDs. In the MED registry, select one that has a dash in the NS prefix - for example sap-nw-gateway. The MED editor flags the MED as having an error - "NS prefix cant have special characters". -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2204) Viewing imported MED with dashes in NS prefix shows error

by Mark Drilling (JIRA)

Mark Drilling created TEIIDDES-2204: --------------------------------------- Summary: Viewing imported MED with dashes in NS prefix shows error Key: TEIIDDES-2204 URL: https://issues.jboss.org/browse/TEIIDDES-2204 Project: Teiid Designer Issue Type: Bug Components: Extension Framework Affects Versions: 8.5 Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 8.5 Noticed an error when viewing a few of the new dynamically generated (imported) MEDs. In the MED registry, select one that has a dash in the NS prefix - for example sap-nw-gateway. The MED editor flags the MED as having an error - "NS prefix cant have special characters". -- This message was sent by Atlassian JIRA (v6.2.3#6260)

11 years, 10 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 June 2014