This content has been marked as final.
Show 4 replies
-
1. Re: QueryParserException while creating views in DDL
rakeshsagar Sep 20, 2013 8:15 AM (in response to rakeshsagar)Can someone pleasee help me with this issue?
-
2. Re: QueryParserException while creating views in DDL
rareddy Sep 20, 2013 8:26 AM (in response to rakeshsagar) -
3. Re: QueryParserException while creating views in DDL
shawkins Sep 20, 2013 8:33 AM (in response to rakeshsagar)I think you are being lead astray by the DDL Metadata documentation page. When there is ever any doubt, go by the grammar BNF for SQL Grammar - Teiid 8.6 (draft) - Project Documentation Editor or the exception message. In this case you need a comma ahead of CONSTRAINT - also if you use the CONSTRAINT keyword, then the parser will expect it to be a named constraint. We'll update the DDL Metadata documentation page.
-
4. Re: QueryParserException while creating views in DDL
rakeshsagar Sep 23, 2013 12:50 AM (in response to shawkins)Adding a comma and also a name to the constraint solved the problem.
Thanks Steve and Ramesh.