Changeset: b575e111bfe6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b575e111bfe6
Modified Files:
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.oid32
clients/Tests/SQL-dump.stable.out.oid32.int128
sql/test/leaks/Tests/check0.stable.out
sql/test/leaks/Tests/check0.stable.out.int128
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check5.stable.out
sql/test/leaks/Tests/select1.stable.out
sql/test/leaks/Tests/select2.stable.out
Branch: default
Log Message:
systems-specific output approval after NetCDF patch
diffs (truncated from 2701 to 300 lines):
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
@@ -1571,102 +1571,124 @@ 5777 "progress" "int" 32 0 5781
NULL tru
5778 "status" "clob" 0 0 5781 NULL true 5
NULL
5779 "tag" "oid" 63 0 5781 NULL true 6 NULL
5780 "query" "clob" 0 0 5781 NULL true 7 NULL
-6439 "schema" "clob" 0 0 6452 NULL true 0
NULL
-6440 "table" "clob" 0 0 6452 NULL true 1 NULL
-6441 "column" "clob" 0 0 6452 NULL true 2
NULL
-6442 "type" "clob" 0 0 6452 NULL true 3 NULL
-6443 "mode" "clob" 0 0 6452 NULL true 4 NULL
-6444 "location" "clob" 0 0 6452 NULL true 5
NULL
-6445 "count" "bigint" 64 0 6452 NULL true 6
NULL
-6446 "typewidth" "int" 32 0 6452 NULL true 7
NULL
-6447 "columnsize" "bigint" 64 0 6452 NULL true
8 NULL
-6448 "heapsize" "bigint" 64 0 6452 NULL true
9 NULL
-6449 "hashes" "bigint" 64 0 6452 NULL true
10 NULL
-6450 "imprints" "bigint" 64 0 6452 NULL true
11 NULL
-6451 "sorted" "boolean" 1 0 6452 NULL true
12 NULL
-6454 "schema" "clob" 0 0 6464 NULL true 0
NULL
-6455 "table" "clob" 0 0 6464 NULL true 1 NULL
-6456 "column" "clob" 0 0 6464 NULL true 2
NULL
-6457 "type" "clob" 0 0 6464 NULL true 3 NULL
-6458 "typewidth" "int" 32 0 6464 NULL true 4
NULL
-6459 "count" "bigint" 64 0 6464 NULL true 5
NULL
-6460 "distinct" "bigint" 64 0 6464 NULL true
6 NULL
-6461 "atomwidth" "int" 32 0 6464 NULL true 7
NULL
-6462 "reference" "boolean" 1 0 6464 NULL true
8 NULL
-6463 "sorted" "boolean" 1 0 6464 NULL true
9 NULL
-6502 "schema" "clob" 0 0 6512 NULL true 0
NULL
-6503 "table" "clob" 0 0 6512 NULL true 1 NULL
-6504 "column" "clob" 0 0 6512 NULL true 2
NULL
-6505 "type" "clob" 0 0 6512 NULL true 3 NULL
-6506 "count" "bigint" 64 0 6512 NULL true 4
NULL
-6507 "columnsize" "bigint" 64 0 6512 NULL true
5 NULL
-6508 "heapsize" "bigint" 64 0 6512 NULL true
6 NULL
-6509 "hashes" "bigint" 64 0 6512 NULL true
7 NULL
-6510 "imprints" "bigint" 64 0 6512 NULL true
8 NULL
-6511 "sorted" "boolean" 1 0 6512 NULL true
9 NULL
-6514 "schema" "clob" 0 0 6522 NULL true 0
NULL
-6515 "table" "clob" 0 0 6522 NULL true 1 NULL
-6516 "count" "bigint" 64 0 6522 NULL true 2
NULL
-6517 "columnsize" "bigint" 64 0 6522 NULL true
3 NULL
-6518 "heapsize" "bigint" 64 0 6522 NULL true
4 NULL
-6519 "hashes" "bigint" 64 0 6522 NULL true
5 NULL
-6520 "imprints" "bigint" 64 0 6522 NULL true
6 NULL
-6521 "auxiliary" "bigint" 64 0 6522 NULL true
7 NULL
-6524 "column_id" "int" 32 0 6535 NULL true 0
NULL
-6525 "type" "clob" 0 0 6535 NULL true 1 NULL
-6526 "width" "int" 32 0 6535 NULL true 2 NULL
-6527 "stamp" "timestamp" 7 0 6535 NULL true 3
NULL
-6528 "sample" "bigint" 64 0 6535 NULL true
4 NULL
-6529 "count" "bigint" 64 0 6535 NULL true 5
NULL
-6530 "unique" "bigint" 64 0 6535 NULL true
6 NULL
-6531 "nils" "bigint" 64 0 6535 NULL true 7
NULL
-6532 "minval" "clob" 0 0 6535 NULL true 8
NULL
-6533 "maxval" "clob" 0 0 6535 NULL true 9
NULL
-6534 "sorted" "boolean" 1 0 6535 NULL true
10 NULL
-6630 "file_id" "bigint" 64 0 6638 NULL false
0 NULL
-6631 "file_location" "clob" 0 0 6638 NULL false 1
NULL
-6632 "dbschema" "smallint" 16 0 6638 NULL false
2 NULL
-6633 "format_version" "varchar" 7 0 6638 NULL
true 3 NULL
-6634 "sorting_order" "varchar" 10 0 6638 NULL true
4 NULL
-6635 "comments" "clob" 0 0 6638 NULL true 5
NULL
-6640 "sn" "clob" 0 0 6651 NULL false 0 NULL
-6641 "file_id" "bigint" 64 0 6651 NULL false
1 NULL
-6642 "ln" "int" 32 0 6651 NULL true 2 NULL
-6643 "as" "int" 32 0 6651 NULL true 3 NULL
-6644 "m5" "clob" 0 0 6651 NULL true 4 NULL
-6645 "sp" "clob" 0 0 6651 NULL true 5 NULL
-6646 "ur" "clob" 0 0 6651 NULL true 6 NULL
-6653 "id" "clob" 0 0 6670 NULL false 0 NULL
-6654 "file_id" "bigint" 64 0 6670 NULL false
1 NULL
-6655 "cn" "clob" 0 0 6670 NULL true 2 NULL
-6656 "ds" "clob" 0 0 6670 NULL true 3 NULL
-6657 "dt" "timestamp" 7 0 6670 NULL true 4
NULL
-6658 "fo" "clob" 0 0 6670 NULL true 5 NULL
-6659 "ks" "clob" 0 0 6670 NULL true 6 NULL
-6660 "lb" "clob" 0 0 6670 NULL true 7 NULL
-6661 "pg" "clob" 0 0 6670 NULL true 8 NULL
-6662 "pi" "int" 32 0 6670 NULL true 9 NULL
-6663 "pl" "clob" 0 0 6670 NULL true 10 NULL
-6664 "pu" "clob" 0 0 6670 NULL true 11 NULL
-6665 "sm" "clob" 0 0 6670 NULL true 12 NULL
-6672 "id" "clob" 0 0 6682 NULL false 0 NULL
-6673 "file_id" "bigint" 64 0 6682 NULL false
1 NULL
-6674 "pn" "clob" 0 0 6682 NULL true 2 NULL
-6675 "cl" "clob" 0 0 6682 NULL true 3 NULL
-6676 "pp" "clob" 0 0 6682 NULL true 4 NULL
-6677 "vn" "clob" 0 0 6682 NULL true 5 NULL
-6684 "qname" "clob" 0 0 6695 NULL false 0 NULL
-6685 "flag" "smallint" 16 0 6695 NULL false 1
NULL
-6686 "rname" "clob" 0 0 6695 NULL false 2 NULL
-6687 "pos" "int" 32 0 6695 NULL false 3 NULL
-6688 "mapq" "smallint" 16 0 6695 NULL false 4
NULL
-6689 "cigar" "clob" 0 0 6695 NULL false 5 NULL
-6690 "rnext" "clob" 0 0 6695 NULL false 6 NULL
-6691 "pnext" "int" 32 0 6695 NULL false 7 NULL
-6692 "tlen" "int" 32 0 6695 NULL false 8 NULL
-6693 "seq" "clob" 0 0 6695 NULL false 9 NULL
-6694 "qual" "clob" 0 0 6695 NULL false 10 NULL
-6765 "function_id" "int" 32 0 6766 NULL true 0
NULL
+6424 "file_id" "int" 32 0 6426 NULL true 0
NULL
+6425 "location" "char" 256 0 6426 NULL true 1
NULL
+6428 "dim_id" "int" 32 0 6432 NULL true 0
NULL
+6429 "file_id" "int" 32 0 6432 NULL true 1
NULL
+6430 "name" "varchar" 64 0 6432 NULL true 2
NULL
+6431 "length" "int" 32 0 6432 NULL true 3
NULL
+6434 "var_id" "int" 32 0 6440 NULL true 0
NULL
+6435 "file_id" "int" 32 0 6440 NULL true 1
NULL
+6436 "name" "varchar" 64 0 6440 NULL true 2
NULL
+6437 "vartype" "varchar" 64 0 6440 NULL true
3 NULL
+6438 "ndim" "int" 32 0 6440 NULL true 4 NULL
+6439 "coord_dim_id" "int" 32 0 6440 NULL true 5
NULL
+6442 "var_id" "int" 32 0 6446 NULL true 0
NULL
+6443 "dim_id" "int" 32 0 6446 NULL true 1
NULL
+6444 "file_id" "int" 32 0 6446 NULL true 2
NULL
+6445 "dimpos" "int" 32 0 6446 NULL true 3
NULL
+6448 "obj_name" "varchar" 256 0 6454 NULL true
0 NULL
+6449 "att_name" "varchar" 256 0 6454 NULL true
1 NULL
+6450 "att_type" "varchar" 64 0 6454 NULL true
2 NULL
+6451 "value" "clob" 0 0 6454 NULL true 3 NULL
+6452 "file_id" "int" 32 0 6454 NULL true 4
NULL
+6453 "gr_name" "varchar" 256 0 6454 NULL true
5 NULL
+6478 "schema" "clob" 0 0 6491 NULL true 0
NULL
+6479 "table" "clob" 0 0 6491 NULL true 1 NULL
+6480 "column" "clob" 0 0 6491 NULL true 2
NULL
+6481 "type" "clob" 0 0 6491 NULL true 3 NULL
+6482 "mode" "clob" 0 0 6491 NULL true 4 NULL
+6483 "location" "clob" 0 0 6491 NULL true 5
NULL
+6484 "count" "bigint" 64 0 6491 NULL true 6
NULL
+6485 "typewidth" "int" 32 0 6491 NULL true 7
NULL
+6486 "columnsize" "bigint" 64 0 6491 NULL true
8 NULL
+6487 "heapsize" "bigint" 64 0 6491 NULL true
9 NULL
+6488 "hashes" "bigint" 64 0 6491 NULL true
10 NULL
+6489 "imprints" "bigint" 64 0 6491 NULL true
11 NULL
+6490 "sorted" "boolean" 1 0 6491 NULL true
12 NULL
+6493 "schema" "clob" 0 0 6503 NULL true 0
NULL
+6494 "table" "clob" 0 0 6503 NULL true 1 NULL
+6495 "column" "clob" 0 0 6503 NULL true 2
NULL
+6496 "type" "clob" 0 0 6503 NULL true 3 NULL
+6497 "typewidth" "int" 32 0 6503 NULL true 4
NULL
+6498 "count" "bigint" 64 0 6503 NULL true 5
NULL
+6499 "distinct" "bigint" 64 0 6503 NULL true
6 NULL
+6500 "atomwidth" "int" 32 0 6503 NULL true 7
NULL
+6501 "reference" "boolean" 1 0 6503 NULL true
8 NULL
+6502 "sorted" "boolean" 1 0 6503 NULL true
9 NULL
+6541 "schema" "clob" 0 0 6551 NULL true 0
NULL
+6542 "table" "clob" 0 0 6551 NULL true 1 NULL
+6543 "column" "clob" 0 0 6551 NULL true 2
NULL
+6544 "type" "clob" 0 0 6551 NULL true 3 NULL
+6545 "count" "bigint" 64 0 6551 NULL true 4
NULL
+6546 "columnsize" "bigint" 64 0 6551 NULL true
5 NULL
+6547 "heapsize" "bigint" 64 0 6551 NULL true
6 NULL
+6548 "hashes" "bigint" 64 0 6551 NULL true
7 NULL
+6549 "imprints" "bigint" 64 0 6551 NULL true
8 NULL
+6550 "sorted" "boolean" 1 0 6551 NULL true
9 NULL
+6553 "schema" "clob" 0 0 6561 NULL true 0
NULL
+6554 "table" "clob" 0 0 6561 NULL true 1 NULL
+6555 "count" "bigint" 64 0 6561 NULL true 2
NULL
+6556 "columnsize" "bigint" 64 0 6561 NULL true
3 NULL
+6557 "heapsize" "bigint" 64 0 6561 NULL true
4 NULL
+6558 "hashes" "bigint" 64 0 6561 NULL true
5 NULL
+6559 "imprints" "bigint" 64 0 6561 NULL true
6 NULL
+6560 "auxiliary" "bigint" 64 0 6561 NULL true
7 NULL
+6563 "column_id" "int" 32 0 6574 NULL true 0
NULL
+6564 "type" "clob" 0 0 6574 NULL true 1 NULL
+6565 "width" "int" 32 0 6574 NULL true 2 NULL
+6566 "stamp" "timestamp" 7 0 6574 NULL true 3
NULL
+6567 "sample" "bigint" 64 0 6574 NULL true
4 NULL
+6568 "count" "bigint" 64 0 6574 NULL true 5
NULL
+6569 "unique" "bigint" 64 0 6574 NULL true
6 NULL
+6570 "nils" "bigint" 64 0 6574 NULL true 7
NULL
+6571 "minval" "clob" 0 0 6574 NULL true 8
NULL
+6572 "maxval" "clob" 0 0 6574 NULL true 9
NULL
+6573 "sorted" "boolean" 1 0 6574 NULL true
10 NULL
+6669 "file_id" "bigint" 64 0 6677 NULL false
0 NULL
+6670 "file_location" "clob" 0 0 6677 NULL false 1
NULL
+6671 "dbschema" "smallint" 16 0 6677 NULL false
2 NULL
+6672 "format_version" "varchar" 7 0 6677 NULL
true 3 NULL
+6673 "sorting_order" "varchar" 10 0 6677 NULL true
4 NULL
+6674 "comments" "clob" 0 0 6677 NULL true 5
NULL
+6679 "sn" "clob" 0 0 6690 NULL false 0 NULL
+6680 "file_id" "bigint" 64 0 6690 NULL false
1 NULL
+6681 "ln" "int" 32 0 6690 NULL true 2 NULL
+6682 "as" "int" 32 0 6690 NULL true 3 NULL
+6683 "m5" "clob" 0 0 6690 NULL true 4 NULL
+6684 "sp" "clob" 0 0 6690 NULL true 5 NULL
+6685 "ur" "clob" 0 0 6690 NULL true 6 NULL
+6692 "id" "clob" 0 0 6709 NULL false 0 NULL
+6693 "file_id" "bigint" 64 0 6709 NULL false
1 NULL
+6694 "cn" "clob" 0 0 6709 NULL true 2 NULL
+6695 "ds" "clob" 0 0 6709 NULL true 3 NULL
+6696 "dt" "timestamp" 7 0 6709 NULL true 4
NULL
+6697 "fo" "clob" 0 0 6709 NULL true 5 NULL
+6698 "ks" "clob" 0 0 6709 NULL true 6 NULL
+6699 "lb" "clob" 0 0 6709 NULL true 7 NULL
+6700 "pg" "clob" 0 0 6709 NULL true 8 NULL
+6701 "pi" "int" 32 0 6709 NULL true 9 NULL
+6702 "pl" "clob" 0 0 6709 NULL true 10 NULL
+6703 "pu" "clob" 0 0 6709 NULL true 11 NULL
+6704 "sm" "clob" 0 0 6709 NULL true 12 NULL
+6711 "id" "clob" 0 0 6721 NULL false 0 NULL
+6712 "file_id" "bigint" 64 0 6721 NULL false
1 NULL
+6713 "pn" "clob" 0 0 6721 NULL true 2 NULL
+6714 "cl" "clob" 0 0 6721 NULL true 3 NULL
+6715 "pp" "clob" 0 0 6721 NULL true 4 NULL
+6716 "vn" "clob" 0 0 6721 NULL true 5 NULL
+6723 "qname" "clob" 0 0 6734 NULL false 0 NULL
+6724 "flag" "smallint" 16 0 6734 NULL false 1
NULL
+6725 "rname" "clob" 0 0 6734 NULL false 2 NULL
+6726 "pos" "int" 32 0 6734 NULL false 3 NULL
+6727 "mapq" "smallint" 16 0 6734 NULL false 4
NULL
+6728 "cigar" "clob" 0 0 6734 NULL false 5 NULL
+6729 "rnext" "clob" 0 0 6734 NULL false 6 NULL
+6730 "pnext" "int" 32 0 6734 NULL false 7 NULL
+6731 "tlen" "int" 32 0 6734 NULL false 8 NULL
+6732 "seq" "clob" 0 0 6734 NULL false 9 NULL
+6733 "qual" "clob" 0 0 6734 NULL false 10 NULL
+6804 "function_id" "int" 32 0 6805 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1714,17 +1736,22 @@ 5655 "sessions" 2000 "create view sys.se
5735 "optimizers" 2000 "create view sys.optimizers as select * from
sys.optimizers();" 1 true 0 0
5743 "environment" 2000 "create view sys.environment as select * from
sys.environment();" 1 true 0 0
5781 "queue" 2000 "create view sys.queue as select * from sys.queue();"
1 true 0 0
-6452 "storage" 2000 "create view sys.""storage"" as select * from
sys.""storage""();" 1 true 0 0
-6464 "storagemodelinput" 2000 NULL 0 true 0 0
-6512 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 0
-6522 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary 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 auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 0
-6535 "statistics" 2000 NULL 0 true 0 0
-6638 "files" 6587 NULL 0 true 0 0
-6651 "sq" 6587 NULL 0 true 0 0
-6670 "rg" 6587 NULL 0 true 0 0
-6682 "pg" 6587 NULL 0 true 0 0
-6695 "export" 6587 NULL 0 true 0 0
-6766 "systemfunctions" 2000 NULL 0 true 0 0
+6426 "netcdf_files" 2000 NULL 0 true 0 0
+6432 "netcdf_dims" 2000 NULL 0 true 0 0
+6440 "netcdf_vars" 2000 NULL 0 true 0 0
+6446 "netcdf_vardim" 2000 NULL 0 true 0 0
+6454 "netcdf_attrs" 2000 NULL 0 true 0 0
+6491 "storage" 2000 "create view sys.""storage"" as select * from
sys.""storage""();" 1 true 0 0
+6503 "storagemodelinput" 2000 NULL 0 true 0 0
+6551 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 0
+6561 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary 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 auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 0
+6574 "statistics" 2000 NULL 0 true 0 0
+6677 "files" 6626 NULL 0 true 0 0
+6690 "sq" 6626 NULL 0 true 0 0
+6709 "rg" 6626 NULL 0 true 0 0
+6721 "pg" 6626 NULL 0 true 0 0
+6734 "export" 6626 NULL 0 true 0 0
+6805 "systemfunctions" 2000 NULL 0 true 0 0
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."args" (
@@ -1737,7 +1764,7 @@ CREATE TABLE "sys"."args" (
"inout" TINYINT,
"number" INTEGER
);
-COPY 3773 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3776 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
2155 28 "res_0" "oid" 63 0 0 0
2156 28 "arg_1" "wrd" 64 0 1 1
2157 29 "res_0" "oid" 63 0 0 0
@@ -5382,135 +5409,138 @@ 6415 6414 "fname" "clob" 0 0 1 0
6418 6417 "tname" "clob" 0 0 1 0
6421 6420 "dirname" "clob" 0 0 1 0
6422 6420 "pat" "clob" 0 0 1 1
-6425 6424 "schema" "clob" 0 0 0 0
-6426 6424 "table" "clob" 0 0 0 1
-6427 6424 "column" "clob" 0 0 0 2
-6428 6424 "type" "clob" 0 0 0 3
-6429 6424 "mode" "clob" 0 0 0 4
-6430 6424 "location" "clob" 0 0 0 5
-6431 6424 "count" "bigint" 64 0 0 6
-6432 6424 "typewidth" "int" 32 0 0 7
-6433 6424 "columnsize" "bigint" 64 0 0 8
-6434 6424 "heapsize" "bigint" 64 0 0 9
-6435 6424 "hashes" "bigint" 64 0 0 10
-6436 6424 "imprints" "bigint" 64 0 0 11
-6437 6424 "sorted" "boolean" 1 0 0 12
-6469 6468 "result" "bigint" 64 0 0 0
-6470 6468 "nme" "clob" 0 0 1 1
-6471 6468 "i" "bigint" 64 0 1 2
-6472 6468 "d" "bigint" 64 0 1 3
-6475 6474 "result" "bigint" 64 0 0 0
-6476 6474 "tpe" "clob" 0 0 1 1
-6477 6474 "i" "bigint" 64 0 1 2
-6478 6474 "w" "int" 32 0 1 3
-6481 6480 "result" "bigint" 64 0 0 0
-6482 6480 "b" "boolean" 1 0 1 1
-6483 6480 "i" "bigint" 64 0 1 2
-6486 6485 "result" "bigint" 64 0 0 0
-6487 6485 "i" "bigint" 64 0 1 1
-6488 6485 "nme" "clob" 0 0 1 2
-6491 6490 "schema" "clob" 0 0 0 0
-6492 6490 "table" "clob" 0 0 0 1
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
