Changeset: 4a7ccf3a6006 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4a7ccf3a6006
Modified Files:
sql/test/Via-m/insert_event1.sql
sql/test/Via-m/insert_event2.sql
sql/test/Via-m/insert_event3.sql
sql/test/Via-m/insert_event4.sql
sql/test/Via-m/insert_file2.sql
sql/test/Via-m/insert_file3.sql
sql/test/Via-m/insert_file4.sql
sql/test/Via-m/insert_file5.sql
sql/test/Via-m/insert_file6.sql
sql/test/Via-m/insert_file7.sql
sql/test/Via-m/insert_file8.sql
sql/test/Via-m/insert_media1.sql
sql/test/Via-m/insert_media2.sql
sql/test/Via-m/insert_media3.sql
sql/test/Via-m/insert_media4.sql
sql/test/Via-m/insert_media5.sql
sql/test/Via-m/insert_media6.sql
sql/test/Via-m/insert_media7.sql
Branch: gdk_tracer
Log Message:
add missing fixes on the via-m sql scripts
diffs (177 lines):
diff --git a/sql/test/Via-m/insert_event1.sql b/sql/test/Via-m/insert_event1.sql
--- a/sql/test/Via-m/insert_event1.sql
+++ b/sql/test/Via-m/insert_event1.sql
@@ -2,5 +2,3 @@ declare id_event integer;
set id_event = -1234567890;
set id_event = add_event('event 1', '2009-06-23', 'artist1', 'location1',
'description1');
-
-select id_event;
diff --git a/sql/test/Via-m/insert_event2.sql b/sql/test/Via-m/insert_event2.sql
--- a/sql/test/Via-m/insert_event2.sql
+++ b/sql/test/Via-m/insert_event2.sql
@@ -2,5 +2,3 @@ declare id_event integer;
set id_event = -1;
set id_event = add_event('event 2', '2009-06-23', 'artist2', 'location2',
'description2');
-
-select id_event;
diff --git a/sql/test/Via-m/insert_event3.sql b/sql/test/Via-m/insert_event3.sql
--- a/sql/test/Via-m/insert_event3.sql
+++ b/sql/test/Via-m/insert_event3.sql
@@ -2,5 +2,3 @@ declare id_event integer;
set id_event = -1234567890;
set id_event = add_event('event 3', '2009-06-23', 'artist2', 'location3',
'description3');
-
-select id_event;
diff --git a/sql/test/Via-m/insert_event4.sql b/sql/test/Via-m/insert_event4.sql
--- a/sql/test/Via-m/insert_event4.sql
+++ b/sql/test/Via-m/insert_event4.sql
@@ -3,9 +3,8 @@ set id_event = -1;
set id_event = add_event('event 4', 123456, 'artist2', 'location3',
'description3');
-select id_event;
-set id_event = add_event('event 4', '2009-06-23', NULL, NULL, 'description3');
-select id_event;
+declare id_event2 integer;
+set id_event2 = add_event('event 4', '2009-06-23', NULL, NULL, 'description3');
delete from event where event_name = 'event 2';
@@ -17,6 +16,5 @@ values ( 1,
'artist',
'artist1' );
-set id_event = add_event('event 4', '2009-06-24', 'artist4', 'location4',
'description4');
-
-select id_event;
+declare id_event3 integer;
+set id_event3 = add_event('event 4', '2009-06-24', 'artist4', 'location4',
'description4');
diff --git a/sql/test/Via-m/insert_file2.sql b/sql/test/Via-m/insert_file2.sql
--- a/sql/test/Via-m/insert_file2.sql
+++ b/sql/test/Via-m/insert_file2.sql
@@ -2,5 +2,3 @@ declare next_file_quid integer;
set next_file_quid = -1234567890;
set next_file_quid = get_next_file_quid('fabchannel2007');
-
-select next_file_quid;
diff --git a/sql/test/Via-m/insert_file3.sql b/sql/test/Via-m/insert_file3.sql
--- a/sql/test/Via-m/insert_file3.sql
+++ b/sql/test/Via-m/insert_file3.sql
@@ -2,5 +2,3 @@ declare video_sets_id1 integer;
set video_sets_id1 = -1234567890;
set video_sets_id1 = get_video_sets_id('fabchannel2007');
-
-select video_sets_id1;
diff --git a/sql/test/Via-m/insert_file4.sql b/sql/test/Via-m/insert_file4.sql
--- a/sql/test/Via-m/insert_file4.sql
+++ b/sql/test/Via-m/insert_file4.sql
@@ -17,5 +17,3 @@ set id_file1 = add_file(id_media1,
'empty',
250,
250);
-
-select id_file1;
diff --git a/sql/test/Via-m/insert_file5.sql b/sql/test/Via-m/insert_file5.sql
--- a/sql/test/Via-m/insert_file5.sql
+++ b/sql/test/Via-m/insert_file5.sql
@@ -17,5 +17,3 @@ set id_file1 = add_file(id_media1,
'empty',
250,
250);
-
-select id_file1;
diff --git a/sql/test/Via-m/insert_file6.sql b/sql/test/Via-m/insert_file6.sql
--- a/sql/test/Via-m/insert_file6.sql
+++ b/sql/test/Via-m/insert_file6.sql
@@ -17,5 +17,3 @@ set id_file1 = add_file(id_media1,
'empty',
250,
250);
-
-select id_file1;
diff --git a/sql/test/Via-m/insert_file7.sql b/sql/test/Via-m/insert_file7.sql
--- a/sql/test/Via-m/insert_file7.sql
+++ b/sql/test/Via-m/insert_file7.sql
@@ -11,5 +11,3 @@ set return_id = i_add_video_file('dummy
125,
'codec 1',
2000);
-
-select return_id;
diff --git a/sql/test/Via-m/insert_file8.sql b/sql/test/Via-m/insert_file8.sql
--- a/sql/test/Via-m/insert_file8.sql
+++ b/sql/test/Via-m/insert_file8.sql
@@ -12,5 +12,3 @@ set return_id = i_add_video_file_event('
125,
'codec 1',
2000);
-
-select return_id;
diff --git a/sql/test/Via-m/insert_media1.sql b/sql/test/Via-m/insert_media1.sql
--- a/sql/test/Via-m/insert_media1.sql
+++ b/sql/test/Via-m/insert_media1.sql
@@ -12,5 +12,3 @@ set id_event1 = (select max(event_id) fr
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier1', 1,
25, 125);
-
-select id_media1;
diff --git a/sql/test/Via-m/insert_media2.sql b/sql/test/Via-m/insert_media2.sql
--- a/sql/test/Via-m/insert_media2.sql
+++ b/sql/test/Via-m/insert_media2.sql
@@ -12,5 +12,3 @@ set id_event1 = (select event_id from ev
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier2', 1,
25, 125);
-
-select id_media1;
diff --git a/sql/test/Via-m/insert_media3.sql b/sql/test/Via-m/insert_media3.sql
--- a/sql/test/Via-m/insert_media3.sql
+++ b/sql/test/Via-m/insert_media3.sql
@@ -2,5 +2,3 @@ declare id_media_description integer;
set id_media_description = -1234567890;
set id_media_description = add_media_description('description 1');
-
-select id_media_description;
diff --git a/sql/test/Via-m/insert_media4.sql b/sql/test/Via-m/insert_media4.sql
--- a/sql/test/Via-m/insert_media4.sql
+++ b/sql/test/Via-m/insert_media4.sql
@@ -12,5 +12,3 @@ set id_event1 = (select event_id from ev
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier3', 1,
25, 125);
-
-select id_media1;
diff --git a/sql/test/Via-m/insert_media5.sql b/sql/test/Via-m/insert_media5.sql
--- a/sql/test/Via-m/insert_media5.sql
+++ b/sql/test/Via-m/insert_media5.sql
@@ -12,5 +12,3 @@ set id_event1 = (select event_id from ev
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, NULL, 1, 25, 125);
-
-select id_media1;
diff --git a/sql/test/Via-m/insert_media6.sql b/sql/test/Via-m/insert_media6.sql
--- a/sql/test/Via-m/insert_media6.sql
+++ b/sql/test/Via-m/insert_media6.sql
@@ -12,5 +12,3 @@ set id_event1 = (select max(event_id) +
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'description 3',
1, 25, 125);
-
-select id_media1;
diff --git a/sql/test/Via-m/insert_media7.sql b/sql/test/Via-m/insert_media7.sql
--- a/sql/test/Via-m/insert_media7.sql
+++ b/sql/test/Via-m/insert_media7.sql
@@ -12,5 +12,3 @@ set id_event1 = (select event_id from ev
set id_media_description1 = (select max(media_description_id) + 1 from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'description 3',
1, 25, 125);
-
-select id_media1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
