[JBoss JIRA] (TEIIDDES-1669) Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1669?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-1669.
-------------------------------------
Resolution: Done
isolated problem to TransformationSqlHelper.getElementSymbolType. Was not getting the type for other possibilities. Retested ok.
https://github.com/Teiid-Designer/teiid-designer/pull/163
> Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias
> ---------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1669
> URL: https://issues.jboss.org/browse/TEIIDDES-1669
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.1
> Environment: JBDS 6.0.1.GA, Teiid 8.2, OSX 10.8.3
> Reporter: Dan Florian
> Assignee: Mark Drilling
> Fix For: 8.2
>
>
> Create a source model (SourceModel) with one table (SourceTable) that has one column (sourceColumn) of type int. Created a virtual model (VirtualModel) with one table (ViewTable). Opened the transformation editor and entered:
> SELECT SUM(SourceModel.SourceTable.sourceColumn) AS viewColumn FROM SourceModel.SourceTable
> The "viewColumn" column was generated without a data type. Because we know the return type of the function, and the datatype resolver knows how to resolve, the data type should've been determined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1669) Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1669?page=com.atlassian.jira.plu... ]
Mark Drilling reassigned TEIIDDES-1669:
---------------------------------------
Assignee: Mark Drilling
> Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias
> ---------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1669
> URL: https://issues.jboss.org/browse/TEIIDDES-1669
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.1
> Environment: JBDS 6.0.1.GA, Teiid 8.2, OSX 10.8.3
> Reporter: Dan Florian
> Assignee: Mark Drilling
> Fix For: 8.2
>
>
> Create a source model (SourceModel) with one table (SourceTable) that has one column (sourceColumn) of type int. Created a virtual model (VirtualModel) with one table (ViewTable). Opened the transformation editor and entered:
> SELECT SUM(SourceModel.SourceTable.sourceColumn) AS viewColumn FROM SourceModel.SourceTable
> The "viewColumn" column was generated without a data type. Because we know the return type of the function, and the datatype resolver knows how to resolve, the data type should've been determined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1733) IllegalArgumentException right-clicking with 2 or more projects selected
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1733?page=com.atlassian.jira.plu... ]
Paul Richardson resolved TEIIDDES-1733.
---------------------------------------
Resolution: Done
See pull [request|https://github.com/Teiid-Designer/teiid-designer/pull/160]
> IllegalArgumentException right-clicking with 2 or more projects selected
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1733
> URL: https://issues.jboss.org/browse/TEIIDDES-1733
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.2
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.2
>
>
> java.lang.IllegalArgumentException: can't find ID "properties"
> at org.eclipse.jface.action.ContributionManager.insertAfter(ContributionManager.java:334)
> at org.teiid.designer.ui.common.actions.ExtendedMenuManager.insertAfter(ExtendedMenuManager.java:147)
> at org.eclipse.jface.action.ContributionManager.insertAfter(ContributionManager.java:325)
> at org.teiid.designer.ui.common.actions.ExtendedMenuManager.insertAfter(ExtendedMenuManager.java:129)
> at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.overrideAction(ModelExplorerResourceNavigator.java:959)
> at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.fillContextMenu(ModelExplorerResourceNavigator.java:1122)
> at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator$13.menuAboutToShow(ModelExplorerResourceNavigator.java:935)
> at org.eclipse.jface.action.MenuManager.fireAboutToShow(MenuManager.java:343)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1733) IllegalArgumentException right-clicking with 2 or more projects selected
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-1733:
--------------------------------------
Summary: IllegalArgumentException right-clicking with 2 or more projects selected
Key: TEIIDDES-1733
URL: https://issues.jboss.org/browse/TEIIDDES-1733
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 8.2
Reporter: Barry LaFond
Assignee: Paul Richardson
Priority: Critical
Fix For: 8.2
java.lang.IllegalArgumentException: can't find ID "properties"
at org.eclipse.jface.action.ContributionManager.insertAfter(ContributionManager.java:334)
at org.teiid.designer.ui.common.actions.ExtendedMenuManager.insertAfter(ExtendedMenuManager.java:147)
at org.eclipse.jface.action.ContributionManager.insertAfter(ContributionManager.java:325)
at org.teiid.designer.ui.common.actions.ExtendedMenuManager.insertAfter(ExtendedMenuManager.java:129)
at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.overrideAction(ModelExplorerResourceNavigator.java:959)
at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator.fillContextMenu(ModelExplorerResourceNavigator.java:1122)
at org.teiid.designer.ui.explorer.ModelExplorerResourceNavigator$13.menuAboutToShow(ModelExplorerResourceNavigator.java:935)
at org.eclipse.jface.action.MenuManager.fireAboutToShow(MenuManager.java:343)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1732) Stream line steps to implement all the steps around materialization
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1732?page=com.atlassian.jira.plu... ]
Van Halbert updated TEIIDDES-1732:
----------------------------------
Description:
Would like to stream line the steps to putting materialization to work. Example:
- Right mouse click on view, select materialization
- present wizard to walk thru the following options:
- create physical table based on selected view/table (export/import of ddl is supported, but would like the table automatically created)
- put name of mat table into the selected table/view to be materialized
- [optional] export DDL (file system or clipboard)
- [optional] create procedure that has the "select into" for refreshing
Having the procedure provides the immediate ability to call to refresh, without having to remember what tables. Also, with the feature of native queries, could add the truncate call to clear the table.
Once thru this wizard, (I think) everything is in place to do materialization for the specified table.
was:
Would like to stream line the steps to putting materialization to work. Example:
- Right mouse click on view, select materialization
- present wizard to walk thru the following options:
- create physical table based on selected view/table (export/import of ddl is supported, but would like the table automatically created)
- put name of name into the selected table/view to be materialized
- [optional] export DDL (file system or clipboard)
- [optional] create procedure that has the "select into" for refreshing
Having the procedure provides the immediate ability to call to refresh, without having to remember what tables. Also, with the feature of native queries, could add the truncate call to clear the table.
Once thru this wizard, (I think) everything is in place to do materialization for the specified table.
> Stream line steps to implement all the steps around materialization
> --------------------------------------------------------------------
>
> Key: TEIIDDES-1732
> URL: https://issues.jboss.org/browse/TEIIDDES-1732
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Modeling
> Affects Versions: 8.2
> Reporter: Van Halbert
>
> Would like to stream line the steps to putting materialization to work. Example:
> - Right mouse click on view, select materialization
> - present wizard to walk thru the following options:
> - create physical table based on selected view/table (export/import of ddl is supported, but would like the table automatically created)
> - put name of mat table into the selected table/view to be materialized
> - [optional] export DDL (file system or clipboard)
> - [optional] create procedure that has the "select into" for refreshing
> Having the procedure provides the immediate ability to call to refresh, without having to remember what tables. Also, with the feature of native queries, could add the truncate call to clear the table.
> Once thru this wizard, (I think) everything is in place to do materialization for the specified table.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month