Debbie Steigner created TEIIDDES-2806: ----------------------------------------- Summary: 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 Affects Versions: 9.2, 9.0.3 Reporter: Debbie Steigner Assignee: Barry LaFond 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. -- This message was sent by Atlassian JIRA (v6.4.11#64026)