]
Barry LaFond updated TEIIDDES-2806:
-----------------------------------
Component/s: Patch Release
Generate Dynamic VDB: Columns with non-standard characters end up in
the resulting xml without quotes, resulting in a an undeployable vdb
------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-2806
URL:
https://issues.jboss.org/browse/TEIIDDES-2806
Project: Teiid Designer
Issue Type: Feature Request
Components: Dynamic VDBs, Patch Release
Affects Versions: 9.0.3, 9.2
Reporter: Debbie Steigner
Assignee: Barry LaFond
Fix For: 10.0.2
The Teiid vdb has column named e.g. PE$HOME. When I generate a dynamic vdb xml from this
model, the xml document contains:
CREATE FOREIGN TABLE MYTABLE (
ID string(40) NOT NULL,
NAME string(40),
PE$HOME string(19) NOT NULL,
CONSTRAINT FKI_MY_VIEW PRIMARY KEY(ID)
)
When i deploy this, it fails because P$HOME is not allowed as column name.
I expect to see this name "quoted" in the xml vdb:
CREATE FOREIGN TABLE MYTABLE (
"ID" string(40) NOT NULL,
"NAME" string(40),
"PE$HOME" string(19) NOT NULL,
CONSTRAINT FKI_MY_VIEW PRIMARY KEY(ID)
)
Proposed solution: always use "quotes" in source and view xml vdb, both for the
column names, and the mapping statement.