February 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2783) Need to add support for parsing OPTIONS in procedure statements

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2783?page=com.atlassian.jira.plu... ] Matus Makovy edited comment on TEIIDDES-2783 at 2/8/17 4:49 AM: ---------------------------------------------------------------- I encountered 2 issues while doing the verification: 1. When I try to import the DDL from description I see a NPE: {code:java} java.lang.Exception: java.lang.NullPointerException at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:116) at org.teiid.designer.ddl.importer.ui.DdlImportDifferencesPage$1.run(DdlImportDifferencesPage.java:232) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: java.lang.NullPointerException at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedureParameter(TeiidDdlImporter.java:667) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedure(TeiidDdlImporter.java:568) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createObject(TeiidDdlImporter.java:851) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.importNode(TeiidDdlImporter.java:733) at org.teiid.designer.ddl.importer.DdlImporter.importTeiidDdl(DdlImporter.java:322) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:163) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:151) at org.teiid.designer.ddl.importer.DdlImporter$1.tryToDo(DdlImporter.java:132) at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41) ... 3 more {code} See attached screenshot - 1 2. When I try to import the DDL that Matej supplied here in comment TD shows an error and creates 2 same procedures in the model. DDL: {code} CREATE VIRTUAL PROCEDURE selfProc (stringIN string(4000) OPTIONS(ANNOTATION 'parameter description')) RETURNS OPTIONS(ANNOTATION 'resultset description') TABLE (result string(30)) OPTIONS(ANNOTATION 'procedure description') AS BEGIN SELECT viewModel.selfProc.stringIN AS result; END; {code} See screenshot 2 was (Author: mmakovy): I encountered 2 issues while doing the verification: 1. When I try to import the DDL from description I see a NPE: {code:java} java.lang.Exception: java.lang.NullPointerException at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:116) at org.teiid.designer.ddl.importer.ui.DdlImportDifferencesPage$1.run(DdlImportDifferencesPage.java:232) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: java.lang.NullPointerException at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedureParameter(TeiidDdlImporter.java:667) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedure(TeiidDdlImporter.java:568) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createObject(TeiidDdlImporter.java:851) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.importNode(TeiidDdlImporter.java:733) at org.teiid.designer.ddl.importer.DdlImporter.importTeiidDdl(DdlImporter.java:322) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:163) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:151) at org.teiid.designer.ddl.importer.DdlImporter$1.tryToDo(DdlImporter.java:132) at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41) ... 3 more {code} See attached screenshot - 1 2. When I try to import the DDL that Matej supplied here in comment TD shows an error and creates 2 same procedures in the model. See screenshot 2 > Need to add support for parsing OPTIONS in procedure statements > --------------------------------------------------------------- > > Key: TEIIDDES-2783 > URL: https://issues.jboss.org/browse/TEIIDDES-2783 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, ModeShape Integration, Patch Release > Reporter: Barry LaFond > Assignee: Dan Florian > Fix For: 11.0.1 > > Attachments: procedureProject.zip, screenshot1.png > > > The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause. > CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL... > Should be able to parse the following and set the EMF *Description* (Annotation) value when imported into Designer > {code} > CREATE FOREIGN PROCEDURE ProcedureWithRS ( > newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'), > newParameter_2 string(4000) > ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2783) Need to add support for parsing OPTIONS in procedure statements

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2783?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2783: ------------------------------------ I encountered 2 issues while doing the verification: 1. When I try to import the DDL from description I see a NPE: {code:java} java.lang.Exception: java.lang.NullPointerException at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:116) at org.teiid.designer.ddl.importer.ui.DdlImportDifferencesPage$1.run(DdlImportDifferencesPage.java:232) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: java.lang.NullPointerException at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedureParameter(TeiidDdlImporter.java:667) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createProcedure(TeiidDdlImporter.java:568) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createObject(TeiidDdlImporter.java:851) at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.importNode(TeiidDdlImporter.java:733) at org.teiid.designer.ddl.importer.DdlImporter.importTeiidDdl(DdlImporter.java:322) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:163) at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:151) at org.teiid.designer.ddl.importer.DdlImporter$1.tryToDo(DdlImporter.java:132) at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41) ... 3 more {code} See attached screenshot - 1 2. When I try to import the DDL that Matej supplied here in comment TD shows an error and creates 2 same procedures in the model. See screenshot 2 > Need to add support for parsing OPTIONS in procedure statements > --------------------------------------------------------------- > > Key: TEIIDDES-2783 > URL: https://issues.jboss.org/browse/TEIIDDES-2783 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, ModeShape Integration, Patch Release > Reporter: Barry LaFond > Assignee: Dan Florian > Fix For: 11.0.1 > > Attachments: procedureProject.zip, screenshot1.png > > > The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause. > CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL... > Should be able to parse the following and set the EMF *Description* (Annotation) value when imported into Designer > {code} > CREATE FOREIGN PROCEDURE ProcedureWithRS ( > newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'), > newParameter_2 string(4000) > ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3027) Duplicate Source Model in created VDB

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3027?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-3027. ---------------------------------- > Duplicate Source Model in created VDB > ------------------------------------- > > Key: TEIIDDES-3027 > URL: https://issues.jboss.org/browse/TEIIDDES-3027 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs, Editors > Affects Versions: 11.0.1 > Reporter: stanislav kaleta > Assignee: Barry LaFond > Fix For: 11.0.1 > > > If you select both View Model and related Source Model in _New VDB_ dialog, created VDB has pending changes and is unable to save due to error: > {code:java} > java.lang.Exception: java.util.zip.ZipException: duplicate entry: <SourceModelName> > {code} > Related Source Models are automatically added during creation of VDB. The Problem occurs when you also manually add Source Model in _New VDB_ dialog. The creation process doesn't recognize that it's the same model which is related to View Model. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3024) Import/Export ddl problem with Indexes

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3024?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-3024: ------------------------------------ Name in source of index is not included in DDL > Import/Export ddl problem with Indexes > --------------------------------------- > > Key: TEIIDDES-3024 > URL: https://issues.jboss.org/browse/TEIIDDES-3024 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Assignee: Barry LaFond > Fix For: 11.0.1 > > Attachments: verification.zip > > > According this : [DDL metadata|https://docs.jboss.org/author/display/TEIID/DDL+Metadata] > Index should look like this: > CONSTRAINT EXAMPLE_INDEX INDEX (name, amount) > but in our ddl look: > newColumn_1 string(4000) INDEX > Problem is that when we export and import source model new model have two indexes with the same default name INDEX(colision/error) and also there are missing atributes Name In Source and description. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3023) Non working materialized after exporting DDL with another name than name of source model

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3023?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-3023. ---------------------------------- > Non working materialized after exporting DDL with another name than name of source model > ---------------------------------------------------------------------------------------- > > Key: TEIIDDES-3023 > URL: https://issues.jboss.org/browse/TEIIDDES-3023 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Assignee: Barry LaFond > Fix For: 11.0.1 > > Attachments: Screen2.png > > > I have source model with name "source.xmi" (for example) )and materialized in it. > Then I want to export this model as DDL file. There is default set name of new DLL "exportedDDL.ddl" in export dialog.(Screen2) > After that I want to import this DDL file but new name of source model is "exportedDDL.xmi" and therefore materialized do not work. > Possible solution is that in export dialog will be default set name of source model instead "exportedDDL.ddl" and when user will change name some warning window will show. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2984) Non-prepared checkbox in Procedure dialog in Source Model

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2984?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2984: ----------------------------------- Labels: release_notes (was: ) > Non-prepared checkbox in Procedure dialog in Source Model > --------------------------------------------------------- > > Key: TEIIDDES-2984 > URL: https://issues.jboss.org/browse/TEIIDDES-2984 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs, Editors > Affects Versions: 10.0.2 > Reporter: Mario Majernik > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.0.1 > > > Value of Non-Prepared is always false and it cannot be changed on true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2984) Non-prepared checkbox in Procedure dialog in Source Model

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2984?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2984. ---------------------------------- > Non-prepared checkbox in Procedure dialog in Source Model > --------------------------------------------------------- > > Key: TEIIDDES-2984 > URL: https://issues.jboss.org/browse/TEIIDDES-2984 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs, Editors > Affects Versions: 10.0.2 > Reporter: Mario Majernik > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.0.1 > > > Value of Non-Prepared is always false and it cannot be changed on true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2982) Missing Table settings in dynamic VDB

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2982?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2982. ---------------------------------- "Is system table" property cannot be included in Teiid DDL, Name in source is present. Closing > Missing Table settings in dynamic VDB > ------------------------------------- > > Key: TEIIDDES-2982 > URL: https://issues.jboss.org/browse/TEIIDDES-2982 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export > Affects Versions: 10.0.2 > Reporter: Mario Majernik > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.0.1 > > Attachments: DynamicVDBtesting.zip, DynamicVDBtestingWithAP.zip > > > There are missing Table setiings in dynamic vdb: > * System(Is System Table checkbox in table dialog) column is always false.(No mention in dynamicVDB) > * Name In Source and Description is empty in PrimaryKeys ,Foreign Keys, Unique Constraint tabs and AccessPattern.(No mention in dynamic VDB) > EDIT: {color:red}There is still problem with NIS and Description in Access Pattern.{color} > Example project: [^DynamicVDBtestingWithAP.zip] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2982) Missing Table settings in dynamic VDB

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2982?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2982: ----------------------------------- Labels: release_notes (was: ) > Missing Table settings in dynamic VDB > ------------------------------------- > > Key: TEIIDDES-2982 > URL: https://issues.jboss.org/browse/TEIIDDES-2982 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export > Affects Versions: 10.0.2 > Reporter: Mario Majernik > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.0.1 > > Attachments: DynamicVDBtesting.zip, DynamicVDBtestingWithAP.zip > > > There are missing Table setiings in dynamic vdb: > * System(Is System Table checkbox in table dialog) column is always false.(No mention in dynamicVDB) > * Name In Source and Description is empty in PrimaryKeys ,Foreign Keys, Unique Constraint tabs and AccessPattern.(No mention in dynamic VDB) > EDIT: {color:red}There is still problem with NIS and Description in Access Pattern.{color} > Example project: [^DynamicVDBtestingWithAP.zip] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2881) Sizing issue in Teiid designer

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2881?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2881: ----------------------------------- Labels: release_notes (was: ) > Sizing issue in Teiid designer > ------------------------------ > > Key: TEIIDDES-2881 > URL: https://issues.jboss.org/browse/TEIIDDES-2881 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 10.0.1 > Reporter: Harshul Madan > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.0.1 > > Attachments: Screen Shot 2016-07-22 at 9.01.00 AM.png, Screen Shot 2016-07-22 at 9.01.16 AM-1.png, Screen Shot 2017-02-02 at 13.33.16.png, reconciler_resized.png, type-resolver-linux.png > > > When we click on “Reconciler” icon in Transformation editor. The components in the window which opens is not programmed to support different screen size (i.e. doesn’t scale adequately). > Details: > MacBook Pro (Retina, 13.3-inch (2560 x 1600)) > Teiid Designer 9.0 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 2 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 February 2017