1 Reply Latest reply on Apr 30, 2014 1:58 PM by Steven Hawkins

    Creating a view for Dynamic VDB - strange Parser exception

    teiiduser Newbie

      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!