[teiid-designer-issues] [JBoss JIRA] Issue Comment Edited: (TEIIDDES-806) Provide UI changes required for changes to behavior of Update queries in Teiid
[
https://issues.jboss.org/browse/TEIIDDES-806?page=com.atlassian.jira.plug...
]
Barry LaFond edited comment on TEIIDDES-806 at 2/2/11 9:41 PM:
---------------------------------------------------------------
Screen cap of Transformation Editor with Insert/Update/Delete tabs decorated to show which
types of procedures allow updates based on:
1) Use Default == TRUE
2) The Select query is understood by the Teiid Query engine and can create a default
update procedure.
If a specific update type is deemed "not updatable", then the tooltip (shown in
screen pic) will indicate the first error or warning provided via the Select SQL
validation.
If any update type is set to "Use Default == FALSE" then it is assumed that the
user will define the update SQL in that tab
was (Author: blafond):
Screen cap of Transformation Editor with Insert/Update/Delete tabs decorated to show
which types of procedures allow updates based on 1) Use Default == TRUE and 2) The Select
query is understood by the Teiid Query engine and can create a default update procedure.
Provide UI changes required for changes to behavior of Update queries
in Teiid
------------------------------------------------------------------------------
Key: TEIIDDES-806
URL: https://issues.jboss.org/browse/TEIIDDES-806
Project: Teiid Designer
Issue Type: Feature Request
Components: Documentation, Editors, Transformations
Affects Versions: 7.3
Reporter: Barry LaFond
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.3
Attachments: new-update-tabs-decoration.png
Teiid 7.3 release included changes to how Teiid processes Update queries. Teiid Designer
will need to change the Transformation Editor to accommodate these changes.
The "Select" SQL will now be "analyzed" and validated to determine
what "Update" capabilities will be enabled. The generated "Default"
queries should also be removed and NO SQL defined if "Use Default" is enabled
for Insert/Update/Delete
This is a departure from our legacy user experience, so the UI will have to be tweaked to
recognize and interpret the new validation logic and display to user whether
Insert/Update/Delete will be possible base don the Select.
One thought was decorating the I/U/D tab text with ICONS's to indicate
"Allowed" or "Disallowed"
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira