]
Barry LaFond commented on TEIIDDES-2931:
----------------------------------------
Teiid Documentation states the following, but does not define the default value.
UPDATABLE 'TRUE'|'FALSE' Defines if the view is allowed to update or not
The DDL generator is currently assuming the default is TRUE in the runtime.
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}