[JBoss JIRA] (TEIIDDES-2203) Deletion of invalid (columnless) models causes NPE
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2203?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2203:
----------------------------------------
For clarity, I'm assuming you mean there are a number of *EMPTY* tables created (i.e. no columns)?
If they are just system tables, can you attach a project set of model (.xmi) containing them?
> Deletion of invalid (columnless) models causes NPE
> --------------------------------------------------
>
> Key: TEIIDDES-2203
> URL: https://issues.jboss.org/browse/TEIIDDES-2203
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.5
> Reporter: Tom Johnston
>
> I imported all of the SYS views of Oracle 11g which results in a number of tableless columns.
> I have done something similar before and 'cleaned it up' by deleting them after the fact but given another bug of re-using models created in a prior release in a more current workspace/vdb I am re-importing/cleaning up.
> The issue is now I get NPE when I select several of these tables and click delete.
> org.eclipse.swt.SWTException: Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))
> at org.eclipse.swt.SWT.error(SWT.java:4397)
> at org.eclipse.swt.SWT.error(SWT.java:4312)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
> 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.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.handleKeyPressed(ModelExplorerResourceNavigator.java:1738)
> at org.eclipse.ui.views.navigator.ResourceNavigator$8.keyPressed(ResourceNavigator.java:507)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:167)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1081)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1108)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1104)
> at org.eclipse.swt.widgets.Widget.wmKeyDown(Widget.java:1827)
> at org.eclipse.swt.widgets.Control.WM_KEYDOWN(Control.java:4975)
> at org.eclipse.swt.widgets.Tree.WM_KEYDOWN(Tree.java:6137)
> at org.eclipse.swt.widgets.Control.windowProc(Control.java:4643)
> at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6005)
> at org.eclipse.swt.widgets.Display.windowProc(Display.java:4977)
> at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
> at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> Caused by: org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
> at org.eclipse.swt.SWT.error(SWT.java:4397)
> at org.eclipse.swt.SWT.error(SWT.java:4312)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
> 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.teiid.designer.ui.actions.DeleteAction.doRun(DeleteAction.java:335)
> 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:135)
> ... 45 more
> Caused by: java.lang.NullPointerException
> at org.teiid.designer.core.refactor.ObjectDeleteCommand.setObjectsToDelete(ObjectDeleteCommand.java:97)
> at org.teiid.designer.ui.actions.workers.DeleteWorker.createObjectDeleteCommand(DeleteWorker.java:155)
> at org.teiid.designer.ui.actions.DeleteEObjectAction.doRun(DeleteEObjectAction.java:83)
> 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:135)
> ... 56 more
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIIDDES-2203) Deletion of invalid (columnless) models causes NPE
by Tom Johnston (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2203?page=com.atlassian.jira.plu... ]
Tom Johnston updated TEIIDDES-2203:
-----------------------------------
Issue Type: Bug (was: Feature Request)
Affects Version/s: 8.5
> Deletion of invalid (columnless) models causes NPE
> --------------------------------------------------
>
> Key: TEIIDDES-2203
> URL: https://issues.jboss.org/browse/TEIIDDES-2203
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.5
> Reporter: Tom Johnston
>
> I imported all of the SYS views of Oracle 11g which results in a number of tableless columns.
> I have done something similar before and 'cleaned it up' by deleting them after the fact but given another bug of re-using models created in a prior release in a more current workspace/vdb I am re-importing/cleaning up.
> The issue is now I get NPE when I select several of these tables and click delete.
> org.eclipse.swt.SWTException: Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))
> at org.eclipse.swt.SWT.error(SWT.java:4397)
> at org.eclipse.swt.SWT.error(SWT.java:4312)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
> 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.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.handleKeyPressed(ModelExplorerResourceNavigator.java:1738)
> at org.eclipse.ui.views.navigator.ResourceNavigator$8.keyPressed(ResourceNavigator.java:507)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:167)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1081)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1108)
> at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1104)
> at org.eclipse.swt.widgets.Widget.wmKeyDown(Widget.java:1827)
> at org.eclipse.swt.widgets.Control.WM_KEYDOWN(Control.java:4975)
> at org.eclipse.swt.widgets.Tree.WM_KEYDOWN(Tree.java:6137)
> at org.eclipse.swt.widgets.Control.windowProc(Control.java:4643)
> at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6005)
> at org.eclipse.swt.widgets.Display.windowProc(Display.java:4977)
> at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
> at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> Caused by: org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
> at org.eclipse.swt.SWT.error(SWT.java:4397)
> at org.eclipse.swt.SWT.error(SWT.java:4312)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
> 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.teiid.designer.ui.actions.DeleteAction.doRun(DeleteAction.java:335)
> 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:135)
> ... 45 more
> Caused by: java.lang.NullPointerException
> at org.teiid.designer.core.refactor.ObjectDeleteCommand.setObjectsToDelete(ObjectDeleteCommand.java:97)
> at org.teiid.designer.ui.actions.workers.DeleteWorker.createObjectDeleteCommand(DeleteWorker.java:155)
> at org.teiid.designer.ui.actions.DeleteEObjectAction.doRun(DeleteEObjectAction.java:83)
> 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:135)
> ... 56 more
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIIDDES-2203) Deletion of invalid (columnless) models causes NPE
by Tom Johnston (JIRA)
Tom Johnston created TEIIDDES-2203:
--------------------------------------
Summary: Deletion of invalid (columnless) models causes NPE
Key: TEIIDDES-2203
URL: https://issues.jboss.org/browse/TEIIDDES-2203
Project: Teiid Designer
Issue Type: Feature Request
Reporter: Tom Johnston
I imported all of the SYS views of Oracle 11g which results in a number of tableless columns.
I have done something similar before and 'cleaned it up' by deleting them after the fact but given another bug of re-using models created in a prior release in a more current workspace/vdb I am re-importing/cleaning up.
The issue is now I get NPE when I select several of these tables and click delete.
org.eclipse.swt.SWTException: Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))
at org.eclipse.swt.SWT.error(SWT.java:4397)
at org.eclipse.swt.SWT.error(SWT.java:4312)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
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.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.handleKeyPressed(ModelExplorerResourceNavigator.java:1738)
at org.eclipse.ui.views.navigator.ResourceNavigator$8.keyPressed(ResourceNavigator.java:507)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:167)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1081)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1108)
at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1104)
at org.eclipse.swt.widgets.Widget.wmKeyDown(Widget.java:1827)
at org.eclipse.swt.widgets.Control.WM_KEYDOWN(Control.java:4975)
at org.eclipse.swt.widgets.Tree.WM_KEYDOWN(Tree.java:6137)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:4643)
at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6005)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4977)
at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
Caused by: org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
at org.eclipse.swt.SWT.error(SWT.java:4397)
at org.eclipse.swt.SWT.error(SWT.java:4312)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:138)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4145)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3762)
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.teiid.designer.ui.actions.DeleteAction.doRun(DeleteAction.java:335)
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:135)
... 45 more
Caused by: java.lang.NullPointerException
at org.teiid.designer.core.refactor.ObjectDeleteCommand.setObjectsToDelete(ObjectDeleteCommand.java:97)
at org.teiid.designer.ui.actions.workers.DeleteWorker.createObjectDeleteCommand(DeleteWorker.java:155)
at org.teiid.designer.ui.actions.DeleteEObjectAction.doRun(DeleteEObjectAction.java:83)
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:135)
... 56 more
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIIDDES-2152) Adding source table with quoted name results in wrong generated SQL statement
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2152:
------------------------------------------
> but more than one '.' is discouraged and not expected.
Where is that from? Generally we don't care how many there are.
> Adding source table with quoted name results in wrong generated SQL statement
> -----------------------------------------------------------------------------
>
> Key: TEIIDDES-2152
> URL: https://issues.jboss.org/browse/TEIIDDES-2152
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Fix For: 8.3.4, 8.6, 8.5.1
>
>
> 1) Created source model with simple table named "My.Quoted.Table" (including quotes
> 2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
> 3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"
> Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIIDDES-2202) Adding source table with quoted name results in wrong generated SQL statement
by Paul Richardson (JIRA)
Paul Richardson created TEIIDDES-2202:
-----------------------------------------
Summary: Adding source table with quoted name results in wrong generated SQL statement
Key: TEIIDDES-2202
URL: https://issues.jboss.org/browse/TEIIDDES-2202
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.5
Reporter: Paul Richardson
Assignee: Paul Richardson
Fix For: 8.3.4, 8.6, 8.5.1
1) Created source model with simple table named "My.Quoted.Table" (including quotes
2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"
Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[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 commented on TEIIDDES-2201:
-----------------------------------------
1) No PK/FKs - This is a processing problem in the designer DDL importer
2) Comments not processed - Currently the DDL parser is not handling this statement type
3) NUMBER type comes in as object - problem with Oracle type lookup in the designer DDL importer
1 & 3 - I have fixes and will try to get this in the 8.5 final build tomorrow
2 - we will need to log enhancement for parser (which is a Modeshape component) and work in 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
> 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)
10 years
[JBoss JIRA] (TEIIDDES-2201) DDL FILE importer generates inaccurate view model
by Tom Johnston (JIRA)
Tom Johnston created TEIIDDES-2201:
--------------------------------------
Summary: 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
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)
10 years