#1654 Unexpected Error when creating a View

[benmeng]

I am using HSQL for testing a project and got issues when creating views. Here is the sample statement I was trying to test and got exception with "unexpected end of statement" . I could not see any issue with the sql statment. Please let me know if I made any adjustment for the query I have.

CREATE VIEW IF NOT EXISTS "2000.XXXXX.MSG.CCCCCCC.view" AS SELECT * FROM "2000.XXXXX.MSG.CCCCCCC" LEFT JOIN "2000.XXXXX.MSG.CCCCCCC.FORMAT-IDENTIFIER" USING("2000.XXXXX.MSG.CCCCCCC.id") LEFT JOIN "2000.XXXXX.MSG.CCCCCCC.OOOOOOOO.SAMPLE" USING("2000.XXXXX.MSG.CCCCCCC.YYYY.id");

Thank you.

[Fred Toussi]

What is the error message?

[benmeng]

Hi Fred,

Thank you for your prompt response.

The error message I got is: "Unexpected end of statement"

Thank you.

[Fred Toussi]

The syntax is supported. You need to check that you execute the full statement to the end.