[MonetDB-users] SQL Script execution behaviour

Niels Nes Niels.Nes at cwi.nl
Sat Dec 8 10:07:37 CET 2007


On Fri, Dec 07, 2007 at 06:24:17PM -0500, Venks wrote:
> Please find attached 2 scripts namely "test1.sql" and "test2.sql".
> 
> 1. First execute the script "test1.sql". You will get an error for
> each and every statement in the script and that's fine.
> 2. Execute the second script "test2.sql" which will create five simple
> tables and then execute "test1.sql" again.
> 
> You will see that the "test1.sql" script executes fine even though it
> should report errors after the last DELETE statement.
> 
> In short, it looks like the script stops executing after the first
> successful SQL statement. It should continue to report errors for all
> the COPY commands.

If you feel this is a bug please report this on the sourceforge bugreports.
That make looking (remembering the issues) so much easier for us.

Thanks

Niels



> 
> 
> Thanks,

> DELETE FROM test01 ;
> DELETE FROM test02 ;
> DELETE FROM test03 ;
> DELETE FROM test04 ;
> DELETE FROM test05 ;
> 
> COPY 10000 RECORDS INTO test01 FROM '/tmp/1.txt' USING DELIMITERS '|','\n' ;
> COPY 10000 RECORDS INTO test02 FROM '/tmp/2.txt' USING DELIMITERS '|','\n' ;
> COPY 10000 RECORDS INTO test03 FROM '/tmp/3.txt' USING DELIMITERS '|','\n' ;
> COPY 10000 RECORDS INTO test04 FROM '/tmp/4.txt' USING DELIMITERS '|','\n' ;
> COPY 10000 RECORDS INTO test05 FROM '/tmp/5.txt' USING DELIMITERS '|','\n' ;
> 
> ALTER TABLE test01 ADD COLUMN id INT AUTO_INCREMENT NOT NULL PRIMARY KEY ;
> ALTER TABLE test02 ADD COLUMN id INT AUTO_INCREMENT NOT NULL PRIMARY KEY ;

> CREATE TABLE test01 ( col1 INT ) ;
> CREATE TABLE test02 ( col1 INT ) ;
> CREATE TABLE test03 ( col1 INT ) ;
> CREATE TABLE test04 ( col1 INT ) ;
> CREATE TABLE test05 ( col1 INT ) ;

> -------------------------------------------------------------------------
> SF.Net email is sponsored by: 
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the users-list mailing list