On Thu, Jun 02, 2011 at 03:15:03PM +0200, Martin Kersten wrote:
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 ..."
This suggests that the previous SQL statement in your .sql file was not properly terminated with a SemiCOLON ";".
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
------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |