Hello,
I am creating a view for my dynamic vdb. It gives a strange parser exception
I have as my columns :
.....
col1 varchar(4000),
values blob,
col2 blob,
create_date timestamp,
.......
TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "4000), [*]values[*] blob," at line 513, column 1. Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
If I change the order to
col1 varchar(4000),
col2 blob,
values blob,
create_date timestamp,
TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "col2 blob, [*]values[*] blob," at line 514, column 1. Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
NOTE : If I change it to vals blob,
There is no exception.
Can anyone tell me what could be wrong with the syntax here?
Thanks!
values is a reserved word. It will work as a quoted identifier - "values"