October 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2938) Escape single quotes in the ANNOTATION string

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2938?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2938: ---------------------------------------- [~rareddy] Are you proposing that Designer escapes any single or d-quote within a *Description* if it isn't already? > Escape single quotes in the ANNOTATION string > --------------------------------------------- > > Key: TEIIDDES-2938 > URL: https://issues.jboss.org/browse/TEIIDDES-2938 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Reporter: Ramesh Reddy > > When reading metadata from TEIID, when ANNOTATION property in the OPTIONS clause comes with escaped string for single quotes it needs to be preserved. Otherwise you will see errors like > {code} > 09:06:36,945 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB PREVIEW-1d551d3c-afa8-4eb9-8447-33175b1bdd14.1 model "ClouderaImpalaJDBCConnection" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ", ANNOTATION 'Any query with '[*]select[*]' in it will return this table.')" at line 12, column 86. > Was expecting: "," | ")": org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ", ANNOTATION 'Any query with '[*]select[*]' in it will return this table.')" at line 12, column 86. > Was expecting: "," | ")" > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84) [teiid-runtime-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) > Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ", ANNOTATION 'Any query with '[*]select[*]' in it will return this table.')" at line 12, column 86. > Was expecting: "," | ")" > at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > ... 11 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2942: ------------------------------------------ > Is this legal? Yes that is legal. > And what do we export if both exist? The syntax issue is that return must be an out parameter: out p1 string(4000) result omitting the out means that it's defaulted to an in parameter. > Procedure input parameter has result in the generated DDL > --------------------------------------------------------- > > Key: TEIIDDES-2942 > URL: https://issues.jboss.org/browse/TEIIDDES-2942 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Priority: Critical > Fix For: 10.0.2 > > Attachments: ddlProject.zip > > > I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that: > {code:java} > TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52. > Procedure testProc RESULT param p1 must be of type OUT. > {code} > I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine. > Actual DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} > expected DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2942: ----------------------------------- Fix Version/s: 10.0.2 > Procedure input parameter has result in the generated DDL > --------------------------------------------------------- > > Key: TEIIDDES-2942 > URL: https://issues.jboss.org/browse/TEIIDDES-2942 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Priority: Critical > Fix For: 10.0.2 > > Attachments: ddlProject.zip > > > I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that: > {code:java} > TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52. > Procedure testProc RESULT param p1 must be of type OUT. > {code} > I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine. > Actual DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} > expected DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2942: ---------------------------------------- [~shawkins] Designer currently allows setting a procedure parameter to *RETURN* direction *and* have a *Result Set* defined. Couldn't find any restrictions/info in the BNF doc. Is this legal? and if not, we can easily add a validation rule. And what do we export if both exist? > Procedure input parameter has result in the generated DDL > --------------------------------------------------------- > > Key: TEIIDDES-2942 > URL: https://issues.jboss.org/browse/TEIIDDES-2942 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Priority: Critical > Attachments: ddlProject.zip > > > I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that: > {code:java} > TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52. > Procedure testProc RESULT param p1 must be of type OUT. > {code} > I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine. > Actual DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} > expected DDL: > {code:java} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2943) Unhandled event loop exception adding child

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2943?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2943: ------------------------------------------ Is there a combination that will work? Seems like this blocks any manual modelling, correct? > Unhandled event loop exception adding child > ------------------------------------------- > > Key: TEIIDDES-2943 > URL: https://issues.jboss.org/browse/TEIIDDES-2943 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 10.1 > Reporter: Steven Hawkins > Attachments: project.zip > > > Started with a new project / new model, tried to add a child to the view model and got an exception. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2943) Unhandled event loop exception adding child

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2943?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2943: ---------------------------------------- [~shawkins] Believe it or not it's an Eclipse/GTK3 issue that'll show up with Mars and GTK3 > 3.10.8 (I have that version and it works.. Paul has 3.19 and has same issues. A fix was added in Eclipse Neon, so in Designer 11.0 this should go away. > Unhandled event loop exception adding child > ------------------------------------------- > > Key: TEIIDDES-2943 > URL: https://issues.jboss.org/browse/TEIIDDES-2943 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 10.1 > Reporter: Steven Hawkins > Attachments: project.zip > > > Started with a new project / new model, tried to add a child to the view model and got an exception. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2944) Remove the dynamic vdb terminology

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2944?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2944: ----------------------------------- Fix Version/s: 11.0 > Remove the dynamic vdb terminology > ---------------------------------- > > Key: TEIIDDES-2944 > URL: https://issues.jboss.org/browse/TEIIDDES-2944 > Project: Teiid Designer > Issue Type: Quality Risk > Components: Documentation, Teiid Integration > Reporter: Steven Hawkins > Fix For: 11.0 > > > We should remove/deprecate the dynamic term and instead reference native metadata import and ddl. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2944) Remove the dynamic vdb terminology

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2944?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2944: ------------------------------------------ It makes sense to just talk about vdb archives vs. XML vdbs: "Generate XML VDB" or "Generate VDB as XML Deployment" > Remove the dynamic vdb terminology > ---------------------------------- > > Key: TEIIDDES-2944 > URL: https://issues.jboss.org/browse/TEIIDDES-2944 > Project: Teiid Designer > Issue Type: Quality Risk > Components: Documentation, Teiid Integration > Reporter: Steven Hawkins > Fix For: 11.0 > > > We should remove/deprecate the dynamic term and instead reference native metadata import and ddl. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2945) Issues with ddl generation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2945?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2945: ----------------------------------- Fix Version/s: 11.1 > Issues with ddl generation > -------------------------- > > Key: TEIIDDES-2945 > URL: https://issues.jboss.org/browse/TEIIDDES-2945 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 10.1 > Reporter: Steven Hawkins > Fix For: 11.1 > > > This can be separated out into separate issues if needed. > - most ddl statements are not terminated with the semicolon delimiter. This was a mistake with the original grammar. We'll hopefully get this resolved with minimal breaking changes with TEIID-4528 > - name in source and other options should be added by default. Is there a reason they are omitted by default? > - triggers / update procedures don't seem to be emitted -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2944) Remove the dynamic vdb terminology

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2944?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2944: ---------------------------------------- [~shawkins] we don't have that many references to dynamic or archive vdbs... what do you suggest as replacement terms/labels for: * *Generate Dynamic VDB* action ** MultiStatus generateStatus = new MultiStatus(VdbConstants.PLUGIN_ID, IStatus.OK, "Exported Dynamic VDB", null); Used on summary page in wizard ** dynamicVdbInvalidName = The supplied Dynamic VDB deployment name "abcd-vdx.xml" does not end with "-vdb.xml" * *Generate VDB Archive and Models* action > Remove the dynamic vdb terminology > ---------------------------------- > > Key: TEIIDDES-2944 > URL: https://issues.jboss.org/browse/TEIIDDES-2944 > Project: Teiid Designer > Issue Type: Quality Risk > Components: Documentation, Teiid Integration > Reporter: Steven Hawkins > > We should remove/deprecate the dynamic term and instead reference native metadata import and ddl. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2016