Changeset: d3e84a56bfa8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3e84a56bfa8
Modified Files:
clients/Tests/SQL-dump.stable.out.32bit
clients/Tests/SQL-dump.stable.out.64bit.oid32
clients/Tests/SQL-dump_nogeom.stable.out
Branch: default
Log Message:
Approved specific outputs. See changeset 0d96216a9bd3.
diffs (truncated from 5262 to 300 lines):
diff --git a/clients/Tests/SQL-dump.stable.out.32bit
b/clients/Tests/SQL-dump.stable.out.32bit
--- a/clients/Tests/SQL-dump.stable.out.32bit
+++ b/clients/Tests/SQL-dump.stable.out.32bit
@@ -82,6 +82,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
@@ -204,6 +205,7 @@ SYSTEM FUNCTION sys.point
SYSTEM FUNCTION sys.pointfromtext
SYSTEM FUNCTION sys.polyfromtext
SYSTEM FUNCTION sys.polygonfromtext
+SYSTEM FUNCTION sys.quantile
SYSTEM FUNCTION sys.querycache
SYSTEM FUNCTION sys.querylog
SYSTEM FUNCTION sys.querylog_calls
@@ -222,6 +224,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
@@ -837,6 +840,8 @@ create aggregate median(val wrd) returns
external name "aggr"."median";
create aggregate median(val bigint) returns bigint
external name "aggr"."median";
+create aggregate median(val decimal) returns decimal
+ external name "aggr"."median";
create aggregate median(val real) returns real
external name "aggr"."median";
create aggregate median(val double) returns double
@@ -1446,7 +1451,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
@@ -1746,119 +1751,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" 31 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" 31 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" 31 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
+5690 "user" "clob" 0 0 5697 NULL true 1 NULL
+5691 "started" "timestamp" 7 0 5697 NULL true
2 NULL
+5692 "estimate" "timestamp" 7 0 5697 NULL true
3 NULL
+5693 "progress" "int" 32 0 5697 NULL true 4
NULL
+5694 "status" "clob" 0 0 5697 NULL true 5
NULL
+5695 "tag" "oid" 31 0 5697 NULL true 6 NULL
+5696 "query" "clob" 0 0 5697 NULL true 7 NULL
+6260 "schema" "clob" 0 0 6259 NULL true 0
NULL
+6261 "table" "clob" 0 0 6259 NULL true 1 NULL
+6262 "column" "clob" 0 0 6259 NULL true 2
NULL
+6263 "type" "clob" 0 0 6259 NULL true 3 NULL
+6264 "location" "clob" 0 0 6259 NULL true 4
NULL
+6265 "count" "bigint" 64 0 6259 NULL true 5
NULL
+6266 "typewidth" "int" 32 0 6259 NULL true 6
NULL
+6267 "columnsize" "bigint" 64 0 6259 NULL true
7 NULL
+6268 "heapsize" "bigint" 64 0 6259 NULL true
8 NULL
+6269 "indices" "bigint" 64 0 6259 NULL true
9 NULL
+6270 "sorted" "boolean" 1 0 6259 NULL true
10 NULL
+6275 "schema" "clob" 0 0 6286 NULL true 0
NULL
+6276 "table" "clob" 0 0 6286 NULL true 1 NULL
+6277 "column" "clob" 0 0 6286 NULL true 2
NULL
+6278 "type" "clob" 0 0 6286 NULL true 3 NULL
+6279 "location" "clob" 0 0 6286 NULL true 4
NULL
+6280 "count" "bigint" 64 0 6286 NULL true 5
NULL
+6281 "typewidth" "int" 32 0 6286 NULL true 6
NULL
+6282 "columnsize" "bigint" 64 0 6286 NULL true
7 NULL
+6283 "heapsize" "bigint" 64 0 6286 NULL true
8 NULL
+6284 "indices" "bigint" 64 0 6286 NULL true
9 NULL
+6285 "sorted" "boolean" 1 0 6286 NULL true
10 NULL
+6288 "schema" "clob" 0 0 6298 NULL true 0
NULL
+6289 "table" "clob" 0 0 6298 NULL true 1 NULL
+6290 "column" "clob" 0 0 6298 NULL true 2
NULL
+6291 "type" "clob" 0 0 6298 NULL true 3 NULL
+6292 "typewidth" "int" 32 0 6298 NULL true 4
NULL
+6293 "count" "bigint" 64 0 6298 NULL true 5
NULL
+6294 "distinct" "bigint" 64 0 6298 NULL true
6 NULL
+6295 "atomwidth" "int" 32 0 6298 NULL true 7
NULL
+6296 "reference" "boolean" 1 0 6298 NULL true
8 NULL
+6297 "sorted" "boolean" 1 0 6298 NULL true
9 NULL
+6319 "schema" "clob" 0 0 6318 NULL true 0
NULL
+6320 "table" "clob" 0 0 6318 NULL true 1 NULL
+6321 "column" "clob" 0 0 6318 NULL true 2
NULL
+6322 "type" "clob" 0 0 6318 NULL true 3 NULL
+6323 "count" "bigint" 64 0 6318 NULL true 4
NULL
+6324 "columnsize" "bigint" 64 0 6318 NULL true
5 NULL
+6325 "heapsize" "bigint" 64 0 6318 NULL true
6 NULL
+6326 "indices" "bigint" 64 0 6318 NULL true
7 NULL
+6327 "sorted" "boolean" 1 0 6318 NULL true
8 NULL
+6332 "schema" "clob" 0 0 6341 NULL true 0
NULL
+6333 "table" "clob" 0 0 6341 NULL true 1 NULL
+6334 "column" "clob" 0 0 6341 NULL true 2
NULL
+6335 "type" "clob" 0 0 6341 NULL true 3 NULL
+6336 "count" "bigint" 64 0 6341 NULL true 4
NULL
+6337 "columnsize" "bigint" 64 0 6341 NULL true
5 NULL
+6338 "heapsize" "bigint" 64 0 6341 NULL true
6 NULL
+6339 "indices" "bigint" 64 0 6341 NULL true
7 NULL
+6340 "sorted" "boolean" 1 0 6341 NULL true
8 NULL
+6343 "schema" "clob" 0 0 6350 NULL true 0
NULL
+6344 "table" "clob" 0 0 6350 NULL true 1 NULL
+6345 "count" "bigint" 64 0 6350 NULL true 2
NULL
+6346 "columnsize" "bigint" 64 0 6350 NULL true
3 NULL
+6347 "heapsize" "bigint" 64 0 6350 NULL true
4 NULL
+6348 "indices" "bigint" 64 0 6350 NULL true
5 NULL
+6349 "auxillary" "bigint" 53 0 6350 NULL true
6 NULL
+6352 "schema" "clob" 0 0 6365 NULL true 0
NULL
+6353 "table" "clob" 0 0 6365 NULL true 1 NULL
+6354 "column" "clob" 0 0 6365 NULL true 2
NULL
+6355 "type" "clob" 0 0 6365 NULL true 3 NULL
+6356 "width" "int" 32 0 6365 NULL true 4 NULL
+6357 "stamp" "timestamp" 7 0 6365 NULL true 5
NULL
+6358 "sample" "bigint" 64 0 6365 NULL true
6 NULL
+6359 "count" "bigint" 64 0 6365 NULL true 7
NULL
+6360 "unique" "bigint" 64 0 6365 NULL true
8 NULL
+6361 "nils" "bigint" 64 0 6365 NULL true 9
NULL
+6362 "minval" "clob" 0 0 6365 NULL true 10
NULL
+6363 "maxval" "clob" 0 0 6365 NULL true 11
NULL
+6364 "sorted" "boolean" 1 0 6365 NULL true
12 NULL
+6418 "function_id" "int" 32 0 6419 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1871,7 +1882,7 @@ CREATE TABLE "sys"."_tables" (
"commit_action" SMALLINT,
"readonly" BOOLEAN
);
-COPY 71 RECORDS INTO "sys"."_tables" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 72 RECORDS INTO "sys"."_tables" FROM stdin USING DELIMITERS '\t','\n','"';
2001 "schemas" 2000 NULL 0 true 0 false
2006 "types" 2000 NULL 0 true 0 false
2015 "functions" 2000 NULL 0 true 0 false
@@ -1926,23 +1937,24 @@ 5517 "#dependencies_functions_on_functio
5524 "#dependencies_functions_os_triggers" 2000 NULL 2 true
0 false
5531 "#dependencies_keys_on_foreignkeys" 2000 NULL 2 true
0 false
5542 "#sessions" 2000 NULL 2 true 0 false
-5604 "#optimizer_stats" 2000 NULL 2 true 0 false
-5610 "#querycache" 2000 NULL 2 true 0 false
-5619 "#optimizers" 2000 NULL 2 true 0 false
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
