[JBoss JIRA] Created: (TEIIDDES-216) Designer removes parentheses around criteria in ansi join when using compound ON
by Marc Shirley (JIRA)
Designer removes parentheses around criteria in ansi join when using compound ON
--------------------------------------------------------------------------------
Key: TEIIDDES-216
URL: https://jira.jboss.org/jira/browse/TEIIDDES-216
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 6.1.0
Reporter: Marc Shirley
In Designer, when validating a transformation that has compound criteria in an ansi join statement's ON,…
[View More] the parentheses are removed and the order of operations is modified as a result. This does not appear to occur when using the same parentheses structure in WHERE criteria.
Before validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON (a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL OR a.INTNUM = 11)
After validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON a.INTKEY = b.INTKEY AND (a.INTNUM IS NULL) OR (a.INTNUM = 11)
After validating a second time:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON ((a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL)) OR (a.INTNUM = 11)
--
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
[View Less]
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1207) Merge the relational and function metamodels
by Steven Hawkins (Created) (JIRA)
Merge the relational and function metamodels
--------------------------------------------
Key: TEIIDDES-1207
URL: https://issues.jboss.org/browse/TEIIDDES-1207
Project: Teiid Designer
Issue Type: Quality Risk
Components: Modeling
Affects Versions: 8.0
Reporter: Steven Hawkins
Having the function and relational models is no longer necessary. We can add the needed function metadata (including TEIIDDES-152 …
[View More]vararg support, null-on-null, etc.) through either extension properties or a metamodel change. This is in the vain of PostgreSQL which uses the create function syntax to add what would be procedures in other dbmses. Virtual functions (procedures marked as functions in a view layer) could also still specify transformation sql if pushdown is not required - rather than forcing the use of a java class.
We could deprecate the old function model support of the Teiid side then.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
12 years, 6 months
[JBoss JIRA] Created: (TEIIDDES-595) ModelAnnotations Are Created When Models Are Deleted
by Dan Florian (JIRA)
ModelAnnotations Are Created When Models Are Deleted
----------------------------------------------------
Key: TEIIDDES-595
URL: https://jira.jboss.org/browse/TEIIDDES-595
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.1
Reporter: Dan Florian
Just selected a model in the Model Explorer and deleted it. I noticed that the ModelAnnotationImpl constructor was being called when the …
[View More]model was being deleted. This doesn't seem right but doesn't seem to affect anything. Here is the stack trace:
Daemon Thread [Thread-0] (Suspended (breakpoint at line 389 in ModelAnnotationImpl))
ModelAnnotationImpl.<init>() line: 389
CoreFactoryImpl.createModelAnnotation() line: 127
CoreFactoryImpl.create(EClass) line: 53
MtkXmiHelper(XMLHelperImpl).createObject(EFactory, EClassifier) line: 891
MtkXmiHandler.createObjectFromFactory(EFactory, String) line: 161
MtkXmiHandler.createTopObject(String, String) line: 192
MtkXmiHandler(XMLHandler).processElement(String, String, String) line: 1019
MtkXmiHandler(XMIHandler).processElement(String, String, String) line: 87
MtkXmiHandler(XMLHandler).startElement(String, String, String) line: 1001
MtkXmiHandler.startElement(String, String, String) line: 769
MtkXmiHandler(XMLHandler).startElement(String, String, String, Attributes) line: 712
MtkXmiHandler(XMIHandler).startElement(String, String, String, Attributes) line: 169
SAXParserImpl$JAXPSAXParser(AbstractSAXParser).startElement(QName, XMLAttributes, Augmentations) line: 501
XMLDocumentScannerImpl(XMLDocumentFragmentScannerImpl).scanStartElement() line: 1363
XMLDocumentScannerImpl$ContentDriver(XMLDocumentFragmentScannerImpl$FragmentContentDriver).next() line: 2755
XMLDocumentScannerImpl.next() line: 648
XMLDocumentScannerImpl(XMLDocumentFragmentScannerImpl).scanDocument(boolean) line: 511
XIncludeAwareParserConfiguration(XML11Configuration).parse(boolean) line: 808
XIncludeAwareParserConfiguration(XML11Configuration).parse(XMLInputSource) line: 737
SAXParserImpl$JAXPSAXParser(XMLParser).parse(XMLInputSource) line: 119
SAXParserImpl$JAXPSAXParser(AbstractSAXParser).parse(InputSource) line: 1205
SAXParserImpl$JAXPSAXParser.parse(InputSource) line: 522
SAXParserImpl(SAXParser).parse(InputSource, DefaultHandler) line: 395
MtkXmiResourceLoader(XMLLoadImpl).load(XMLResource, InputStream, Map<?,?>) line: 181
MtkXmiResourceImpl.doLoad(InputStream, Map) line: 282
MtkXmiResourceImpl(ResourceImpl).load(InputStream, Map<?,?>) line: 1494
MtkXmiResourceImpl(ResourceImpl).load(Map<?,?>) line: 1282
MtkXmiResourceImpl.load(Map) line: 222
ModelBufferImpl.open(IProgressMonitor) line: 236
ModelResourceImpl.openBuffer(IProgressMonitor) line: 434
ModelResourceImpl(OpenableImpl).getBuffer() line: 381
ModelResourceImpl.refreshIndexType() line: 247
ModelWorkspaceManager$NotificationProcessor.refreshResourceIndexType(Object) line: 1162
ModelWorkspaceManager$NotificationProcessor.checkResourceForIndexing(Notification) line: 1137
ModelWorkspaceManager$NotificationProcessor.notifyChanged(Notification) line: 1151
ChangeNotifier.fireNotifyChanged(Notification) line: 51
UnitOfWorkImpl.commit() line: 251
ModelerCore.commitTxn() line: 356
DeleteResourceAction.closeResources(List) line: 324
DeleteResourceAction.doRun() line: 381
AbstractAction$1.run() line: 537
BusyIndicator.showWhile(Display, Runnable) line: 70
DeleteResourceAction(AbstractAction).run() line: 540
DeleteResourceAction(Action).runWithEvent(Event) line: 498
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
12 years, 7 months