Update of /cvsroot/monetdb/sql/src/test/copy/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16696
Modified Files:
int_parse.stable.err int_parse.stable.out
load_incorrect_line_nr.stable.err
load_incorrect_line_nr.stable.out
Log Message:
Acceptable test output
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.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- load_incorrect_line_nr.stable.out 7 Aug 2009 15:49:31 -0000 1.1
+++ load_incorrect_line_nr.stable.out 9 Aug 2009 12:13:10 -0000 1.2
@@ -21,21 +21,17 @@
Over..
-# 16:52:10 >
-# 16:52:10 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=32084
-# 16:52:10 >
+# 13:54:35 >
+# 13:54:35 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34075
+# 13:54:35 >
-# COPY reader time 24
-# COPY thread time 40
-# COPY thread time 0
-# COPY thread time 0
-# COPY thread time 0
-[ 1 ]
+[ 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.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- load_incorrect_line_nr.stable.err 7 Aug 2009 15:49:31 -0000 1.1
+++ load_incorrect_line_nr.stable.err 9 Aug 2009 12:13:10 -0000 1.2
@@ -69,9 +69,9 @@
# 16:52:10 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=32084
# 16:52:10 >
-MAPI = mone...@alf:32084
-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' while parsing 'bla' from line 2 field 1
not inserted, expecting type int
+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';
+
# 16:52:10 >
# 16:52:10 > Done.
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.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- int_parse.stable.out 28 Dec 2008 19:05:12 -0000 1.1
+++ int_parse.stable.out 9 Aug 2009 12:13:10 -0000 1.2
@@ -21,12 +21,21 @@
Over..
-# 19:40:24 >
-# 19:40:24 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=37659
-# 19:40:24 >
+# 13:54:35 >
+# 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 ]
-# 19:40:25 >
-# 19:40:25 > Done.
-# 19:40:25 >
+# 13:54:35 >
+# 13:54:35 > Done.
+# 13:54:35 >
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.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- int_parse.stable.err 28 Dec 2008 19:05:12 -0000 1.1
+++ int_parse.stable.err 9 Aug 2009 12:13:10 -0000 1.2
@@ -79,13 +79,9 @@
# 19:40:24 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=37659
# 19:40:24 >
-MAPI = mone...@eir:37659
+MAPI = mone...@eir:34075
QUERY = copy 4 records into t_int from stdin delimiters ',','\n' NULL as '';
-ERROR = !SQLException:sql:value 'null' while parsing 'null' from line 2 field
0 not inserted, expecting type int
- !SQLException:importTable:failed to import table
-MAPI = mone...@eir:37659
-QUERY = abc
-ERROR = !syntax error, unexpected IDENT in: "abc"
+ERROR = !SQLException:sql:value 'abc' from line 4 field 1 not inserted,
expecting type int
# 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
