Update of /cvsroot/monetdb/sql/src/test/Via-m
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv10440
Modified Files:
Tag: Nov2009
insert_event1.sql insert_event3.sql insert_file2.sql
insert_file3.sql insert_file4.sql insert_file5.sql
insert_file6.sql insert_file8.sql insert_media1.sql
insert_media2.sql insert_media3.sql insert_media4.sql
insert_media5.sql insert_media6.sql insert_media7.sql
Log Message:
initialize variables to ensure deterministic behavior
cf.,
ID: 2893859 "SQL: various VIA-M tests fail"
https://sourceforge.net/tracker/?func=detail&aid=2893859&group_id=56967&atid=482468
Index: insert_media1.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media1.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media1.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media1.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,8 +1,11 @@
declare id_event1 integer;
+set id_event1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select max(event_id) from event);
Index: insert_media7.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media7.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media7.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media7.sql 16 Nov 2009 20:41:33 -0000 1.2.2.1
@@ -1,8 +1,11 @@
declare id_event1 integer;
+set id_event1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select event_id from event where event_name = 'event 1');
Index: insert_media3.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media3.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media3.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media3.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,4 +1,5 @@
declare id_media_description integer;
+set id_media_description = -1234567890;
set id_media_description = add_media_description('description 1');
Index: insert_file5.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file5.sql,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- insert_file5.sql 22 Sep 2009 09:12:32 -0000 1.1
+++ insert_file5.sql 16 Nov 2009 20:41:32 -0000 1.1.2.1
@@ -1,5 +1,7 @@
declare id_file1 integer;
+set id_file1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
set id_media1 = (select media_id
from media
Index: insert_event1.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_event1.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_event1.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_event1.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,4 +1,5 @@
declare id_event integer;
+set id_event = -1234567890;
set id_event = add_event('event 1', '2009-06-23', 'artist1', 'location1',
'description1');
Index: insert_event3.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_event3.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_event3.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_event3.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,4 +1,5 @@
declare id_event integer;
+set id_event = -1234567890;
set id_event = add_event('event 3', '2009-06-23', 'artist2', 'location3',
'description3');
Index: insert_file8.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file8.sql,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- insert_file8.sql 22 Sep 2009 09:12:32 -0000 1.1
+++ insert_file8.sql 16 Nov 2009 20:41:32 -0000 1.1.2.1
@@ -1,4 +1,5 @@
declare return_id integer;
+set return_id = -1234567890;
set return_id = i_add_video_file_event('fabchannel2007',
'event 4',
Index: insert_file2.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file2.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_file2.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_file2.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,4 +1,5 @@
declare next_file_quid integer;
+set next_file_quid = -1234567890;
set next_file_quid = get_next_file_quid('fabchannel2007');
Index: insert_media4.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media4.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media4.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media4.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,8 +1,11 @@
declare id_event1 integer;
+set id_event1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select event_id from event where event_name = 'event 1');
Index: insert_file6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file6.sql,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- insert_file6.sql 22 Sep 2009 09:12:32 -0000 1.1
+++ insert_file6.sql 16 Nov 2009 20:41:32 -0000 1.1.2.1
@@ -1,5 +1,7 @@
declare id_file1 integer;
+set id_file1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
set id_media1 = (select media_id
from media
Index: insert_media6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media6.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media6.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media6.sql 16 Nov 2009 20:41:33 -0000 1.2.2.1
@@ -1,8 +1,11 @@
declare id_event1 integer;
+set id_event1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select max(event_id) + 1 from event);
Index: insert_media5.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media5.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media5.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media5.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -5,6 +5,7 @@
set id_media1 = -1;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select event_id from event where event_name = 'event 1');
Index: insert_file3.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file3.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_file3.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_file3.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,4 +1,5 @@
declare video_sets_id1 integer;
+set video_sets_id1 = -1234567890;
set video_sets_id1 = get_video_sets_id('fabchannel2007');
Index: insert_file4.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_file4.sql,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- insert_file4.sql 22 Sep 2009 09:12:32 -0000 1.1
+++ insert_file4.sql 16 Nov 2009 20:41:32 -0000 1.1.2.1
@@ -1,5 +1,7 @@
declare id_file1 integer;
+set id_file1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
set id_media1 = (select media_id
from media
Index: insert_media2.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/insert_media2.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- insert_media2.sql 22 Sep 2009 13:06:42 -0000 1.2
+++ insert_media2.sql 16 Nov 2009 20:41:32 -0000 1.2.2.1
@@ -1,8 +1,11 @@
declare id_event1 integer;
+set id_event1 = -1234567890;
declare id_media1 integer;
+set id_media1 = -1234567890;
declare id_media_description1 integer;
+set id_media_description1 = -1234567890;
set id_event1 = (select event_id from event where event_name = 'event 2');
------------------------------------------------------------------------------
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
