Changeset: a1b24d5896ff for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a1b24d5896ff
Modified Files:
clients/Tests/SQL-dump.stable.out.32bit
Branch: multifarm
Log Message:
Merge with default branch.
diffs (truncated from 526 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
@@ -1680,60 +1680,60 @@ 5713 "progress" "int" 32 0 5717
NULL tru
5714 "status" "clob" 0 0 5717 NULL true 5
NULL
5715 "tag" "oid" 31 0 5717 NULL true 6 NULL
5716 "query" "clob" 0 0 5717 NULL true 7 NULL
-6352 "schema" "clob" 0 0 6364 NULL true 0
NULL
-6353 "table" "clob" 0 0 6364 NULL true 1 NULL
-6354 "column" "clob" 0 0 6364 NULL true 2
NULL
-6355 "type" "clob" 0 0 6364 NULL true 3 NULL
-6356 "location" "clob" 0 0 6364 NULL true 4
NULL
-6357 "count" "bigint" 64 0 6364 NULL true 5
NULL
-6358 "typewidth" "int" 32 0 6364 NULL true 6
NULL
-6359 "columnsize" "bigint" 64 0 6364 NULL true
7 NULL
-6360 "heapsize" "bigint" 64 0 6364 NULL true
8 NULL
-6361 "hashes" "bigint" 64 0 6364 NULL true
9 NULL
-6362 "imprints" "bigint" 64 0 6364 NULL true
10 NULL
-6363 "sorted" "boolean" 1 0 6364 NULL true
11 NULL
-6366 "schema" "clob" 0 0 6376 NULL true 0
NULL
-6367 "table" "clob" 0 0 6376 NULL true 1 NULL
-6368 "column" "clob" 0 0 6376 NULL true 2
NULL
-6369 "type" "clob" 0 0 6376 NULL true 3 NULL
-6370 "typewidth" "int" 32 0 6376 NULL true 4
NULL
-6371 "count" "bigint" 64 0 6376 NULL true 5
NULL
-6372 "distinct" "bigint" 64 0 6376 NULL true
6 NULL
-6373 "atomwidth" "int" 32 0 6376 NULL true 7
NULL
-6374 "reference" "boolean" 1 0 6376 NULL true
8 NULL
-6375 "sorted" "boolean" 1 0 6376 NULL true
9 NULL
-6414 "schema" "clob" 0 0 6424 NULL true 0
NULL
-6415 "table" "clob" 0 0 6424 NULL true 1 NULL
-6416 "column" "clob" 0 0 6424 NULL true 2
NULL
-6417 "type" "clob" 0 0 6424 NULL true 3 NULL
-6418 "count" "bigint" 64 0 6424 NULL true 4
NULL
-6419 "columnsize" "bigint" 64 0 6424 NULL true
5 NULL
-6420 "heapsize" "bigint" 64 0 6424 NULL true
6 NULL
-6421 "hashes" "bigint" 64 0 6424 NULL true
7 NULL
-6422 "imprints" "bigint" 64 0 6424 NULL true
8 NULL
-6423 "sorted" "boolean" 1 0 6424 NULL true
9 NULL
-6426 "schema" "clob" 0 0 6434 NULL true 0
NULL
-6427 "table" "clob" 0 0 6434 NULL true 1 NULL
-6428 "count" "bigint" 64 0 6434 NULL true 2
NULL
-6429 "columnsize" "bigint" 64 0 6434 NULL true
3 NULL
-6430 "heapsize" "bigint" 64 0 6434 NULL true
4 NULL
-6431 "hashes" "bigint" 64 0 6434 NULL true
5 NULL
-6432 "imprints" "bigint" 64 0 6434 NULL true
6 NULL
-6433 "auxillary" "bigint" 53 0 6434 NULL true
7 NULL
-6436 "schema" "clob" 0 0 6449 NULL true 0
NULL
-6437 "table" "clob" 0 0 6449 NULL true 1 NULL
-6438 "column" "clob" 0 0 6449 NULL true 2
NULL
-6439 "type" "clob" 0 0 6449 NULL true 3 NULL
-6440 "width" "int" 32 0 6449 NULL true 4 NULL
-6441 "stamp" "timestamp" 7 0 6449 NULL true 5
NULL
-6442 "sample" "bigint" 64 0 6449 NULL true
6 NULL
-6443 "count" "bigint" 64 0 6449 NULL true 7
NULL
-6444 "unique" "bigint" 64 0 6449 NULL true
8 NULL
-6445 "nils" "bigint" 64 0 6449 NULL true 9
NULL
-6446 "minval" "clob" 0 0 6449 NULL true 10
NULL
-6447 "maxval" "clob" 0 0 6449 NULL true 11
NULL
-6448 "sorted" "boolean" 1 0 6449 NULL true
12 NULL
-6502 "function_id" "int" 32 0 6503 NULL true 0
NULL
+6356 "schema" "clob" 0 0 6368 NULL true 0
NULL
+6357 "table" "clob" 0 0 6368 NULL true 1 NULL
+6358 "column" "clob" 0 0 6368 NULL true 2
NULL
+6359 "type" "clob" 0 0 6368 NULL true 3 NULL
+6360 "location" "clob" 0 0 6368 NULL true 4
NULL
+6361 "count" "bigint" 64 0 6368 NULL true 5
NULL
+6362 "typewidth" "int" 32 0 6368 NULL true 6
NULL
+6363 "columnsize" "bigint" 64 0 6368 NULL true
7 NULL
+6364 "heapsize" "bigint" 64 0 6368 NULL true
8 NULL
+6365 "hashes" "bigint" 64 0 6368 NULL true
9 NULL
+6366 "imprints" "bigint" 64 0 6368 NULL true
10 NULL
+6367 "sorted" "boolean" 1 0 6368 NULL true
11 NULL
+6370 "schema" "clob" 0 0 6380 NULL true 0
NULL
+6371 "table" "clob" 0 0 6380 NULL true 1 NULL
+6372 "column" "clob" 0 0 6380 NULL true 2
NULL
+6373 "type" "clob" 0 0 6380 NULL true 3 NULL
+6374 "typewidth" "int" 32 0 6380 NULL true 4
NULL
+6375 "count" "bigint" 64 0 6380 NULL true 5
NULL
+6376 "distinct" "bigint" 64 0 6380 NULL true
6 NULL
+6377 "atomwidth" "int" 32 0 6380 NULL true 7
NULL
+6378 "reference" "boolean" 1 0 6380 NULL true
8 NULL
+6379 "sorted" "boolean" 1 0 6380 NULL true
9 NULL
+6418 "schema" "clob" 0 0 6428 NULL true 0
NULL
+6419 "table" "clob" 0 0 6428 NULL true 1 NULL
+6420 "column" "clob" 0 0 6428 NULL true 2
NULL
+6421 "type" "clob" 0 0 6428 NULL true 3 NULL
+6422 "count" "bigint" 64 0 6428 NULL true 4
NULL
+6423 "columnsize" "bigint" 64 0 6428 NULL true
5 NULL
+6424 "heapsize" "bigint" 64 0 6428 NULL true
6 NULL
+6425 "hashes" "bigint" 64 0 6428 NULL true
7 NULL
+6426 "imprints" "bigint" 64 0 6428 NULL true
8 NULL
+6427 "sorted" "boolean" 1 0 6428 NULL true
9 NULL
+6430 "schema" "clob" 0 0 6438 NULL true 0
NULL
+6431 "table" "clob" 0 0 6438 NULL true 1 NULL
+6432 "count" "bigint" 64 0 6438 NULL true 2
NULL
+6433 "columnsize" "bigint" 64 0 6438 NULL true
3 NULL
+6434 "heapsize" "bigint" 64 0 6438 NULL true
4 NULL
+6435 "hashes" "bigint" 64 0 6438 NULL true
5 NULL
+6436 "imprints" "bigint" 64 0 6438 NULL true
6 NULL
+6437 "auxillary" "bigint" 53 0 6438 NULL true
7 NULL
+6440 "schema" "clob" 0 0 6453 NULL true 0
NULL
+6441 "table" "clob" 0 0 6453 NULL true 1 NULL
+6442 "column" "clob" 0 0 6453 NULL true 2
NULL
+6443 "type" "clob" 0 0 6453 NULL true 3 NULL
+6444 "width" "int" 32 0 6453 NULL true 4 NULL
+6445 "stamp" "timestamp" 7 0 6453 NULL true 5
NULL
+6446 "sample" "bigint" 64 0 6453 NULL true
6 NULL
+6447 "count" "bigint" 64 0 6453 NULL true 7
NULL
+6448 "unique" "bigint" 64 0 6453 NULL true
8 NULL
+6449 "nils" "bigint" 64 0 6453 NULL true 9
NULL
+6450 "minval" "clob" 0 0 6453 NULL true 10
NULL
+6451 "maxval" "clob" 0 0 6453 NULL true 11
NULL
+6452 "sorted" "boolean" 1 0 6453 NULL true
12 NULL
+6506 "function_id" "int" 32 0 6507 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1781,12 +1781,12 @@ 5591 "sessions" 2000 "create view sys.se
5671 "optimizers" 2000 "create view sys.optimizers as select * from
sys.optimizers();" 1 true 0 false
5679 "environment" 2000 "create view sys.environment as select * from
sys.environment();" 1 true 0 false
5717 "queue" 2000 "create view sys.queue as select * from sys.queue();"
1 true 0 false
-6364 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
-6376 "storagemodelinput" 2000 NULL 0 true 0 false
-6424 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6434 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 *
count else 0 end) as auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
-6449 "statistics" 2000 NULL 0 true 0 false
-6503 "systemfunctions" 2000 NULL 0 true 0 false
+6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
+6380 "storagemodelinput" 2000 NULL 0 true 0 false
+6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 *
count else 0 end) as auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6453 "statistics" 2000 NULL 0 true 0 false
+6507 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."args" (
@@ -1799,7 +1799,7 @@ CREATE TABLE "sys"."args" (
"inout" TINYINT,
"number" INTEGER
);
-COPY 3654 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3656 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
2155 28 "res_0" "oid" 31 0 0 0
2156 28 "arg_1" "wrd" 32 0 1 1
2157 29 "res_0" "oid" 31 0 0 0
@@ -5385,75 +5385,77 @@ 6316 6314 "js" "json" 0 0 1
1
6319 6318 "result" "clob" 0 0 0 0
6320 6318 "x" "clob" 0 0 1 1
6323 6322 "result" "clob" 0 0 0 0
-6324 6322 "v" "clob" 0 0 1 1
-6328 6327 "result" "uuid" 0 0 0 0
-6331 6330 "result" "uuid" 0 0 0 0
-6332 6330 "u" "uuid" 0 0 1 1
+6324 6322 "x" "double" 53 0 1 1
+6327 6326 "result" "clob" 0 0 0 0
+6328 6326 "v" "clob" 0 0 1 1
+6332 6331 "result" "uuid" 0 0 0 0
6335 6334 "result" "uuid" 0 0 0 0
-6336 6334 "u" "clob" 0 0 1 1
-6339 6338 "schema" "clob" 0 0 0 0
-6340 6338 "table" "clob" 0 0 0 1
-6341 6338 "column" "clob" 0 0 0 2
-6342 6338 "type" "clob" 0 0 0 3
-6343 6338 "location" "clob" 0 0 0 4
-6344 6338 "count" "bigint" 64 0 0 5
-6345 6338 "typewidth" "int" 32 0 0 6
-6346 6338 "columnsize" "bigint" 64 0 0 7
-6347 6338 "heapsize" "bigint" 64 0 0 8
-6348 6338 "hashes" "bigint" 64 0 0 9
-6349 6338 "imprints" "bigint" 64 0 0 10
-6350 6338 "sorted" "boolean" 1 0 0 11
-6381 6380 "result" "bigint" 64 0 0 0
-6382 6380 "nme" "clob" 0 0 1 1
-6383 6380 "i" "bigint" 64 0 1 2
-6384 6380 "d" "bigint" 64 0 1 3
-6387 6386 "result" "bigint" 64 0 0 0
-6388 6386 "tpe" "clob" 0 0 1 1
-6389 6386 "i" "bigint" 64 0 1 2
-6390 6386 "w" "int" 32 0 1 3
-6393 6392 "result" "bigint" 64 0 0 0
-6394 6392 "b" "boolean" 1 0 1 1
-6395 6392 "i" "bigint" 64 0 1 2
-6398 6397 "result" "bigint" 64 0 0 0
-6399 6397 "i" "bigint" 64 0 1 1
-6400 6397 "nme" "clob" 0 0 1 2
-6403 6402 "schema" "clob" 0 0 0 0
-6404 6402 "table" "clob" 0 0 0 1
-6405 6402 "column" "clob" 0 0 0 2
-6406 6402 "type" "clob" 0 0 0 3
-6407 6402 "count" "bigint" 64 0 0 4
-6408 6402 "columnsize" "bigint" 64 0 0 5
-6409 6402 "heapsize" "bigint" 64 0 0 6
-6410 6402 "hashes" "bigint" 64 0 0 7
-6411 6402 "imprints" "bigint" 64 0 0 8
-6412 6402 "sorted" "boolean" 1 0 0 9
-6454 6453 "tbl" "clob" 0 0 1 0
-6457 6456 "sch" "clob" 0 0 1 0
-6458 6456 "tbl" "clob" 0 0 1 1
+6336 6334 "u" "uuid" 0 0 1 1
+6339 6338 "result" "uuid" 0 0 0 0
+6340 6338 "u" "clob" 0 0 1 1
+6343 6342 "schema" "clob" 0 0 0 0
+6344 6342 "table" "clob" 0 0 0 1
+6345 6342 "column" "clob" 0 0 0 2
+6346 6342 "type" "clob" 0 0 0 3
+6347 6342 "location" "clob" 0 0 0 4
+6348 6342 "count" "bigint" 64 0 0 5
+6349 6342 "typewidth" "int" 32 0 0 6
+6350 6342 "columnsize" "bigint" 64 0 0 7
+6351 6342 "heapsize" "bigint" 64 0 0 8
+6352 6342 "hashes" "bigint" 64 0 0 9
+6353 6342 "imprints" "bigint" 64 0 0 10
+6354 6342 "sorted" "boolean" 1 0 0 11
+6385 6384 "result" "bigint" 64 0 0 0
+6386 6384 "nme" "clob" 0 0 1 1
+6387 6384 "i" "bigint" 64 0 1 2
+6388 6384 "d" "bigint" 64 0 1 3
+6391 6390 "result" "bigint" 64 0 0 0
+6392 6390 "tpe" "clob" 0 0 1 1
+6393 6390 "i" "bigint" 64 0 1 2
+6394 6390 "w" "int" 32 0 1 3
+6397 6396 "result" "bigint" 64 0 0 0
+6398 6396 "b" "boolean" 1 0 1 1
+6399 6396 "i" "bigint" 64 0 1 2
+6402 6401 "result" "bigint" 64 0 0 0
+6403 6401 "i" "bigint" 64 0 1 1
+6404 6401 "nme" "clob" 0 0 1 2
+6407 6406 "schema" "clob" 0 0 0 0
+6408 6406 "table" "clob" 0 0 0 1
+6409 6406 "column" "clob" 0 0 0 2
+6410 6406 "type" "clob" 0 0 0 3
+6411 6406 "count" "bigint" 64 0 0 4
+6412 6406 "columnsize" "bigint" 64 0 0 5
+6413 6406 "heapsize" "bigint" 64 0 0 6
+6414 6406 "hashes" "bigint" 64 0 0 7
+6415 6406 "imprints" "bigint" 64 0 0 8
+6416 6406 "sorted" "boolean" 1 0 0 9
+6458 6457 "tbl" "clob" 0 0 1 0
6461 6460 "sch" "clob" 0 0 1 0
6462 6460 "tbl" "clob" 0 0 1 1
-6463 6460 "col" "clob" 0 0 1 2
-6466 6465 "sample" "bigint" 64 0 1 0
-6469 6468 "tbl" "clob" 0 0 1 0
-6470 6468 "sample" "bigint" 64 0 1 1
-6473 6472 "sch" "clob" 0 0 1 0
-6474 6472 "tbl" "clob" 0 0 1 1
-6475 6472 "sample" "bigint" 64 0 1 2
-6478 6477 "sch" "clob" 0 0 1 0
-6479 6477 "tbl" "clob" 0 0 1 1
-6480 6477 "col" "clob" 0 0 1 2
-6481 6477 "sample" "bigint" 64 0 1 3
-6484 6483 "result" "clob" 0 0 0 0
-6485 6483 "src" "clob" 0 0 1 1
-6488 6487 "result" "smallint" 16 0 0 0
-6489 6487 "one" "tinyint" 8 0 1 1
-6490 6487 "two" "tinyint" 8 0 1 2
-6493 6492 "result" "int" 32 0 0 0
-6494 6492 "one" "smallint" 16 0 1 1
-6495 6492 "two" "smallint" 16 0 1 2
-6498 6497 "result" "bigint" 64 0 0 0
-6499 6497 "one" "int" 32 0 1 1
-6500 6497 "two" "int" 32 0 1 2
+6465 6464 "sch" "clob" 0 0 1 0
+6466 6464 "tbl" "clob" 0 0 1 1
+6467 6464 "col" "clob" 0 0 1 2
+6470 6469 "sample" "bigint" 64 0 1 0
+6473 6472 "tbl" "clob" 0 0 1 0
+6474 6472 "sample" "bigint" 64 0 1 1
+6477 6476 "sch" "clob" 0 0 1 0
+6478 6476 "tbl" "clob" 0 0 1 1
+6479 6476 "sample" "bigint" 64 0 1 2
+6482 6481 "sch" "clob" 0 0 1 0
+6483 6481 "tbl" "clob" 0 0 1 1
+6484 6481 "col" "clob" 0 0 1 2
+6485 6481 "sample" "bigint" 64 0 1 3
+6488 6487 "result" "clob" 0 0 0 0
+6489 6487 "src" "clob" 0 0 1 1
+6492 6491 "result" "smallint" 16 0 0 0
+6493 6491 "one" "tinyint" 8 0 1 1
+6494 6491 "two" "tinyint" 8 0 1 2
+6497 6496 "result" "int" 32 0 0 0
+6498 6496 "one" "smallint" 16 0 1 1
+6499 6496 "two" "smallint" 16 0 1 2
+6502 6501 "result" "bigint" 64 0 0 0
+6503 6501 "one" "int" 32 0 1 1
+6504 6501 "two" "int" 32 0 1 2
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."auths" (
@@ -5652,52 +5654,52 @@ 5617 5622 7
5663 5671 5
5673 5679 5
5699 5717 5
-6338 6364 5
-6366 6378 13
-6376 6378 13
-6367 6378 13
-6368 6378 13
-6369 6378 13
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
