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@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@cwi.nl