Status: Closed (View Workflow)
Affects Version/s: 10.0.1
Fix Version/s: 10.0.2
Steps to Reproduce:
- import project
- create data source from source model
- preview date (new_table)
- change name
- preview data again (new_table)
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.