Changeset: 1728b95b6c3e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1728b95b6c3e Added Files: sql/test/pg_regress/Tests/oid.stable.err.int128 Modified Files: clients/Tests/SQL-dump.stable.out monetdb5/mal/Tests/tst1225.stable.out monetdb5/modules/mal/Tests/inspect05.stable.out monetdb5/modules/mal/Tests/remote03.stable.out sql/benchmarks/nobench/Tests/nobench.stable.err sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/07-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out sql/benchmarks/tpch/Tests/18-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out 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/pg_regress/Tests/int8.stable.err sql/test/pg_regress/Tests/oid.stable.err Branch: default Log Message:
Approvals for non 128 bit systems. diffs (truncated from 7287 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 @@ -1651,142 +1651,142 @@ 5748 "def" "clob" 0 0 5750 NULL true 1 N 5749 "status" "clob" 0 0 5750 NULL true 2 NULL 5756 "name" "clob" 0 0 5758 NULL true 0 NULL 5757 "value" "clob" 0 0 5758 NULL true 1 NULL -5794 "qtag" "bigint" 64 0 5802 NULL true 0 NULL -5795 "user" "clob" 0 0 5802 NULL true 1 NULL -5796 "started" "timestamp" 7 0 5802 NULL true 2 NULL -5797 "estimate" "timestamp" 7 0 5802 NULL true 3 NULL -5798 "progress" "int" 32 0 5802 NULL true 4 NULL -5799 "status" "clob" 0 0 5802 NULL true 5 NULL -5800 "tag" "oid" 63 0 5802 NULL true 6 NULL -5801 "query" "clob" 0 0 5802 NULL true 7 NULL -5828 "rowid" "bigint" 64 0 5832 NULL true 0 NULL -5829 "fldid" "int" 32 0 5832 NULL true 1 NULL -5830 "message" "clob" 0 0 5832 NULL true 2 NULL -5831 "input" "clob" 0 0 5832 NULL true 3 NULL -6467 "keyword" "varchar" 40 0 6470 NULL false 0 NULL -6472 "table_type_id" "smallint" 16 0 6478 NULL false 0 NULL -6475 "table_type_name" "varchar" 25 0 6478 NULL false 1 NULL -6480 "dependency_type_id" "smallint" 16 0 6486 NULL false 0 NULL -6483 "dependency_type_name" "varchar" 15 0 6486 NULL false 1 NULL -6501 "file_id" "int" 32 0 6503 NULL true 0 NULL -6502 "location" "char" 256 0 6503 NULL true 1 NULL -6505 "dim_id" "int" 32 0 6509 NULL true 0 NULL -6506 "file_id" "int" 32 0 6509 NULL true 1 NULL -6507 "name" "varchar" 64 0 6509 NULL true 2 NULL -6508 "length" "int" 32 0 6509 NULL true 3 NULL -6511 "var_id" "int" 32 0 6517 NULL true 0 NULL -6512 "file_id" "int" 32 0 6517 NULL true 1 NULL -6513 "name" "varchar" 64 0 6517 NULL true 2 NULL -6514 "vartype" "varchar" 64 0 6517 NULL true 3 NULL -6515 "ndim" "int" 32 0 6517 NULL true 4 NULL -6516 "coord_dim_id" "int" 32 0 6517 NULL true 5 NULL -6519 "var_id" "int" 32 0 6523 NULL true 0 NULL -6520 "dim_id" "int" 32 0 6523 NULL true 1 NULL -6521 "file_id" "int" 32 0 6523 NULL true 2 NULL -6522 "dimpos" "int" 32 0 6523 NULL true 3 NULL -6525 "obj_name" "varchar" 256 0 6531 NULL true 0 NULL -6526 "att_name" "varchar" 256 0 6531 NULL true 1 NULL -6527 "att_type" "varchar" 64 0 6531 NULL true 2 NULL -6528 "value" "clob" 0 0 6531 NULL true 3 NULL -6529 "file_id" "int" 32 0 6531 NULL true 4 NULL -6530 "gr_name" "varchar" 256 0 6531 NULL true 5 NULL -6556 "schema" "clob" 0 0 6570 NULL true 0 NULL -6557 "table" "clob" 0 0 6570 NULL true 1 NULL -6558 "column" "clob" 0 0 6570 NULL true 2 NULL -6559 "type" "clob" 0 0 6570 NULL true 3 NULL -6560 "mode" "clob" 0 0 6570 NULL true 4 NULL -6561 "location" "clob" 0 0 6570 NULL true 5 NULL -6562 "count" "bigint" 64 0 6570 NULL true 6 NULL -6563 "typewidth" "int" 32 0 6570 NULL true 7 NULL -6564 "columnsize" "bigint" 64 0 6570 NULL true 8 NULL -6565 "heapsize" "bigint" 64 0 6570 NULL true 9 NULL -6566 "hashes" "bigint" 64 0 6570 NULL true 10 NULL -6567 "phash" "boolean" 1 0 6570 NULL true 11 NULL -6568 "imprints" "bigint" 64 0 6570 NULL true 12 NULL -6569 "sorted" "boolean" 1 0 6570 NULL true 13 NULL -6572 "schema" "clob" 0 0 6582 NULL true 0 NULL -6573 "table" "clob" 0 0 6582 NULL true 1 NULL -6574 "column" "clob" 0 0 6582 NULL true 2 NULL -6575 "type" "clob" 0 0 6582 NULL true 3 NULL -6576 "typewidth" "int" 32 0 6582 NULL true 4 NULL -6577 "count" "bigint" 64 0 6582 NULL true 5 NULL -6578 "distinct" "bigint" 64 0 6582 NULL true 6 NULL -6579 "atomwidth" "int" 32 0 6582 NULL true 7 NULL -6580 "reference" "boolean" 1 0 6582 NULL true 8 NULL -6581 "sorted" "boolean" 1 0 6582 NULL true 9 NULL -6620 "schema" "clob" 0 0 6630 NULL true 0 NULL -6621 "table" "clob" 0 0 6630 NULL true 1 NULL -6622 "column" "clob" 0 0 6630 NULL true 2 NULL -6623 "type" "clob" 0 0 6630 NULL true 3 NULL -6624 "count" "bigint" 64 0 6630 NULL true 4 NULL -6625 "columnsize" "bigint" 64 0 6630 NULL true 5 NULL -6626 "heapsize" "bigint" 64 0 6630 NULL true 6 NULL -6627 "hashes" "bigint" 64 0 6630 NULL true 7 NULL -6628 "imprints" "bigint" 64 0 6630 NULL true 8 NULL -6629 "sorted" "boolean" 1 0 6630 NULL true 9 NULL -6632 "schema" "clob" 0 0 6640 NULL true 0 NULL -6633 "table" "clob" 0 0 6640 NULL true 1 NULL -6634 "count" "bigint" 64 0 6640 NULL true 2 NULL -6635 "columnsize" "bigint" 64 0 6640 NULL true 3 NULL -6636 "heapsize" "bigint" 64 0 6640 NULL true 4 NULL -6637 "hashes" "bigint" 64 0 6640 NULL true 5 NULL -6638 "imprints" "bigint" 64 0 6640 NULL true 6 NULL -6639 "auxiliary" "bigint" 64 0 6640 NULL true 7 NULL -6642 "column_id" "int" 32 0 6653 NULL true 0 NULL -6643 "type" "clob" 0 0 6653 NULL true 1 NULL -6644 "width" "int" 32 0 6653 NULL true 2 NULL -6645 "stamp" "timestamp" 7 0 6653 NULL true 3 NULL -6646 "sample" "bigint" 64 0 6653 NULL true 4 NULL -6647 "count" "bigint" 64 0 6653 NULL true 5 NULL -6648 "unique" "bigint" 64 0 6653 NULL true 6 NULL -6649 "nils" "bigint" 64 0 6653 NULL true 7 NULL -6650 "minval" "clob" 0 0 6653 NULL true 8 NULL -6651 "maxval" "clob" 0 0 6653 NULL true 9 NULL -6652 "sorted" "boolean" 1 0 6653 NULL true 10 NULL -6743 "file_id" "bigint" 64 0 6751 NULL false 0 NULL -6744 "file_location" "clob" 0 0 6751 NULL false 1 NULL -6745 "dbschema" "smallint" 16 0 6751 NULL false 2 NULL -6746 "format_version" "varchar" 7 0 6751 NULL true 3 NULL -6747 "sorting_order" "varchar" 10 0 6751 NULL true 4 NULL -6748 "comments" "clob" 0 0 6751 NULL true 5 NULL -6753 "sn" "clob" 0 0 6764 NULL false 0 NULL -6754 "file_id" "bigint" 64 0 6764 NULL false 1 NULL -6755 "ln" "int" 32 0 6764 NULL true 2 NULL -6756 "as" "int" 32 0 6764 NULL true 3 NULL -6757 "m5" "clob" 0 0 6764 NULL true 4 NULL -6758 "sp" "clob" 0 0 6764 NULL true 5 NULL -6759 "ur" "clob" 0 0 6764 NULL true 6 NULL -6766 "id" "clob" 0 0 6783 NULL false 0 NULL -6767 "file_id" "bigint" 64 0 6783 NULL false 1 NULL -6768 "cn" "clob" 0 0 6783 NULL true 2 NULL -6769 "ds" "clob" 0 0 6783 NULL true 3 NULL -6770 "dt" "timestamp" 7 0 6783 NULL true 4 NULL -6771 "fo" "clob" 0 0 6783 NULL true 5 NULL -6772 "ks" "clob" 0 0 6783 NULL true 6 NULL -6773 "lb" "clob" 0 0 6783 NULL true 7 NULL -6774 "pg" "clob" 0 0 6783 NULL true 8 NULL -6775 "pi" "int" 32 0 6783 NULL true 9 NULL -6776 "pl" "clob" 0 0 6783 NULL true 10 NULL -6777 "pu" "clob" 0 0 6783 NULL true 11 NULL -6778 "sm" "clob" 0 0 6783 NULL true 12 NULL -6785 "id" "clob" 0 0 6795 NULL false 0 NULL -6786 "file_id" "bigint" 64 0 6795 NULL false 1 NULL -6787 "pn" "clob" 0 0 6795 NULL true 2 NULL -6788 "cl" "clob" 0 0 6795 NULL true 3 NULL -6789 "pp" "clob" 0 0 6795 NULL true 4 NULL -6790 "vn" "clob" 0 0 6795 NULL true 5 NULL -6797 "qname" "clob" 0 0 6808 NULL false 0 NULL -6798 "flag" "smallint" 16 0 6808 NULL false 1 NULL -6799 "rname" "clob" 0 0 6808 NULL false 2 NULL -6800 "pos" "int" 32 0 6808 NULL false 3 NULL -6801 "mapq" "smallint" 16 0 6808 NULL false 4 NULL -6802 "cigar" "clob" 0 0 6808 NULL false 5 NULL -6803 "rnext" "clob" 0 0 6808 NULL false 6 NULL -6804 "pnext" "int" 32 0 6808 NULL false 7 NULL -6805 "tlen" "int" 32 0 6808 NULL false 8 NULL -6806 "seq" "clob" 0 0 6808 NULL false 9 NULL -6807 "qual" "clob" 0 0 6808 NULL false 10 NULL -6878 "function_id" "int" 32 0 6879 NULL true 0 NULL +5798 "qtag" "bigint" 64 0 5806 NULL true 0 NULL +5799 "user" "clob" 0 0 5806 NULL true 1 NULL +5800 "started" "timestamp" 7 0 5806 NULL true 2 NULL +5801 "estimate" "timestamp" 7 0 5806 NULL true 3 NULL +5802 "progress" "int" 32 0 5806 NULL true 4 NULL +5803 "status" "clob" 0 0 5806 NULL true 5 NULL +5804 "tag" "oid" 63 0 5806 NULL true 6 NULL +5805 "query" "clob" 0 0 5806 NULL true 7 NULL +5832 "rowid" "bigint" 64 0 5836 NULL true 0 NULL +5833 "fldid" "int" 32 0 5836 NULL true 1 NULL +5834 "message" "clob" 0 0 5836 NULL true 2 NULL +5835 "input" "clob" 0 0 5836 NULL true 3 NULL +6471 "keyword" "varchar" 40 0 6474 NULL false 0 NULL +6476 "table_type_id" "smallint" 16 0 6482 NULL false 0 NULL +6479 "table_type_name" "varchar" 25 0 6482 NULL false 1 NULL +6484 "dependency_type_id" "smallint" 16 0 6490 NULL false 0 NULL +6487 "dependency_type_name" "varchar" 15 0 6490 NULL false 1 NULL +6505 "file_id" "int" 32 0 6507 NULL true 0 NULL +6506 "location" "char" 256 0 6507 NULL true 1 NULL +6509 "dim_id" "int" 32 0 6513 NULL true 0 NULL +6510 "file_id" "int" 32 0 6513 NULL true 1 NULL +6511 "name" "varchar" 64 0 6513 NULL true 2 NULL +6512 "length" "int" 32 0 6513 NULL true 3 NULL +6515 "var_id" "int" 32 0 6521 NULL true 0 NULL +6516 "file_id" "int" 32 0 6521 NULL true 1 NULL +6517 "name" "varchar" 64 0 6521 NULL true 2 NULL +6518 "vartype" "varchar" 64 0 6521 NULL true 3 NULL +6519 "ndim" "int" 32 0 6521 NULL true 4 NULL +6520 "coord_dim_id" "int" 32 0 6521 NULL true 5 NULL +6523 "var_id" "int" 32 0 6527 NULL true 0 NULL +6524 "dim_id" "int" 32 0 6527 NULL true 1 NULL +6525 "file_id" "int" 32 0 6527 NULL true 2 NULL +6526 "dimpos" "int" 32 0 6527 NULL true 3 NULL +6529 "obj_name" "varchar" 256 0 6535 NULL true 0 NULL +6530 "att_name" "varchar" 256 0 6535 NULL true 1 NULL +6531 "att_type" "varchar" 64 0 6535 NULL true 2 NULL +6532 "value" "clob" 0 0 6535 NULL true 3 NULL +6533 "file_id" "int" 32 0 6535 NULL true 4 NULL +6534 "gr_name" "varchar" 256 0 6535 NULL true 5 NULL +6560 "schema" "clob" 0 0 6574 NULL true 0 NULL +6561 "table" "clob" 0 0 6574 NULL true 1 NULL +6562 "column" "clob" 0 0 6574 NULL true 2 NULL +6563 "type" "clob" 0 0 6574 NULL true 3 NULL +6564 "mode" "clob" 0 0 6574 NULL true 4 NULL +6565 "location" "clob" 0 0 6574 NULL true 5 NULL +6566 "count" "bigint" 64 0 6574 NULL true 6 NULL +6567 "typewidth" "int" 32 0 6574 NULL true 7 NULL +6568 "columnsize" "bigint" 64 0 6574 NULL true 8 NULL +6569 "heapsize" "bigint" 64 0 6574 NULL true 9 NULL +6570 "hashes" "bigint" 64 0 6574 NULL true 10 NULL +6571 "phash" "boolean" 1 0 6574 NULL true 11 NULL +6572 "imprints" "bigint" 64 0 6574 NULL true 12 NULL +6573 "sorted" "boolean" 1 0 6574 NULL true 13 NULL +6576 "schema" "clob" 0 0 6586 NULL true 0 NULL +6577 "table" "clob" 0 0 6586 NULL true 1 NULL +6578 "column" "clob" 0 0 6586 NULL true 2 NULL +6579 "type" "clob" 0 0 6586 NULL true 3 NULL +6580 "typewidth" "int" 32 0 6586 NULL true 4 NULL +6581 "count" "bigint" 64 0 6586 NULL true 5 NULL +6582 "distinct" "bigint" 64 0 6586 NULL true 6 NULL +6583 "atomwidth" "int" 32 0 6586 NULL true 7 NULL +6584 "reference" "boolean" 1 0 6586 NULL true 8 NULL +6585 "sorted" "boolean" 1 0 6586 NULL true 9 NULL +6624 "schema" "clob" 0 0 6634 NULL true 0 NULL +6625 "table" "clob" 0 0 6634 NULL true 1 NULL +6626 "column" "clob" 0 0 6634 NULL true 2 NULL +6627 "type" "clob" 0 0 6634 NULL true 3 NULL +6628 "count" "bigint" 64 0 6634 NULL true 4 NULL +6629 "columnsize" "bigint" 64 0 6634 NULL true 5 NULL +6630 "heapsize" "bigint" 64 0 6634 NULL true 6 NULL +6631 "hashes" "bigint" 64 0 6634 NULL true 7 NULL +6632 "imprints" "bigint" 64 0 6634 NULL true 8 NULL +6633 "sorted" "boolean" 1 0 6634 NULL true 9 NULL +6636 "schema" "clob" 0 0 6644 NULL true 0 NULL +6637 "table" "clob" 0 0 6644 NULL true 1 NULL +6638 "count" "bigint" 64 0 6644 NULL true 2 NULL +6639 "columnsize" "bigint" 64 0 6644 NULL true 3 NULL +6640 "heapsize" "bigint" 64 0 6644 NULL true 4 NULL +6641 "hashes" "bigint" 64 0 6644 NULL true 5 NULL +6642 "imprints" "bigint" 64 0 6644 NULL true 6 NULL +6643 "auxiliary" "bigint" 64 0 6644 NULL true 7 NULL +6646 "column_id" "int" 32 0 6657 NULL true 0 NULL +6647 "type" "clob" 0 0 6657 NULL true 1 NULL +6648 "width" "int" 32 0 6657 NULL true 2 NULL +6649 "stamp" "timestamp" 7 0 6657 NULL true 3 NULL +6650 "sample" "bigint" 64 0 6657 NULL true 4 NULL +6651 "count" "bigint" 64 0 6657 NULL true 5 NULL +6652 "unique" "bigint" 64 0 6657 NULL true 6 NULL +6653 "nils" "bigint" 64 0 6657 NULL true 7 NULL +6654 "minval" "clob" 0 0 6657 NULL true 8 NULL +6655 "maxval" "clob" 0 0 6657 NULL true 9 NULL +6656 "sorted" "boolean" 1 0 6657 NULL true 10 NULL +6747 "file_id" "bigint" 64 0 6755 NULL false 0 NULL +6748 "file_location" "clob" 0 0 6755 NULL false 1 NULL +6749 "dbschema" "smallint" 16 0 6755 NULL false 2 NULL +6750 "format_version" "varchar" 7 0 6755 NULL true 3 NULL +6751 "sorting_order" "varchar" 10 0 6755 NULL true 4 NULL +6752 "comments" "clob" 0 0 6755 NULL true 5 NULL +6757 "sn" "clob" 0 0 6768 NULL false 0 NULL +6758 "file_id" "bigint" 64 0 6768 NULL false 1 NULL +6759 "ln" "int" 32 0 6768 NULL true 2 NULL +6760 "as" "int" 32 0 6768 NULL true 3 NULL +6761 "m5" "clob" 0 0 6768 NULL true 4 NULL +6762 "sp" "clob" 0 0 6768 NULL true 5 NULL +6763 "ur" "clob" 0 0 6768 NULL true 6 NULL +6770 "id" "clob" 0 0 6787 NULL false 0 NULL +6771 "file_id" "bigint" 64 0 6787 NULL false 1 NULL +6772 "cn" "clob" 0 0 6787 NULL true 2 NULL +6773 "ds" "clob" 0 0 6787 NULL true 3 NULL +6774 "dt" "timestamp" 7 0 6787 NULL true 4 NULL +6775 "fo" "clob" 0 0 6787 NULL true 5 NULL +6776 "ks" "clob" 0 0 6787 NULL true 6 NULL +6777 "lb" "clob" 0 0 6787 NULL true 7 NULL +6778 "pg" "clob" 0 0 6787 NULL true 8 NULL +6779 "pi" "int" 32 0 6787 NULL true 9 NULL +6780 "pl" "clob" 0 0 6787 NULL true 10 NULL +6781 "pu" "clob" 0 0 6787 NULL true 11 NULL +6782 "sm" "clob" 0 0 6787 NULL true 12 NULL +6789 "id" "clob" 0 0 6799 NULL false 0 NULL +6790 "file_id" "bigint" 64 0 6799 NULL false 1 NULL +6791 "pn" "clob" 0 0 6799 NULL true 2 NULL +6792 "cl" "clob" 0 0 6799 NULL true 3 NULL +6793 "pp" "clob" 0 0 6799 NULL true 4 NULL +6794 "vn" "clob" 0 0 6799 NULL true 5 NULL +6801 "qname" "clob" 0 0 6812 NULL false 0 NULL +6802 "flag" "smallint" 16 0 6812 NULL false 1 NULL +6803 "rname" "clob" 0 0 6812 NULL false 2 NULL +6804 "pos" "int" 32 0 6812 NULL false 3 NULL +6805 "mapq" "smallint" 16 0 6812 NULL false 4 NULL +6806 "cigar" "clob" 0 0 6812 NULL false 5 NULL +6807 "rnext" "clob" 0 0 6812 NULL false 6 NULL +6808 "pnext" "int" 32 0 6812 NULL false 7 NULL +6809 "tlen" "int" 32 0 6812 NULL false 8 NULL +6810 "seq" "clob" 0 0 6812 NULL false 9 NULL +6811 "qual" "clob" 0 0 6812 NULL false 10 NULL +6882 "function_id" "int" 32 0 6883 NULL true 0 NULL COMMIT; START TRANSACTION; CREATE TABLE "sys"."_tables" ( @@ -1833,27 +1833,27 @@ 5537 "tracelog" 2000 "create view sys.tr 5670 "sessions" 2000 "create view sys.sessions as select * from sys.sessions();" 1 true 0 0 5750 "optimizers" 2000 "create view sys.optimizers as select * from sys.optimizers();" 1 true 0 0 5758 "environment" 2000 "create view sys.environment as select * from sys.environment();" 1 true 0 0 -5802 "queue" 2000 "create view sys.queue as select * from sys.queue();" 1 true 0 0 -5832 "rejects" 2000 "create view sys.rejects as select * from sys.rejects();" 1 true 0 0 -6470 "keywords" 2000 NULL 0 true 0 0 -6478 "table_types" 2000 NULL 0 true 0 0 -6486 "dependency_types" 2000 NULL 0 true 0 0 -6503 "netcdf_files" 2000 NULL 0 true 0 0 -6509 "netcdf_dims" 2000 NULL 0 true 0 0 -6517 "netcdf_vars" 2000 NULL 0 true 0 0 -6523 "netcdf_vardim" 2000 NULL 0 true 0 0 -6531 "netcdf_attrs" 2000 NULL 0 true 0 0 -6570 "storage" 2000 "create view sys.""storage"" as select * from sys.""storage""();" 1 true 0 0 -6582 "storagemodelinput" 2000 NULL 0 true 0 0 -6630 "storagemodel" 2000 "create view sys.storagemodel as select * from sys.storagemodel();" 1 true 0 0 -6640 "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 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
