Changeset: 4a03e45f2dfa for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4a03e45f2dfa
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures_nocfitsio.stable.out
clients/Tests/MAL-signatures_nogeom.stable.out
clients/Tests/SQL-dump.stable.out
clients/Tests/exports.stable.out
sql/scripts/22_clients.sql
Branch: default
Log Message:
Approved tests after changeset babb06e8fe55.
Also, make sure view created during database creation is marked as
system view.
diffs (truncated from 1909 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -38783,10 +38783,12 @@ command clients.sha1sum(pw:str):str
address CLTsha1sum;
comment Return hex string representation of the SHA-1 hash of the given string
-command clients.shutdown(forced:bit):void
+pattern clients.shutdown(delay:int,forced:bit):str
address CLTshutdown;
-comment Close all client connections. If forced=false theclients are moved
into finishing mode, which means thatthe process stops at the next cycle of the
scenario.If forced=true all client processes are immediately killed
-
+comment Close all other client connections. Return if it succeeds.If forced is
set then always stop the system the hard way
+
+pattern clients.shutdown(delay:int):str
+address CLTshutdown;
pattern clients.setTimeout(q:lng,s:lng):void
address CLTsetTimeout;
comment Abort a query after q seconds (q=0 means run undisturbed).The session
timeout aborts the connection after spending toomany seconds on query
processing.
@@ -42445,6 +42447,18 @@ pattern sql.setVariable(mvc:int,varname:
address setVariable;
comment Set the value of a session variable
+pattern sql.shutdown(delay:int):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:int,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte,force:bit):str
+address SQLshutdown_wrap;
pattern sql.start2():void
address SQLsession2;
comment Switch to processing precompiled sql statements
diff --git a/clients/Tests/MAL-signatures_nocfitsio.stable.out
b/clients/Tests/MAL-signatures_nocfitsio.stable.out
--- a/clients/Tests/MAL-signatures_nocfitsio.stable.out
+++ b/clients/Tests/MAL-signatures_nocfitsio.stable.out
@@ -38783,10 +38783,12 @@ command clients.sha1sum(pw:str):str
address CLTsha1sum;
comment Return hex string representation of the SHA-1 hash of the given string
-command clients.shutdown(forced:bit):void
+pattern clients.shutdown(delay:int,forced:bit):str
address CLTshutdown;
-comment Close all client connections. If forced=false theclients are moved
into finishing mode, which means thatthe process stops at the next cycle of the
scenario.If forced=true all client processes are immediately killed
-
+comment Close all other client connections. Return if it succeeds.If forced is
set then always stop the system the hard way
+
+pattern clients.shutdown(delay:int):str
+address CLTshutdown;
pattern clients.setTimeout(q:lng,s:lng):void
address CLTsetTimeout;
comment Abort a query after q seconds (q=0 means run undisturbed).The session
timeout aborts the connection after spending toomany seconds on query
processing.
@@ -42421,6 +42423,18 @@ pattern sql.setVariable(mvc:int,varname:
address setVariable;
comment Set the value of a session variable
+pattern sql.shutdown(delay:int):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:int,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte,force:bit):str
+address SQLshutdown_wrap;
pattern sql.start2():void
address SQLsession2;
comment Switch to processing precompiled sql statements
diff --git a/clients/Tests/MAL-signatures_nogeom.stable.out
b/clients/Tests/MAL-signatures_nogeom.stable.out
--- a/clients/Tests/MAL-signatures_nogeom.stable.out
+++ b/clients/Tests/MAL-signatures_nogeom.stable.out
@@ -38755,10 +38755,12 @@ command clients.sha1sum(pw:str):str
address CLTsha1sum;
comment Return hex string representation of the SHA-1 hash of the given string
-command clients.shutdown(forced:bit):void
+pattern clients.shutdown(delay:int,forced:bit):str
address CLTshutdown;
-comment Close all client connections. If forced=false theclients are moved
into finishing mode, which means thatthe process stops at the next cycle of the
scenario.If forced=true all client processes are immediately killed
-
+comment Close all other client connections. Return if it succeeds.If forced is
set then always stop the system the hard way
+
+pattern clients.shutdown(delay:int):str
+address CLTshutdown;
pattern clients.setTimeout(q:lng,s:lng):void
address CLTsetTimeout;
comment Abort a query after q seconds (q=0 means run undisturbed).The session
timeout aborts the connection after spending toomany seconds on query
processing.
@@ -42259,6 +42261,18 @@ pattern sql.setVariable(mvc:int,varname:
address setVariable;
comment Set the value of a session variable
+pattern sql.shutdown(delay:int):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:int,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:sht,force:bit):str
+address SQLshutdown_wrap;
+pattern sql.shutdown(delay:bte,force:bit):str
+address SQLshutdown_wrap;
pattern sql.start2():void
address SQLsession2;
comment Switch to processing precompiled sql statements
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -78,6 +78,7 @@ SYSTEM VIEW sys.querylog_calls
SYSTEM VIEW sys.querylog_catalog
SYSTEM VIEW sys.querylog_history
SYSTEM VIEW sys.queue
+SYSTEM VIEW sys.sessions
SYSTEM VIEW sys.storage
SYSTEM VIEW sys.storagemodel
SYSTEM VIEW sys.tables
@@ -218,6 +219,7 @@ SYSTEM FUNCTION sys.setmasklen
SYSTEM FUNCTION sys.setsession
SYSTEM FUNCTION sys.settimeout
SYSTEM FUNCTION sys.shrink
+SYSTEM FUNCTION sys.shutdown
SYSTEM FUNCTION sys.srid
SYSTEM FUNCTION sys.stddev_pop
SYSTEM FUNCTION sys.stddev_samp
@@ -1442,7 +1444,7 @@ CREATE TABLE "sys"."_columns" (
"number" INTEGER,
"storage" VARCHAR(2048)
);
-COPY 412 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS
'\t','\n','"';
+COPY 418 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS
'\t','\n','"';
2002 "id" "int" 32 0 2001 NULL true 0 NULL
2003 "name" "varchar" 1024 0 2001 NULL true 1
NULL
2004 "authorization" "int" 32 0 2001 NULL true 2
NULL
@@ -1742,119 +1744,125 @@ 5545 "sessiontimeout" "bigint" 64
0 5542
5546 "lastcommand" "timestamp" 7 0 5542 NULL true
3 NULL
5547 "querytimeout" "bigint" 64 0 5542 NULL true
4 NULL
5548 "active" "boolean" 1 0 5542 NULL true
5 NULL
-5605 "rewrite" "clob" 0 0 5604 NULL true 0
NULL
-5606 "count" "int" 32 0 5604 NULL true 1 NULL
-5611 "query" "clob" 0 0 5610 NULL true 0 NULL
-5612 "count" "int" 32 0 5610 NULL true 1 NULL
-5620 "name" "clob" 0 0 5619 NULL true 0 NULL
-5621 "def" "clob" 0 0 5619 NULL true 1 NULL
-5622 "status" "clob" 0 0 5619 NULL true 2
NULL
-5627 "name" "clob" 0 0 5630 NULL true 0 NULL
-5628 "def" "clob" 0 0 5630 NULL true 1 NULL
-5629 "status" "clob" 0 0 5630 NULL true 2
NULL
-5632 "name" "clob" 0 0 5631 NULL true 0 NULL
-5633 "value" "clob" 0 0 5631 NULL true 1 NULL
-5638 "name" "clob" 0 0 5640 NULL true 0 NULL
-5639 "value" "clob" 0 0 5640 NULL true 1 NULL
-5642 "id" "int" 32 0 5641 NULL true 0 NULL
-5643 "name" "clob" 0 0 5641 NULL true 1 NULL
-5644 "htype" "clob" 0 0 5641 NULL true 2 NULL
-5645 "ttype" "clob" 0 0 5641 NULL true 3 NULL
-5646 "count" "bigint" 64 0 5641 NULL true 4
NULL
-5647 "refcnt" "int" 32 0 5641 NULL true 5
NULL
-5648 "lrefcnt" "int" 32 0 5641 NULL true 6
NULL
-5649 "location" "clob" 0 0 5641 NULL true 7
NULL
-5650 "heat" "int" 32 0 5641 NULL true 8 NULL
-5651 "dirty" "clob" 0 0 5641 NULL true 9 NULL
-5652 "status" "clob" 0 0 5641 NULL true 10
NULL
-5653 "kind" "clob" 0 0 5641 NULL true 11 NULL
-5662 "qtag" "bigint" 64 0 5661 NULL true 0
NULL
-5663 "user" "clob" 0 0 5661 NULL true 1 NULL
-5664 "started" "timestamp" 7 0 5661 NULL true
2 NULL
-5665 "estimate" "timestamp" 7 0 5661 NULL true
3 NULL
-5666 "progress" "int" 32 0 5661 NULL true 4
NULL
-5667 "status" "clob" 0 0 5661 NULL true 5
NULL
-5668 "tag" "oid" 63 0 5661 NULL true 6 NULL
-5669 "query" "clob" 0 0 5661 NULL true 7 NULL
-5674 "qtag" "bigint" 64 0 5682 NULL true 0
NULL
-5675 "user" "clob" 0 0 5682 NULL true 1 NULL
-5676 "started" "timestamp" 7 0 5682 NULL true
2 NULL
-5677 "estimate" "timestamp" 7 0 5682 NULL true
3 NULL
-5678 "progress" "int" 32 0 5682 NULL true 4
NULL
-5679 "status" "clob" 0 0 5682 NULL true 5
NULL
-5680 "tag" "oid" 63 0 5682 NULL true 6 NULL
-5681 "query" "clob" 0 0 5682 NULL true 7 NULL
-6186 "schema" "clob" 0 0 6185 NULL true 0
NULL
-6187 "table" "clob" 0 0 6185 NULL true 1 NULL
-6188 "column" "clob" 0 0 6185 NULL true 2
NULL
-6189 "type" "clob" 0 0 6185 NULL true 3 NULL
-6190 "location" "clob" 0 0 6185 NULL true 4
NULL
-6191 "count" "bigint" 64 0 6185 NULL true 5
NULL
-6192 "typewidth" "int" 32 0 6185 NULL true 6
NULL
-6193 "columnsize" "bigint" 64 0 6185 NULL true
7 NULL
-6194 "heapsize" "bigint" 64 0 6185 NULL true
8 NULL
-6195 "indices" "bigint" 64 0 6185 NULL true
9 NULL
-6196 "sorted" "boolean" 1 0 6185 NULL true
10 NULL
-6201 "schema" "clob" 0 0 6212 NULL true 0
NULL
-6202 "table" "clob" 0 0 6212 NULL true 1 NULL
-6203 "column" "clob" 0 0 6212 NULL true 2
NULL
-6204 "type" "clob" 0 0 6212 NULL true 3 NULL
-6205 "location" "clob" 0 0 6212 NULL true 4
NULL
-6206 "count" "bigint" 64 0 6212 NULL true 5
NULL
-6207 "typewidth" "int" 32 0 6212 NULL true 6
NULL
-6208 "columnsize" "bigint" 64 0 6212 NULL true
7 NULL
-6209 "heapsize" "bigint" 64 0 6212 NULL true
8 NULL
-6210 "indices" "bigint" 64 0 6212 NULL true
9 NULL
-6211 "sorted" "boolean" 1 0 6212 NULL true
10 NULL
-6214 "schema" "clob" 0 0 6224 NULL true 0
NULL
-6215 "table" "clob" 0 0 6224 NULL true 1 NULL
-6216 "column" "clob" 0 0 6224 NULL true 2
NULL
-6217 "type" "clob" 0 0 6224 NULL true 3 NULL
-6218 "typewidth" "int" 32 0 6224 NULL true 4
NULL
-6219 "count" "bigint" 64 0 6224 NULL true 5
NULL
-6220 "distinct" "bigint" 64 0 6224 NULL true
6 NULL
-6221 "atomwidth" "int" 32 0 6224 NULL true 7
NULL
-6222 "reference" "boolean" 1 0 6224 NULL true
8 NULL
-6223 "sorted" "boolean" 1 0 6224 NULL true
9 NULL
-6245 "schema" "clob" 0 0 6244 NULL true 0
NULL
-6246 "table" "clob" 0 0 6244 NULL true 1 NULL
-6247 "column" "clob" 0 0 6244 NULL true 2
NULL
-6248 "type" "clob" 0 0 6244 NULL true 3 NULL
-6249 "count" "bigint" 64 0 6244 NULL true 4
NULL
-6250 "columnsize" "bigint" 64 0 6244 NULL true
5 NULL
-6251 "heapsize" "bigint" 64 0 6244 NULL true
6 NULL
-6252 "indices" "bigint" 64 0 6244 NULL true
7 NULL
-6253 "sorted" "boolean" 1 0 6244 NULL true
8 NULL
-6258 "schema" "clob" 0 0 6267 NULL true 0
NULL
-6259 "table" "clob" 0 0 6267 NULL true 1 NULL
-6260 "column" "clob" 0 0 6267 NULL true 2
NULL
-6261 "type" "clob" 0 0 6267 NULL true 3 NULL
-6262 "count" "bigint" 64 0 6267 NULL true 4
NULL
-6263 "columnsize" "bigint" 64 0 6267 NULL true
5 NULL
-6264 "heapsize" "bigint" 64 0 6267 NULL true
6 NULL
-6265 "indices" "bigint" 64 0 6267 NULL true
7 NULL
-6266 "sorted" "boolean" 1 0 6267 NULL true
8 NULL
-6269 "schema" "clob" 0 0 6276 NULL true 0
NULL
-6270 "table" "clob" 0 0 6276 NULL true 1 NULL
-6271 "count" "bigint" 64 0 6276 NULL true 2
NULL
-6272 "columnsize" "bigint" 64 0 6276 NULL true
3 NULL
-6273 "heapsize" "bigint" 64 0 6276 NULL true
4 NULL
-6274 "indices" "bigint" 64 0 6276 NULL true
5 NULL
-6275 "auxillary" "bigint" 53 0 6276 NULL true
6 NULL
-6278 "schema" "clob" 0 0 6291 NULL true 0
NULL
-6279 "table" "clob" 0 0 6291 NULL true 1 NULL
-6280 "column" "clob" 0 0 6291 NULL true 2
NULL
-6281 "type" "clob" 0 0 6291 NULL true 3 NULL
-6282 "width" "int" 32 0 6291 NULL true 4 NULL
-6283 "stamp" "timestamp" 7 0 6291 NULL true 5
NULL
-6284 "sample" "bigint" 64 0 6291 NULL true
6 NULL
-6285 "count" "bigint" 64 0 6291 NULL true 7
NULL
-6286 "unique" "bigint" 64 0 6291 NULL true
8 NULL
-6287 "nils" "bigint" 64 0 6291 NULL true 9
NULL
-6288 "minval" "clob" 0 0 6291 NULL true 10
NULL
-6289 "maxval" "clob" 0 0 6291 NULL true 11
NULL
-6290 "sorted" "boolean" 1 0 6291 NULL true
12 NULL
-6344 "function_id" "int" 32 0 6345 NULL true 0
NULL
+5553 "user" "clob" 0 0 5559 NULL true 0 NULL
+5554 "login" "timestamp" 7 0 5559 NULL true 1
NULL
+5555 "sessiontimeout" "bigint" 64 0 5559 NULL
true 2 NULL
+5556 "lastcommand" "timestamp" 7 0 5559 NULL true
3 NULL
+5557 "querytimeout" "bigint" 64 0 5559 NULL true
4 NULL
+5558 "active" "boolean" 1 0 5559 NULL true
5 NULL
+5620 "rewrite" "clob" 0 0 5619 NULL true 0
NULL
+5621 "count" "int" 32 0 5619 NULL true 1 NULL
+5626 "query" "clob" 0 0 5625 NULL true 0 NULL
+5627 "count" "int" 32 0 5625 NULL true 1 NULL
+5635 "name" "clob" 0 0 5634 NULL true 0 NULL
+5636 "def" "clob" 0 0 5634 NULL true 1 NULL
+5637 "status" "clob" 0 0 5634 NULL true 2
NULL
+5642 "name" "clob" 0 0 5645 NULL true 0 NULL
+5643 "def" "clob" 0 0 5645 NULL true 1 NULL
+5644 "status" "clob" 0 0 5645 NULL true 2
NULL
+5647 "name" "clob" 0 0 5646 NULL true 0 NULL
+5648 "value" "clob" 0 0 5646 NULL true 1 NULL
+5653 "name" "clob" 0 0 5655 NULL true 0 NULL
+5654 "value" "clob" 0 0 5655 NULL true 1 NULL
+5657 "id" "int" 32 0 5656 NULL true 0 NULL
+5658 "name" "clob" 0 0 5656 NULL true 1 NULL
+5659 "htype" "clob" 0 0 5656 NULL true 2 NULL
+5660 "ttype" "clob" 0 0 5656 NULL true 3 NULL
+5661 "count" "bigint" 64 0 5656 NULL true 4
NULL
+5662 "refcnt" "int" 32 0 5656 NULL true 5
NULL
+5663 "lrefcnt" "int" 32 0 5656 NULL true 6
NULL
+5664 "location" "clob" 0 0 5656 NULL true 7
NULL
+5665 "heat" "int" 32 0 5656 NULL true 8 NULL
+5666 "dirty" "clob" 0 0 5656 NULL true 9 NULL
+5667 "status" "clob" 0 0 5656 NULL true 10
NULL
+5668 "kind" "clob" 0 0 5656 NULL true 11 NULL
+5677 "qtag" "bigint" 64 0 5676 NULL true 0
NULL
+5678 "user" "clob" 0 0 5676 NULL true 1 NULL
+5679 "started" "timestamp" 7 0 5676 NULL true
2 NULL
+5680 "estimate" "timestamp" 7 0 5676 NULL true
3 NULL
+5681 "progress" "int" 32 0 5676 NULL true 4
NULL
+5682 "status" "clob" 0 0 5676 NULL true 5
NULL
+5683 "tag" "oid" 63 0 5676 NULL true 6 NULL
+5684 "query" "clob" 0 0 5676 NULL true 7 NULL
+5689 "qtag" "bigint" 64 0 5697 NULL true 0
NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
