Update of /cvsroot/monetdb/sql/src/test/Via-m/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1105/Tests
Modified Files:
Tag: Nov2009
event_s04.stable.out event_s06.stable.out event_s07.stable.err
event_s07.stable.out event_s08.stable.out event_s10.stable.out
event_s11.stable.err event_s11.stable.out event_s12.stable.out
file_s16.stable.out
Log Message:
approve stable output
Index: event_s10.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s10.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s10.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s10.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -35,15 +35,15 @@
% sys.event_metadata, sys.event_metadata, sys.event_metadata,
sys.event_metadata # table_name
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
-% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
-[ 3, 2, "artist", "artist2" ]
-[ 4, 2, "location", "location2" ]
-[ 5, 4, "artist", "artist2" ]
-[ 6, 4, "location", "location3" ]
+% 2, 1, 8, 9 # length
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
+[ 5, 2, "artist", "artist2" ]
+[ 6, 2, "location", "location2" ]
+[ 9, 4, "artist", "artist2" ]
+[ 10, 4, "location", "location3" ]
-# 15:24:40 >
-# 15:24:40 > Done.
-# 15:24:40 >
+# 10:47:12 >
+# 10:47:12 > Done.
+# 10:47:12 >
Index: event_s08.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s08.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s08.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s08.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -35,12 +35,12 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
-[ 3, 2, "artist", "artist2" ]
-[ 4, 2, "location", "location2" ]
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
+[ 5, 2, "artist", "artist2" ]
+[ 6, 2, "location", "location2" ]
-# 15:24:08 >
-# 15:24:08 > Done.
-# 15:24:08 >
+# 10:47:12 >
+# 10:47:12 > Done.
+# 10:47:12 >
Index: event_s11.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s11.stable.err,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s11.stable.err 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s11.stable.err 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -67,16 +67,16 @@
# 15:59:49 > mclient -lsql -umonetdb -Pmonetdb --host=yngling --port=32412
# 15:59:49 >
-MAPI = mone...@yngling:35923
+MAPI = mone...@yngling:31032
QUERY = set id_event = add_event('event 4', 123456, 'artist2', 'location3',
'description3');
ERROR = !types int(32,0) (int) and date(0,0) (date) are not equal
-MAPI = mone...@yngling:35923
+MAPI = mone...@yngling:31032
QUERY = delete from event where event_name = 'event 2';
ERROR = !SQLException:assert:DELETE: FOREIGN KEY constraint
'event.event_event_id_pkey' violated
-MAPI = mone...@yngling:35923
+MAPI = mone...@yngling:31032
QUERY = insert into event_metadata (
ERROR = !SQLException:assert:INSERT INTO: UNIQUE constraint
'event_metadata.unq_metadata' violated
-MAPI = mone...@yngling:35923
+MAPI = mone...@yngling:31032
QUERY = set id_event = add_event('event 4', '2009-06-24', 'artist4',
'location4', 'description4');
ERROR = !SQLException:assert:INSERT INTO: UNIQUE constraint
'event.unq_event_name' violated
Index: file_s16.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/file_s16.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- file_s16.stable.out 22 Sep 2009 09:12:32 -0000 1.1
+++ file_s16.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -37,15 +37,15 @@
% sys.event_metadata, sys.event_metadata, sys.event_metadata,
sys.event_metadata # table_name
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
-% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
-[ 3, 2, "artist", "artist2" ]
-[ 4, 2, "location", "location2" ]
-[ 5, 4, "artist", "artist2" ]
-[ 6, 4, "location", "location3" ]
+% 2, 1, 8, 9 # length
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
+[ 5, 2, "artist", "artist2" ]
+[ 6, 2, "location", "location2" ]
+[ 9, 4, "artist", "artist2" ]
+[ 10, 4, "location", "location3" ]
-# 10:57:46 >
-# 10:57:46 > Done.
-# 10:57:46 >
+# 10:47:21 >
+# 10:47:21 > Done.
+# 10:47:21 >
Index: event_s07.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s07.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s07.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s07.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -28,8 +28,8 @@
% . # table_name
% single_value # name
% int # type
-% 2 # length
-[ -1 ]
+% 1 # length
+[ 0 ]
# 14:41:43 >
# 14:41:43 > Done.
Index: event_s11.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s11.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s11.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s11.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -40,7 +40,7 @@
% single_value # name
% int # type
% 1 # length
-[ 5 ]
+[ 0 ]
# 15:59:49 >
# 15:59:49 > Done.
Index: event_s04.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s04.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s04.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s04.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -34,8 +34,8 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
# 14:11:47 >
# 14:11:47 > Done.
Index: event_s06.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s06.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s06.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s06.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -35,12 +35,12 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
-[ 3, 2, "artist", "artist2" ]
-[ 4, 2, "location", "location2" ]
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
+[ 5, 2, "artist", "artist2" ]
+[ 6, 2, "location", "location2" ]
-# 15:14:30 >
-# 15:14:30 > Done.
-# 15:14:30 >
+# 10:41:24 >
+# 10:41:24 > Done.
+# 10:41:24 >
Index: event_s12.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s12.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s12.stable.out 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s12.stable.out 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -36,15 +36,15 @@
% sys.event_metadata, sys.event_metadata, sys.event_metadata,
sys.event_metadata # table_name
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
-% 1, 1, 8, 9 # length
-[ 1, 1, "artist", "artist1" ]
-[ 2, 1, "location", "location1" ]
-[ 3, 2, "artist", "artist2" ]
-[ 4, 2, "location", "location2" ]
-[ 5, 4, "artist", "artist2" ]
-[ 6, 4, "location", "location3" ]
+% 2, 1, 8, 9 # length
+[ 2, 1, "artist", "artist1" ]
+[ 3, 1, "location", "location1" ]
+[ 5, 2, "artist", "artist2" ]
+[ 6, 2, "location", "location2" ]
+[ 9, 4, "artist", "artist2" ]
+[ 10, 4, "location", "location3" ]
-# 15:51:41 >
-# 15:51:41 > Done.
-# 15:51:41 >
+# 10:47:13 >
+# 10:47:13 > Done.
+# 10:47:13 >
Index: event_s07.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s07.stable.err,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- event_s07.stable.err 22 Sep 2009 07:47:37 -0000 1.1
+++ event_s07.stable.err 12 Nov 2009 10:08:40 -0000 1.1.2.1
@@ -70,7 +70,7 @@
# 14:41:43 > mclient -lsql -umonetdb -Pmonetdb --host=yngling --port=30006
# 14:41:43 >
-MAPI = mone...@yngling:35667
+MAPI = mone...@yngling:31032
QUERY = set id_event = add_event('event 2', '2009-06-23', 'artist2',
'location2', 'description2');
ERROR = !SQLException:assert:INSERT INTO: UNIQUE constraint
'event.unq_event_name' violated
------------------------------------------------------------------------------
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
