Details
-
Feature Request
-
Resolution: Done
-
Blocker
-
7.3
-
None
-
Documentation (Ref Guide, User Guide, etc.)
Description
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"