On 6/2/11 3:02 PM, Lowterm wrote:
Hi,
what's the meaning of this syntax error?
Syntax error, unexpected CREATE, expecting SCOLON in: "create ..."
I get this message with the "create table" if I load a Files with "sql>\< filename", which contains this statement. The create-statement works, if I insert it directly.
That is not correct, because the syntax is wrong (!) ON UPDATE CURRENT_TIMESTAMP is not supported by SQL2003. see the reference manual: http://www.monetdb.org/Documentation/Manuals/SQLreference/Tables
The second error message ist:
syntax error, unexpected ON, expecting ')' or ',' in: "create ..." in the following create statement:
CREATE TABLE dim_warehouse ( is_current smallint NOT NULL, last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP )
but I can not see wath is wrong.
Thanks