Changeset: b6aabde5d6fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b6aabde5d6fd Added Files: sql/test/sysmon/Tests/drop_sleep.reqtests sql/test/sysmon/Tests/sys_queue_expand.reqtests sql/test/sysmon/Tests/sys_user_statistics.reqtests Modified Files: sql/test/sysmon/Tests/All sql/test/sysmon/Tests/sys_queue_rotate.test sql/test/sysmon/Tests/sysqueue.test Branch: mtest Log Message:
fixed test output moved all test requiring the 'procedure sleep' to the end, so a test without reqtests doesn't remove it before we use it. diffs (115 lines): diff --git a/sql/test/sysmon/Tests/All b/sql/test/sysmon/Tests/All --- a/sql/test/sysmon/Tests/All +++ b/sql/test/sysmon/Tests/All @@ -1,6 +1,6 @@ -create_sleep sysqueue sys_queue_rotate +create_sleep HAVE_PYMONETDB?sys_queue_expand HAVE_PYMONETDB?sys_user_statistics drop_sleep diff --git a/sql/test/sysmon/Tests/drop_sleep.reqtests b/sql/test/sysmon/Tests/drop_sleep.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/sysmon/Tests/drop_sleep.reqtests @@ -0,0 +1,1 @@ +create_sleep diff --git a/sql/test/sysmon/Tests/sys_queue_expand.reqtests b/sql/test/sysmon/Tests/sys_queue_expand.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/sysmon/Tests/sys_queue_expand.reqtests @@ -0,0 +1,1 @@ +create_sleep diff --git a/sql/test/sysmon/Tests/sys_queue_rotate.test b/sql/test/sysmon/Tests/sys_queue_rotate.test --- a/sql/test/sysmon/Tests/sys_queue_rotate.test +++ b/sql/test/sysmon/Tests/sys_queue_rotate.test @@ -3,9 +3,18 @@ select 1, username, status, case when qu ---- 1 monetdb +finished +select name from sys.schemas where not system@; +1 +monetdb +finished +select name from sys.users where name not in (\'monetdb\', \'.snapshot\')@; +1 +monetdb running select 1, username, status, case when query ilike \'set time%\' then \'set time...\' else query end from sys.queue()@; + query ITTT rowsort select 2, username, status, case when query ilike 'set time%' then 'set time...' else query end from sys.queue() ---- @@ -15,9 +24,14 @@ finished select 1, username, status, case when query ilike \'set time%\' then \'set time...\' else query end from sys.queue()@; 2 monetdb +finished +select name from sys.users where name not in (\'monetdb\', \'.snapshot\')@; +2 +monetdb running select 2, username, status, case when query ilike \'set time%\' then \'set time...\' else query end from sys.queue()@; + query ITTT rowsort select 3, username, status, case when query ilike 'set time%' then 'set time...' else query end from sys.queue() ---- diff --git a/sql/test/sysmon/Tests/sys_user_statistics.reqtests b/sql/test/sysmon/Tests/sys_user_statistics.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/sysmon/Tests/sys_user_statistics.reqtests @@ -0,0 +1,1 @@ +create_sleep diff --git a/sql/test/sysmon/Tests/sysqueue.test b/sql/test/sysmon/Tests/sysqueue.test --- a/sql/test/sysmon/Tests/sysqueue.test +++ b/sql/test/sysmon/Tests/sysqueue.test @@ -2,32 +2,37 @@ query TTT rowsort select username, status, case when query ilike 'set time%' then 'set time...' else query end from sys.queue() ---- monetdb +finished +select name from sys.schemas where not system@; +monetdb +finished +select name from sys.users where name not in (\'monetdb\', \'.snapshot\')@; +monetdb running select username, status, case when query ilike \'set time%\' then \'set time...\' else query end from sys.queue()@; query I rowsort -select count(*) from sys.queue() +select count(*) from sys.queue(); ---- -2 +3 query I rowsort -select count(*) from sys.queue() +select count(*) from sys.queue(); ---- 3 query I rowsort -select count(*) from sys.queue() +select count(*) from sys.queue(); ---- 3 query I rowsort -select count(*) from sys.queue() +select count(*) from sys.queue(); ---- 3 query I rowsort -select count(*) from sys.queue() where query = 'select count(*) from sys.queue();' +select count(*) from sys.queue() where query = 'select count(*) from sys.queue();'; ---- -0 +2 - _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
