]
Barry LaFond commented on TEIIDDES-2858:
----------------------------------------
It appears the basic Teiid DDL Sequencer strips double-quotes off of identifiers. The
StandardDdlParser in Modeshape does the same thing.
So not sure how to fix this except to look for reserved words in the Parser and keep the
double-quotes in the AstNode OR we perform the reserved word check whenever we export from
MS or import as DDL via Modeshape.
DDL Importer does drops quotes from quoted column names
-------------------------------------------------------
Key: TEIIDDES-2858
URL:
https://issues.jboss.org/browse/TEIIDDES-2858
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview, Dynamic VDBs
Affects Versions: 10.0.1
Environment: Fedora 23
Reporter: Matej Kralik
Assignee: Barry LaFond
Fix For: 10.0.2
Attachments: remoteXML.zip, screenshot1.png, screenshot2.png
When I wanted preview date from the table which contains column with specific name,
server shows me this error:
TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at
line 8, column 9.
Was expecting: "constraint" | "foreign" | "primary" |
"unique" | id
I looked on the DDL which designer generated (screenshot1) and I think that column TIME
should be between quotation marks.
"YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE
'FALSE')
When I change column name from TIME to "TIME", the preview passed and showed me
data. (screenshot2)
A similar situation is when I generated dynamic VDB.