]
Matej Kralik commented on TEIIDDES-2788:
----------------------------------------
A similar situation is when I want to export a model which contains a table with access
pattern to the teiid DDL. Generated DDL doesn't contain access pattern.
Import teiid DDL which contains access pattern (for example CONSTRAINT NewAccessPattern
ACCESSPATTERN (newColumn_1) ) works fine. The designer generates the valid model with the
access pattern.
Access Pattern not generated when exporting dynamic VDB
-------------------------------------------------------
Key: TEIIDDES-2788
URL:
https://issues.jboss.org/browse/TEIIDDES-2788
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 9.0.4
Reporter: Andrej Šmigala
Attachments: APproj.zip
When exporting a dynamic VDB, access pattern constrains on model tables are not
exported.
Actual DDL:
{code:sql}
CREATE FOREIGN TABLE s1 (
newColumn_1 string(4000),
newColumn_2 string(4000)
)
{code}
Expected DDL:
{code:sql}
CREATE FOREIGN TABLE s1 (
newColumn_1 string(4000),
newColumn_2 string(4000),
CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1)
)
{code}