Update of /cvsroot/monetdb/sql/src/test/copy/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16393
Modified Files:
int_parse.stable.err int_parse.stable.out
load_incorrect_line_nr.stable.err
load_incorrect_line_nr.stable.out
Log Message:
approved new errors (and correctly missing rows)
U load_incorrect_line_nr.stable.out
Index: load_incorrect_line_nr.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/copy/Tests/load_incorrect_line_nr.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- load_incorrect_line_nr.stable.out 9 Aug 2009 12:13:10 -0000 1.2
+++ load_incorrect_line_nr.stable.out 10 Aug 2009 06:09:48 -0000 1.3
@@ -25,13 +25,10 @@
# 13:54:35 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34075
# 13:54:35 >
-[ 2 ]
% sys.number # table_name
% isanumber # name
% int # type
% 1 # length
-[ 1 ]
-[ NULL ]
# 16:52:10 >
# 16:52:10 > Done.
U load_incorrect_line_nr.stable.err
Index: load_incorrect_line_nr.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/copy/Tests/load_incorrect_line_nr.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- load_incorrect_line_nr.stable.err 9 Aug 2009 12:13:10 -0000 1.2
+++ load_incorrect_line_nr.stable.err 10 Aug 2009 06:09:48 -0000 1.3
@@ -65,15 +65,16 @@
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf)
-# 16:52:10 >
-# 16:52:10 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=32084
-# 16:52:10 >
-
-MAPI = mone...@eir:34075
-QUERY = COPY 2 RECORDS INTO "number" FROM
'/ufs/mk/monet5/package/sql/src/test/copy/Tests/load_incorrect_line_nr.dat'
USING DELIMITERS ';', '\n';
+# 22:56:13 >
+# 22:56:13 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=34976
+# 22:56:13 >
+MAPI = mone...@alf:34976
+QUERY = COPY 2 RECORDS INTO "number" FROM
'/net/alf.ins.cwi.nl/export/scratch1/niels/monetdb/sql/src/test/copy/Tests/load_incorrect_line_nr.dat'
USING DELIMITERS ';', '\n';
+ERROR = !SQLException:sql:value 'bla' from line 2 field 1 not inserted,
expecting type int
+ !SQLException:importTable:failed to import table
-# 16:52:10 >
-# 16:52:10 > Done.
-# 16:52:10 >
+# 22:56:13 >
+# 22:56:13 > Done.
+# 22:56:13 >
U int_parse.stable.out
Index: int_parse.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/copy/Tests/int_parse.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- int_parse.stable.out 9 Aug 2009 12:13:10 -0000 1.2
+++ int_parse.stable.out 10 Aug 2009 06:09:48 -0000 1.3
@@ -25,17 +25,12 @@
# 13:54:35 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34075
# 13:54:35 >
-[ 4 ]
% sys.t_int # table_name
% i # name
% int # type
% 1 # length
-[ 1 ]
-[ NULL ]
-[ NULL ]
-[ NULL ]
-# 13:54:35 >
-# 13:54:35 > Done.
-# 13:54:35 >
+# 22:56:12 >
+# 22:56:12 > Done.
+# 22:56:12 >
U int_parse.stable.err
Index: int_parse.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/copy/Tests/int_parse.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- int_parse.stable.err 9 Aug 2009 12:13:10 -0000 1.2
+++ int_parse.stable.err 10 Aug 2009 06:09:48 -0000 1.3
@@ -79,9 +79,10 @@
# 19:40:24 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=37659
# 19:40:24 >
-MAPI = mone...@eir:34075
+MAPI = mone...@alf:34976
QUERY = copy 4 records into t_int from stdin delimiters ',','\n' NULL as '';
ERROR = !SQLException:sql:value 'abc' from line 4 field 1 not inserted,
expecting type int
+ !SQLException:importTable:failed to import table
# 19:40:25 >
# 19:40:25 > Done.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
