Changeset: f00e367ce2e9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f00e367ce2e9
Modified Files:
sql/backends/monet5/Tests/cquery06.stable.err
sql/backends/monet5/Tests/cquery07.stable.err
sql/backends/monet5/Tests/cquery20.sql
sql/backends/monet5/Tests/cquery20.stable.out
Branch: trails
Log Message:
Test approvals.
diffs (77 lines):
diff --git a/sql/backends/monet5/Tests/cquery06.stable.err
b/sql/backends/monet5/Tests/cquery06.stable.err
--- a/sql/backends/monet5/Tests/cquery06.stable.err
+++ b/sql/backends/monet5/Tests/cquery06.stable.err
@@ -32,6 +32,7 @@ QUERY = pause continuous cq_basic06(); -
+
# 10:26:39 >
# 10:26:39 > "Done."
# 10:26:39 >
diff --git a/sql/backends/monet5/Tests/cquery07.stable.err
b/sql/backends/monet5/Tests/cquery07.stable.err
--- a/sql/backends/monet5/Tests/cquery07.stable.err
+++ b/sql/backends/monet5/Tests/cquery07.stable.err
@@ -29,21 +29,23 @@ stderr of test 'cquery07` in directory '
MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
QUERY = stop continuous cq_basic07(); --error
-
-MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
+ERROR = !The continuous procedure user.cq_basic07(); has not yet started
+MAPI = (monetdb) /var/tmp/mtest-32593/.s.monetdb.32766
QUERY = pause continuous cq_basic07(); --error
-
-MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
+ERROR = !The continuous procedure user.cq_basic07(); is already paused
+MAPI = (monetdb) /var/tmp/mtest-32593/.s.monetdb.32766
QUERY = resume continuous cq_basic07() WITH HEARTBEAT 2000 CYCLES 300; --error
+ERROR = !The continuous procedure user.cq_basic07(); is already running
+MAPI = (monetdb) /var/tmp/mtest-32593/.s.monetdb.32766
+QUERY = stop continuous cq_basic07(); --error
+ERROR = !The continuous procedure user.cq_basic07(); has not yet started
+MAPI = (monetdb) /var/tmp/mtest-32593/.s.monetdb.32766
+QUERY = pause continuous cq_basic07(); --error
+ERROR = !The continuous procedure user.cq_basic07(); has not yet started
+MAPI = (monetdb) /var/tmp/mtest-32593/.s.monetdb.32766
+QUERY = resume continuous cq_basic07() WITH HEARTBEAT 2000 CYCLES 300; --error
+ERROR = !The continuous procedure user.cq_basic07(); has not yet started
-MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
-QUERY = stop continuous cq_basic07(); --error
-
-MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
-QUERY = pause continuous cq_basic07(); --error
-
-MAPI = (monetdb) /var/tmp/mtest-24395/.s.monetdb.39287
-QUERY = resume continuous cq_basic07() WITH HEARTBEAT 2000 CYCLES 300; --error
# 10:26:41 >
diff --git a/sql/backends/monet5/Tests/cquery20.sql
b/sql/backends/monet5/Tests/cquery20.sql
--- a/sql/backends/monet5/Tests/cquery20.sql
+++ b/sql/backends/monet5/Tests/cquery20.sql
@@ -7,7 +7,6 @@ create procedure cqfoo(v integer)
begin
insert into cqtbl values(v);
end;
-select * from functions where name = 'cqfoo';
-- continuous procedures can always be called directly
-- this simplifies debugging as well
diff --git a/sql/backends/monet5/Tests/cquery20.stable.out
b/sql/backends/monet5/Tests/cquery20.stable.out
--- a/sql/backends/monet5/Tests/cquery20.stable.out
+++ b/sql/backends/monet5/Tests/cquery20.stable.out
@@ -30,12 +30,6 @@ Ready.
#begin
# insert into cqtbl values(v);
#end;
-#select * from functions where name = 'cqfoo';
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions # table_name
-% id, name, func, mod, language, type, side_effect, varres,
vararg, schema_id # name
-% int, varchar, varchar, varchar, int, int,
boolean, boolean, boolean, int # type
-% 4, 5, 74, 4, 1, 1, 5, 5, 5, 4 #
length
-[ 8334, "cqfoo", "create procedure cqfoo(v integer)\nbegin\n
insert into cqtbl values(v);\nend;", "user", 2, 2, true,
false, false, 2000 ]
#select * from cqtbl;
% sys.cqtbl # table_name
% i # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
