Creating a view for Dynamic VDB - strange Parser exception

[teiiduser]

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!

[shawkins]

values is a reserved word.  It will work as a quoted identifier - "values"