[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2931) Dynamic VDB doesn't contains updateble option

Dynamic VDB doesn't contains updateble option --------------------------------------------- Key: TEIIDDES-2931 URL: https://issues.jboss.org/browse/TEIIDDES-2931 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs Affects Versions: 10.0.2 Reporter: Matej Kralik Priority: Critical Attachments: updateProject.zip I have source model which have a table which has support updatable to 'true' and all its columns have updatable to 'true'. I create vdb, deploy and execute insert query. The query is successful but when I create dynamicVDB and deploy, insert query doesn't pass and server shows error: Metadata does not allow updates on the group current {code:java} OPTIONS(NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60') {code} expected: {code:java} OPTIONS(UPDATABLE 'TRUE',NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60') {code} This influence JDG metadata because when I deploy dynamic vdb with materialization, the server shows an error that status table (and others tables which should be updatable) don't allow updates. {code:java} TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ((updateStmt || ' AND loadNumber = ') || matcursor.loadNumber) USING loadNumber = (matcursor.loadNumber + 1), vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'LOADING', valid = (matcursor.valid) AND (NOT (invalidate)), cardinality = matcursor.cardinality" with the SQL statement "UPDATE sourceMSQmodel.testJDG.status SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = 59" due to: TEIID30492 Metadata does not allow updates on the group: sourceMSQmodel.testJDG.status {code}