[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-806) Provide UI changes required for changes to behavior of Update queries in Teiid

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, new-update-tabs-decoration_REV_A.png, override-user-sql.png, status.patch, TEIIDDES-806-IRC-1.txt, teiid_embedded_query_updatevalidator.patch, UpdateValidator.patch 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"