[teiid-designer-issues] [JBoss JIRA] Assigned: (TEIIDDES-518) DTP context menu options on Teiid tables should consider whether virtual model supports update.

DTP context menu options on Teiid tables should consider whether virtual model supports update. ----------------------------------------------------------------------------------------------- Key: TEIIDDES-518 URL: https://issues.jboss.org/browse/TEIIDDES-518 Project: Teiid Designer Issue Type: Bug Components: VDB & Execution Affects Versions: 7.0 Environment: Teiid Designer 7.0 + JBoss Dev Studio 3.0.1GA Teiid 7.1 Alpha on EAP 5.1 RHEL 6, OpenJDK 1.6 Reporter: Ken Johnson Fix For: 8.0 In DTP, Context menu for Table contains several options under Data->(Edit, Load, Extract, Sample Contents). For virtual tables, Extract and Sample Contents are fine. Edit and Load will attempt to write data. Thus a few issues: a) These options should be disabled if the table in question does not have Supports Update checked. b) These options should be tested when the table *does* have Update and Insert procedures defined. c) Tables in SYS schema should never be writable. When working with physical tables, all options should be available and work correctly. Cursory testing indicates this is the case - at least with a MySQL data source underlying the model.