February 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Work logged: (TEIID-16) view layers cannot be merged with non-deterministic projected symbols

by Larry O'Leary (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-16?page=com.atlassian.jira.plugi... ] Larry O'Leary logged work on TEIID-16: -------------------------------------- Author: Larry O'Leary Created on: 11/Feb/09 05:26 PM Start Date: 11/Feb/09 05:23 PM Worklog Time Spent: 1 hour, 30 minutes Work Description: Committed changes made in R050501 to Teiid. Updated com.metamatrix.query.optimizer.relational.rules.RuleMergeVirtual.checkProjectedSymbols() to check symbol for non-deterministic functions. Added com.metamatrix.query.optimizer.TestJoinWithFunction and com.metamatrix.query.processor.TestJoinWithFunction TestCase. Issue Time Tracking ------------------- Remaining Estimate: 0 minutes Time Spent: 1 hour, 30 minutes > view layers cannot be merged with non-deterministic projected symbols > --------------------------------------------------------------------- > > Key: TEIID-16 > URL: https://jira.jboss.org/jira/browse/TEIID-16 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Larry O'Leary > Fix For: 6.0.0 > > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 0 minutes > > Defect Tracker #24747: Non-deterministic functions used in the select clause of a nested view may prevent the view from being removed if the expression is used in more than one place in the upper view. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIID-16) view layers cannot be merged with non-deterministic projected symbols

by Larry O'Leary (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-16?page=com.atlassian.jira.plugi... ] Larry O'Leary resolved TEIID-16. -------------------------------- Resolution: Done Issue is covered by UnitTest. > view layers cannot be merged with non-deterministic projected symbols > --------------------------------------------------------------------- > > Key: TEIID-16 > URL: https://jira.jboss.org/jira/browse/TEIID-16 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Larry O'Leary > Fix For: 6.0.0 > > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 0 minutes > > Defect Tracker #24747: Non-deterministic functions used in the select clause of a nested view may prevent the view from being removed if the expression is used in more than one place in the upper view. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-342) Quick Start Example at teiid.org refers to Modeler, instead of Designer, in multiple places

by Van Halbert (JIRA)

Quick Start Example at teiid.org refers to Modeler, instead of Designer, in multiple places -------------------------------------------------------------------------------------------- Key: TEIID-342 URL: https://jira.jboss.org/jira/browse/TEIID-342 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 6.0.0 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Minor The Quick Start example refers to the Designer as the Modeler in multiple places. Don't think we want to mix the terms. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

2
1
0 / 0

[JBoss JIRA] Created: (TEIID-343) SQLTranslators are held per connection, but are inited for each execution

by Steven Hawkins (JIRA)

SQLTranslators are held per connection, but are inited for each execution ------------------------------------------------------------------------- Key: TEIID-343 URL: https://jira.jboss.org/jira/browse/TEIID-343 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.0.0 This is problematic for several reasons. One the runtimemetadata is expected by the sqltranslator, but that is an execution level context - multiple models from different vdbs may be assigned to the same connector. Also the initialize method is still called, which incurs the cost rebuilding the modifiers. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
1
0 / 0

[JBoss JIRA] Moved: (TEIID-344) Lower-level mapping class transformations (like Authors) do not validate properly

by Steve Jacobs (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-344?page=com.atlassian.jira.plug... ] Steve Jacobs moved FEDDES-35 to TEIID-344: ------------------------------------------ Project: Teiid (was: Federate Designer) Key: TEIID-344 (was: FEDDES-35) Component/s: (was: Transformations) Fix Version/s: (was: 6.0) Affects Version/s: (was: 6.0) > Lower-level mapping class transformations (like Authors) do not validate properly > --------------------------------------------------------------------------------- > > Key: TEIID-344 > URL: https://jira.jboss.org/jira/browse/TEIID-344 > Project: Teiid > Issue Type: Bug > Environment: fedora 10 > Reporter: Paul Nittel > Assignee: Barry LaFond > Priority: Blocker > > You can quickly get a sense of this by importing the Books example project; neither of the authors mapping class transformations validate. If you create your own model you should find the text of the transformation does not display without additional work on your part. Even if you can get it to display it doesn't validate. > I thought I'd already entered this, but cannot find it, so... > Here's an exception from the Eclipse console: > !ENTRY com.metamatrix.query.ui 4 0 2008-12-17 12:07:12.546 > !MESSAGE java.lang.IllegalArgumentException:com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction() > !STACK 0 > java.lang.IllegalArgumentException: Expected argument to be an instance of com.metamatrix.modeler.core.metadata.runtime.MetadataRecord; was instance of com.metamatrix.query.sql.symbol.ElementSymbol > at com.metamatrix.core.util.ArgCheck.isInstanceOf(ArgCheck.java:355) > at com.metamatrix.core.util.ArgCheck.isInstanceOf(ArgCheck.java:339) > at com.metamatrix.modeler.transformation.metadata.TransformationMetadata.getFullName(TransformationMetadata.java:200) > at com.metamatrix.query.metadata.TempMetadataAdapter.getFullName(TempMetadataAdapter.java:149) > at com.metamatrix.query.sql.util.ElementSymbolOptimizer.mapShortNamesToGroups(ElementSymbolOptimizer.java:241) > at com.metamatrix.query.sql.util.ElementSymbolOptimizer.optimizeCommand(ElementSymbolOptimizer.java:206) > at com.metamatrix.query.sql.util.ElementSymbolOptimizer.optimizeElements(ElementSymbolOptimizer.java:177) > at com.metamatrix.query.sql.util.ElementSymbolOptimizer.optimizeElements(ElementSymbolOptimizer.java:130) > at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.optimize(QueryDisplayComponent.java:1159) > at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.setText(QueryDisplayComponent.java:196) > at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:428) > at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:485) > at com.metamatrix.modeler.transformation.ui.editors.TransformationObjectEditorPage.setEditorContent(TransformationObjectEditorPage.java:1148) > at com.metamatrix.modeler.transformation.ui.editors.TransformationObjectEditorPage.handleTransformationStatusChangeEvent(TransformationObjectEditorPage.java:1591) > at com.metamatrix.modeler.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2672) > at com.metamatrix.modeler.internal.transformation.util.SqlMappingRootCache.notifyEventListeners(SqlMappingRootCache.java:1164) > at com.metamatrix.modeler.internal.transformation.util.SqlMappingRootCache.invalidateStatus(SqlMappingRootCache.java:531) > at com.metamatrix.modeler.internal.transformation.util.SqlMappingRootCache.invalidateSelectStatus(SqlMappingRootCache.java:102) > at com.metamatrix.modeler.internal.transformation.util.SqlMappingRootCache.invalidateSelectStatus(SqlMappingRootCache.java:94) > at com.metamatrix.modeler.internal.transformation.util.TransformationHelper.setSqlString(TransformationHelper.java:548) > at com.metamatrix.modeler.internal.transformation.util.TransformationHelper.setSelectSqlString(TransformationHelper.java:485) > at com.metamatrix.modeler.internal.transformation.util.TransformationSqlHelper.addSqlAliasGroupsToSelectStatement(TransformationSqlHelper.java:479) > at com.metamatrix.modeler.internal.transformation.util.TransformationSqlHelper.updateSelectSqlOnSqlAliasGroupsAdded(TransformationSqlHelper.java:283) > at com.metamatrix.modeler.internal.transformation.util.TransformationSqlHelper.updateAllSqlOnSqlAliasGroupsAdded(TransformationSqlHelper.java:187) > at com.metamatrix.modeler.transformation.ui.util.TransformationNotificationListener.handleSqlAliasAddNotifications(TransformationNotificationListener.java:997) > at com.metamatrix.modeler.transformation.ui.util.TransformationNotificationListener.handleNotifications(TransformationNotificationListener.java:227) > at com.metamatrix.modeler.transformation.ui.util.TransformationNotificationListener.notifyChanged(TransformationNotificationListener.java:174) > at com.metamatrix.modeler.internal.ui.viewsupport.ModelUtilities$ContainerNotificationManager.fireNotification(ModelUtilities.java:1799) > at com.metamatrix.modeler.internal.ui.viewsupport.ModelUtilities$ContainerNotificationManager.notifyChanged(ModelUtilities.java:1743) > at org.eclipse.emf.edit.provider.ChangeNotifier.fireNotifyChanged(ChangeNotifier.java:51) > at com.metamatrix.modeler.internal.core.transaction.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:260) > at com.metamatrix.modeler.core.ModelerCore.commitTxn(ModelerCore.java:1603) > at com.metamatrix.modeler.transformation.ui.actions.AddTransformationSourceAction.doRun(AddTransformationSourceAction.java:162) > at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:563) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:566) > at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) > at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583) > at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500) > at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1158) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3401) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3033) > at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382) > at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346) > at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198) > at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493) > at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288) > at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488) > at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) > at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113) > at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193) > 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:386) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549) > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504) > at org.eclipse.equinox.launcher.Main.run(Main.java:1236) > at org.eclipse.equinox.launcher.Main.main(Main.java:1212) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-309) System Host setup issues

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-309?page=com.atlassian.jira.plug... ] Van Halbert commented on TEIID-309: ----------------------------------- Done: #2, 5 and 6 ( 4 already done) Left to do: #1 and 3 > System Host setup issues > ------------------------ > > Key: TEIID-309 > URL: https://jira.jboss.org/jira/browse/TEIID-309 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 6.0.0 > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 6.1.0 > > > 1) izpack does not make the startserver, stopserver, scripts as executable in the linux > 2) There is no option for *not* starting the server (either way it does not look like starting the server). This option should be extended to "setupmm" driven process too, with additional property. > 3) multicast port is not available in the IZpack + it is hard coded; Any two machines are seeing each other on the same multicast address. This needs to be fixed as soon as possible.(FEDERATE-340) > 4) System name is always defaulting to $hostname, even when it is blank. I fixed this in install. > 5) With "systenhostsetup.sh" I can not pass in the properties file, it is looking for the file in a fixed location. > 6) systemhostsetup.sh creates the "metamatrix.properties" file, but does not write to the configuration about what it's config name is, thus never can be started. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Work started: (TEIID-309) System Host setup issues

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-309?page=com.atlassian.jira.plug... ] Work on TEIID-309 started by Van Halbert. > System Host setup issues > ------------------------ > > Key: TEIID-309 > URL: https://jira.jboss.org/jira/browse/TEIID-309 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Affects Versions: 6.0.0 > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 6.1.0 > > > 1) izpack does not make the startserver, stopserver, scripts as executable in the linux > 2) There is no option for *not* starting the server (either way it does not look like starting the server). This option should be extended to "setupmm" driven process too, with additional property. > 3) multicast port is not available in the IZpack + it is hard coded; Any two machines are seeing each other on the same multicast address. This needs to be fixed as soon as possible.(FEDERATE-340) > 4) System name is always defaulting to $hostname, even when it is blank. I fixed this in install. > 5) With "systenhostsetup.sh" I can not pass in the properties file, it is looking for the file in a fixed location. > 6) systemhostsetup.sh creates the "metamatrix.properties" file, but does not write to the configuration about what it's config name is, thus never can be started. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIID-187) If the Datasource supports it, send the ANSI syntax in Source Query

by Steven Hawkins (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-187?page=com.atlassian.jira.plug... ] Steven Hawkins updated TEIID-187: --------------------------------- Component/s: Connector API Affects: [Documentation (Ref Guide, User Guide, etc.), Compatibility/Configuration, Release Notes] > If the Datasource supports it, send the ANSI syntax in Source Query > ------------------------------------------------------------------- > > Key: TEIID-187 > URL: https://jira.jboss.org/jira/browse/TEIID-187 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Affects Versions: 6.0.0 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 6.0.0 > > > If the Datasource supports it, send the ANSI syntax in Source Query. > Reference Issue Tracker Ticket# 183202 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-187) If the Datasource supports it, send the ANSI syntax in Source Query

by Steven Hawkins (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-187?page=com.atlassian.jira.plug... ] Steven Hawkins closed TEIID-187. -------------------------------- Added to the cdk docs. The property on connector capabilities is useAnsiJoin > If the Datasource supports it, send the ANSI syntax in Source Query > ------------------------------------------------------------------- > > Key: TEIID-187 > URL: https://jira.jboss.org/jira/browse/TEIID-187 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Affects Versions: 6.0.0 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 6.0.0 > > > If the Datasource supports it, send the ANSI syntax in Source Query. > Reference Issue Tracker Ticket# 183202 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-116) Limit clause does not work with XML queries

by Steven Hawkins (JIRA)

[ https://jira.jboss.org/jira/browse/TEIID-116?page=com.atlassian.jira.plug... ] Steven Hawkins closed TEIID-116. -------------------------------- Resolution: Done updated validation visitor, added TestValidationVisitor.testXmlQueryWithLimit > Limit clause does not work with XML queries > ------------------------------------------- > > Key: TEIID-116 > URL: https://jira.jboss.org/jira/browse/TEIID-116 > Project: Teiid > Issue Type: Bug > Components: XML Planner/Processor > Affects Versions: 6.x > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Optional > Fix For: 6.0.0 > > Original Estimate: 1 hour > Remaining Estimate: 1 hour > > Defect Tracker #24430: Limit clause does not work with XML queries it probably should probably work the same as specifying the rowlimit function on the root mapping class(es) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2009