[TEIIDDES-2788] Access Pattern not generated when exporting dynamic VDB - JBoss Issue Tracker

XML

Word

Printable

Steps to Reproduce:
1. import the attached project
2. export a dynamic VDB from the VDB archive, notice the DDL does not contain access pattern constraints

When exporting a dynamic VDB, access pattern constrains on model tables are not exported.

Actual DDL:

CREATE FOREIGN TABLE s1 (

	newColumn_1 string(4000),

	newColumn_2 string(4000)

Expected DDL:

CREATE FOREIGN TABLE s1 (

	newColumn_1 string(4000),

	newColumn_2 string(4000),

	CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1)

is incorporated by

TEIIDDES-2699 Issues with Dynamic VDB import/export