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.