[JBoss JIRA] (TEIIDDES-3034) Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3034?page=com.atlassian.jira.plu... ]
Matej Kralik reopened TEIIDDES-3034:
------------------------------------
I generate view model from DDL which is in the description (viewModelFromDescription.png). This model is valid and preview data works.
I tried to import DDL from the first comment, but view model is not valid and it doesn't contain any result (viewModelFromComment.png).
> Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-3034
> URL: https://issues.jboss.org/browse/TEIIDDES-3034
> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 11.1
>
> Attachments: viewModelFromComment.png, viewModelFromDescription.png
>
>
> testing and debugging for TEIIDDES-2783 exposed an issue when importing a procedure containing a RETURNS data type and no result set.
> The transformation resolving framework contains logic that will auto-create a result set containing a generated column.
> We need to catch this use-case and prevent the result set from being created using this simple DDL input
> {code}
> CREATE VIRTUAL PROCEDURE ProcedureWithRS (
> stringIN string(4000) OPTIONS(ANNOTATION 'parameter 1 description')
> ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') AS
> BEGIN
> SELECT stringIN AS result;
> END
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years
[JBoss JIRA] (TEIIDDES-3034) Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3034?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-3034:
-----------------------------------
Attachment: viewModelFromComment.png
viewModelFromDescription.png
> Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-3034
> URL: https://issues.jboss.org/browse/TEIIDDES-3034
> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 11.1
>
> Attachments: viewModelFromComment.png, viewModelFromDescription.png
>
>
> testing and debugging for TEIIDDES-2783 exposed an issue when importing a procedure containing a RETURNS data type and no result set.
> The transformation resolving framework contains logic that will auto-create a result set containing a generated column.
> We need to catch this use-case and prevent the result set from being created using this simple DDL input
> {code}
> CREATE VIRTUAL PROCEDURE ProcedureWithRS (
> stringIN string(4000) OPTIONS(ANNOTATION 'parameter 1 description')
> ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') AS
> BEGIN
> SELECT stringIN AS result;
> END
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years
[JBoss JIRA] (TEIIDDES-3160) IllegalArgumentException occurs when calling UDF in Expression Builder
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3160?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-3160.
----------------------------------
> IllegalArgumentException occurs when calling UDF in Expression Builder
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-3160
> URL: https://issues.jboss.org/browse/TEIIDDES-3160
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 11.0.1
> Environment: JDV6.3.7
> DevStudio 10.4
> DevStudioIS 10.3 (Teiid Desinger 11.0.1)
> Reporter: Hiroki Daicho
> Assignee: Barry LaFond
> Fix For: 11.1.1
>
> Attachments: reproducer.zip
>
>
> UDF functions can not be chosen from Expression Builder.
> After select the UDF's category, IllegalArgumentException occurred.
> And the UDF functions are not shown as the pull down list of Function.
> {code}
> - Unhandled event loop exception
> java.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:142)
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:128)
> at org.teiid.query.ui.builder.model.FunctionEditorModel.setFunctionName(FunctionEditorModel.java:338)
> at org.teiid.designer.transformation.ui.builder.expression.FunctionEditor.handleFunctionSelected(FunctionEditor.java:267)
> at org.teiid.designer.transformation.ui.builder.expression.FunctionEditor$2.widgetSelected(FunctionEditor.java:144)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5227)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4561)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4151)
> at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)
> at org.eclipse.jface.window.Window.open(Window.java:794)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.showExpressionBuilder(SqlEditorPanel.java:1205)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.showExpressionBuilder(SqlEditorPanelWrapper.java:123)
> at org.teiid.designer.transformation.ui.editors.sqleditor.actions.LaunchExpressionBuilder.doRun(LaunchExpressionBuilder.java:50)
> at org.teiid.designer.ui.common.actions.AbstractAction$1.run(AbstractAction.java:544)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4536)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4154)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)
> at org.teiid.designer.ui.common.actions.AbstractAction.run(AbstractAction.java:547)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)
> at org.eclipse.jface.action.ActionContributionItem.lambda$5(ActionContributionItem.java:436)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5227)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4561)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4151)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:693)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:610)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:138)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1519)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1492)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years