]
Jan Stastny commented on TEIID-3212:
------------------------------------
ad 1) I didn't specify the LOAD_SCRIPT so the property is required that's alright,
but in the docs there is wrong property name. In doc is in the table:
teiid_rel:MATVIEW_STAGE_TABLE . But the vdb has to have teiid_rel:MATERIALIZED_STAGE_TABLE
property set. The naming is incorrect.
Materialized Views Documentation Issues
---------------------------------------
Key: TEIID-3212
URL:
https://issues.jboss.org/browse/TEIID-3212
Project: Teiid
Issue Type: Bug
Components: Documentation
Affects Versions: 8.7
Reporter: Jan Stastny
Assignee: Ramesh Reddy
Fix For: 8.10
On the documentation page
https://docs.jboss.org/author/display/teiid87final/External+Materialization there are
several inconsistencies within the text:
1. In doc property teiid_rel:MATVIEW_STAGE_TABLE is stated as optional, but in fact to
activate the vdb setting of property teiid_rel:MATERIALIZED_STAGE_TABLE is required which
is also in the sample code.
2. teiid_rel:MATVIEW_TTL stated as optional, but if not set error occurs on deploy.
3. In the table of properties is teiid_rel:ON_VDB_START_SCRIPT, but under the table there
is teiid_rel:ON_VDB_CREATE_SCRIPT property.
4. in the sample vdb definition the Cache Hint with the query is misleading, as the
teiid_rel:MATVIEW_TTL is required. In sync with issue TEIID-3209.
On the
https://docs.jboss.org/author/display/teiid87final/Internal+Materialization page:
1. in section "Updatable" the "Update SQL" query calls wrong
procedure. It calls updateMatViewRow, but should call refreshMatViewRow as is stated in
the surrounding text.