Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29913/src/test/BugTracker-2008/Tests
Modified Files:
copy-format.SF-2468513.stable.err
copy-format.SF-2468513.stable.out
varchar.SF-2471371.stable.err
Log Message:
approved tests for stricter copy into
removed no longer skipped whitespace
on error always report that
U copy-format.SF-2468513.stable.out
Index: copy-format.SF-2468513.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/copy-format.SF-2468513.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- copy-format.SF-2468513.stable.out 28 Dec 2008 09:58:47 -0000 1.1
+++ copy-format.SF-2468513.stable.out 9 Aug 2009 20:43:31 -0000 1.2
@@ -21,12 +21,16 @@
Over..
-# 09:34:56 >
-# 09:34:56 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34345
-# 09:34:56 >
+# 21:14:18 >
+# 21:14:18 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31439
+# 21:14:18 >
+% sys.my_copytest, sys.my_copytest, sys.my_copytest,
sys.my_copytest, sys.my_copytest # table_name
+% col1, col2, col3, col4, col5 # name
+% int, int, int, varchar, varchar # type
+% 1, 1, 1, 0, 0 # length
-# 09:34:56 >
-# 09:34:56 > Done.
-# 09:34:56 >
+# 21:14:18 >
+# 21:14:18 > Done.
+# 21:14:18 >
U copy-format.SF-2468513.stable.err
Index: copy-format.SF-2468513.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/copy-format.SF-2468513.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- copy-format.SF-2468513.stable.err 8 Aug 2009 20:46:08 -0000 1.3
+++ copy-format.SF-2468513.stable.err 9 Aug 2009 20:43:31 -0000 1.4
@@ -79,16 +79,26 @@
# 09:34:56 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34345
# 09:34:56 >
-MAPI = mone...@eir:38924
-QUERY = COPY 3 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
-ERROR = !SQLException:sql:value '1.01' while parsing '1.01' from line 1 field
2 not inserted, expecting type int
+MAPI = mone...@alf:31439
+QUERY = COPY 1 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
+ERROR = !SQLException:sql:value '1.01' from line 1 field 2 not inserted,
expecting type int
+ !SQLException:importTable:failed to import table
+MAPI = mone...@alf:31439
+QUERY = COPY 1 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
+ERROR = !SQLException:sql:value '.02' from line 1 field 2 not inserted,
expecting type int
+ !SQLException:importTable:failed to import table
+MAPI = mone...@alf:31439
+QUERY = COPY 1 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
+ERROR = !SQLException:sql:value '2.03' from line 1 field 2 not inserted,
expecting type int
+ !SQLException:importTable:failed to import table
+MAPI = mone...@alf:31439
+QUERY = COPY 1 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
+ERROR = !SQLException:sql:value 'aaa' from line 1 field 4 not inserted,
expecting type str
+ !SQLException:importTable:failed to import table
+MAPI = mone...@alf:31439
+QUERY = COPY 1 RECORDS INTO my_copytest FROM stdin USING DELIMITERS '|','\n'
+ERROR = !SQLException:sql:value 'bbb' from line 1 field 5 not inserted,
expecting type str
!SQLException:importTable:failed to import table
-MAPI = mone...@eir:38924
-QUERY = select * from my_copytest;
-ERROR = !current transaction is aborted (please ROLLBACK)
-MAPI = mone...@eir:38924
-QUERY = abort;
-ERROR = !current transaction is aborted (please ROLLBACK)
# 09:34:56 >
# 09:34:56 > Done.
U varchar.SF-2471371.stable.err
Index: varchar.SF-2471371.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/varchar.SF-2471371.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- varchar.SF-2471371.stable.err 28 Dec 2008 21:29:51 -0000 1.3
+++ varchar.SF-2471371.stable.err 9 Aug 2009 20:43:31 -0000 1.4
@@ -79,13 +79,13 @@
# 14:48:55 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=33632
# 14:48:55 >
-MAPI = mone...@eir:35434
+MAPI = mone...@alf:31439
QUERY = COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n'
NULL as '';
-ERROR = !SQLException:sql:value 'b2b' while parsing 'b2b' from line 0 field 1
not inserted, expecting type str
+ERROR = !SQLException:sql:value 'b2b' from line 1 field 2 not inserted,
expecting type str
!SQLException:importTable:failed to import table
-MAPI = mone...@eir:35434
+MAPI = mone...@alf:31439
QUERY = COPY 1 RECORDS INTO myvar_test FROM stdin USING DELIMITERS '|','\n'
NULL as '';
-ERROR = !SQLException:sql:value 'aa' while parsing 'aa|bb' from line 0 field 0
not inserted, expecting type str
+ERROR = !SQLException:sql:value 'aa' from line 1 field 1 not inserted,
expecting type str
!SQLException:importTable:failed to import table
# 14:48:55 >
------------------------------------------------------------------------------
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
