Update of /cvsroot/monetdb/sql/src/test/Via-m/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/Via-m/Tests
Modified Files:
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:
A sequence of group new and derives is now closed with a group.done (does
the last step ie a group.new or derive).
This makes the code in merge table a bit cleaner (more could be done later)
sql.bind and append/update/delete now have an extra (first) argument,
making them safe to use in the dataflow (ie solved using variable dependencies)
(BREAKS octopus !)
Implemented read only tables. Use
ALTER TABLE x SET READ ONLY;
(cannot be reverted currently)
fixed bug in limit/offset handling, now we have 64 bit wrd instead of int.
The new read only required schema changes, ie backup/restore your db.
We therefor claimed some more oid's for internal functions.
Index: event_s10.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s10.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s10.stable.out 12 Nov 2009 15:07:30 -0000 1.2
+++ event_s10.stable.out 27 Feb 2010 19:28:33 -0000 1.3
@@ -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
-% 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" ]
+% 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" ]
-# 10:47:12 >
-# 10:47:12 > Done.
-# 10:47:12 >
+# 21:50:39 >
+# 21:50:39 > Done.
+# 21:50:39 >
Index: event_s08.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s08.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s08.stable.out 12 Nov 2009 15:07:26 -0000 1.2
+++ event_s08.stable.out 27 Feb 2010 19:28:33 -0000 1.3
@@ -35,12 +35,12 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 2, 1, "artist", "artist1" ]
-[ 3, 1, "location", "location1" ]
-[ 5, 2, "artist", "artist2" ]
-[ 6, 2, "location", "location2" ]
+[ 1, 1, "artist", "artist1" ]
+[ 2, 1, "location", "location1" ]
+[ 3, 2, "artist", "artist2" ]
+[ 4, 2, "location", "location2" ]
-# 10:47:12 >
-# 10:47:12 > Done.
-# 10:47:12 >
+# 21:50:38 >
+# 21:50:38 > Done.
+# 21:50:38 >
Index: event_s11.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s11.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s11.stable.err 12 Nov 2009 15:07:34 -0000 1.2
+++ event_s11.stable.err 27 Feb 2010 19:28:33 -0000 1.3
@@ -67,16 +67,16 @@
# 15:59:49 > mclient -lsql -umonetdb -Pmonetdb --host=yngling --port=32412
# 15:59:49 >
-MAPI = mone...@yngling:31032
+MAPI = mone...@alf:37695
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:31032
+MAPI = mone...@alf:37695
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:31032
+MAPI = mone...@alf:37695
QUERY = insert into event_metadata (
ERROR = !SQLException:assert:INSERT INTO: UNIQUE constraint
'event_metadata.unq_metadata' violated
-MAPI = mone...@yngling:31032
+MAPI = mone...@alf:37695
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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- file_s16.stable.out 12 Nov 2009 15:07:47 -0000 1.2
+++ file_s16.stable.out 27 Feb 2010 19:28:34 -0000 1.3
@@ -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
-% 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" ]
+% 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" ]
-# 10:47:21 >
-# 10:47:21 > Done.
-# 10:47:21 >
+# 21:51:28 >
+# 21:51:28 > Done.
+# 21:51:28 >
Index: event_s07.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s07.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s07.stable.out 12 Nov 2009 15:07:22 -0000 1.2
+++ event_s07.stable.out 27 Feb 2010 19:28:33 -0000 1.3
@@ -28,8 +28,8 @@
% . # table_name
% single_value # name
% int # type
-% 1 # length
-[ 0 ]
+% 2 # length
+[ -1 ]
# 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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s11.stable.out 12 Nov 2009 15:07:38 -0000 1.2
+++ event_s11.stable.out 27 Feb 2010 19:28:34 -0000 1.3
@@ -40,7 +40,7 @@
% single_value # name
% int # type
% 1 # length
-[ 0 ]
+[ 5 ]
# 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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s04.stable.out 12 Nov 2009 15:07:06 -0000 1.2
+++ event_s04.stable.out 27 Feb 2010 19:28:29 -0000 1.3
@@ -34,8 +34,8 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 2, 1, "artist", "artist1" ]
-[ 3, 1, "location", "location1" ]
+[ 1, 1, "artist", "artist1" ]
+[ 2, 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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s06.stable.out 12 Nov 2009 15:07:14 -0000 1.2
+++ event_s06.stable.out 27 Feb 2010 19:28:33 -0000 1.3
@@ -35,12 +35,12 @@
% event_metadata_id, event_id, metadata_name, metadata_value # name
% int, int, varchar, varchar # type
% 1, 1, 8, 9 # length
-[ 2, 1, "artist", "artist1" ]
-[ 3, 1, "location", "location1" ]
-[ 5, 2, "artist", "artist2" ]
-[ 6, 2, "location", "location2" ]
+[ 1, 1, "artist", "artist1" ]
+[ 2, 1, "location", "location1" ]
+[ 3, 2, "artist", "artist2" ]
+[ 4, 2, "location", "location2" ]
-# 10:41:24 >
-# 10:41:24 > Done.
-# 10:41:24 >
+# 21:49:43 >
+# 21:49:43 > Done.
+# 21:49:43 >
Index: event_s12.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s12.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s12.stable.out 12 Nov 2009 15:07:43 -0000 1.2
+++ event_s12.stable.out 27 Feb 2010 19:28:34 -0000 1.3
@@ -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
-% 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" ]
+% 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" ]
-# 10:47:13 >
-# 10:47:13 > Done.
-# 10:47:13 >
+# 21:50:39 >
+# 21:50:39 > Done.
+# 21:50:39 >
Index: event_s07.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/Tests/event_s07.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- event_s07.stable.err 12 Nov 2009 15:07:18 -0000 1.2
+++ event_s07.stable.err 27 Feb 2010 19:28:33 -0000 1.3
@@ -70,7 +70,7 @@
# 14:41:43 > mclient -lsql -umonetdb -Pmonetdb --host=yngling --port=30006
# 14:41:43 >
-MAPI = mone...@yngling:31032
+MAPI = mone...@alf:37695
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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
