[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2806) Generate Dynamic VDB: Columns with non-standard characters end up in the resulting xml without quotes, resulting in a an undeployable vdb

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.