Changeset: 8e30e90a8980 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8e30e90a8980
Modified Files:
clients/Tests/SQL-dump.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/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
Branch: default
Log Message:
non-128-bit approvals.
diffs (truncated from 1380 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
@@ -1500,89 +1500,89 @@ 6570 "hashes" "bigint" 64 0
6574 NULL tr
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
+6630 "schema" "clob" 0 0 6640 NULL true 0
NULL
+6631 "table" "clob" 0 0 6640 NULL true 1 NULL
+6632 "column" "clob" 0 0 6640 NULL true 2
NULL
+6633 "type" "clob" 0 0 6640 NULL true 3 NULL
+6634 "typewidth" "int" 32 0 6640 NULL true 4
NULL
+6635 "count" "bigint" 64 0 6640 NULL true 5
NULL
+6636 "distinct" "bigint" 64 0 6640 NULL true
6 NULL
+6637 "atomwidth" "int" 32 0 6640 NULL true 7
NULL
+6638 "reference" "boolean" 1 0 6640 NULL true
8 NULL
+6639 "sorted" "boolean" 1 0 6640 NULL true
9 NULL
+6678 "schema" "clob" 0 0 6688 NULL true 0
NULL
+6679 "table" "clob" 0 0 6688 NULL true 1 NULL
+6680 "column" "clob" 0 0 6688 NULL true 2
NULL
+6681 "type" "clob" 0 0 6688 NULL true 3 NULL
+6682 "count" "bigint" 64 0 6688 NULL true 4
NULL
+6683 "columnsize" "bigint" 64 0 6688 NULL true
5 NULL
+6684 "heapsize" "bigint" 64 0 6688 NULL true
6 NULL
+6685 "hashes" "bigint" 64 0 6688 NULL true
7 NULL
+6686 "imprints" "bigint" 64 0 6688 NULL true
8 NULL
+6687 "sorted" "boolean" 1 0 6688 NULL true
9 NULL
+6690 "schema" "clob" 0 0 6698 NULL true 0
NULL
+6691 "table" "clob" 0 0 6698 NULL true 1 NULL
+6692 "count" "bigint" 64 0 6698 NULL true 2
NULL
+6693 "columnsize" "bigint" 64 0 6698 NULL true
3 NULL
+6694 "heapsize" "bigint" 64 0 6698 NULL true
4 NULL
+6695 "hashes" "bigint" 64 0 6698 NULL true
5 NULL
+6696 "imprints" "bigint" 64 0 6698 NULL true
6 NULL
+6697 "auxiliary" "bigint" 64 0 6698 NULL true
7 NULL
+6700 "column_id" "int" 32 0 6711 NULL true 0
NULL
+6701 "type" "clob" 0 0 6711 NULL true 1 NULL
+6702 "width" "int" 32 0 6711 NULL true 2 NULL
+6703 "stamp" "timestamp" 7 0 6711 NULL true 3
NULL
+6704 "sample" "bigint" 64 0 6711 NULL true
4 NULL
+6705 "count" "bigint" 64 0 6711 NULL true 5
NULL
+6706 "unique" "bigint" 64 0 6711 NULL true
6 NULL
+6707 "nils" "bigint" 64 0 6711 NULL true 7
NULL
+6708 "minval" "clob" 0 0 6711 NULL true 8
NULL
+6709 "maxval" "clob" 0 0 6711 NULL true 9
NULL
+6710 "sorted" "boolean" 1 0 6711 NULL true
10 NULL
+6801 "file_id" "bigint" 64 0 6809 NULL false
0 NULL
+6802 "file_location" "clob" 0 0 6809 NULL false 1
NULL
+6803 "dbschema" "smallint" 16 0 6809 NULL false
2 NULL
+6804 "format_version" "varchar" 7 0 6809 NULL
true 3 NULL
+6805 "sorting_order" "varchar" 10 0 6809 NULL true
4 NULL
+6806 "comments" "clob" 0 0 6809 NULL true 5
NULL
+6811 "sn" "clob" 0 0 6822 NULL false 0 NULL
+6812 "file_id" "bigint" 64 0 6822 NULL false
1 NULL
+6813 "ln" "int" 32 0 6822 NULL true 2 NULL
+6814 "as" "int" 32 0 6822 NULL true 3 NULL
+6815 "m5" "clob" 0 0 6822 NULL true 4 NULL
+6816 "sp" "clob" 0 0 6822 NULL true 5 NULL
+6817 "ur" "clob" 0 0 6822 NULL true 6 NULL
+6824 "id" "clob" 0 0 6841 NULL false 0 NULL
+6825 "file_id" "bigint" 64 0 6841 NULL false
1 NULL
+6826 "cn" "clob" 0 0 6841 NULL true 2 NULL
+6827 "ds" "clob" 0 0 6841 NULL true 3 NULL
+6828 "dt" "timestamp" 7 0 6841 NULL true 4
NULL
+6829 "fo" "clob" 0 0 6841 NULL true 5 NULL
+6830 "ks" "clob" 0 0 6841 NULL true 6 NULL
+6831 "lb" "clob" 0 0 6841 NULL true 7 NULL
+6832 "pg" "clob" 0 0 6841 NULL true 8 NULL
+6833 "pi" "int" 32 0 6841 NULL true 9 NULL
+6834 "pl" "clob" 0 0 6841 NULL true 10 NULL
+6835 "pu" "clob" 0 0 6841 NULL true 11 NULL
+6836 "sm" "clob" 0 0 6841 NULL true 12 NULL
+6843 "id" "clob" 0 0 6853 NULL false 0 NULL
+6844 "file_id" "bigint" 64 0 6853 NULL false
1 NULL
+6845 "pn" "clob" 0 0 6853 NULL true 2 NULL
+6846 "cl" "clob" 0 0 6853 NULL true 3 NULL
+6847 "pp" "clob" 0 0 6853 NULL true 4 NULL
+6848 "vn" "clob" 0 0 6853 NULL true 5 NULL
+6855 "qname" "clob" 0 0 6866 NULL false 0 NULL
+6856 "flag" "smallint" 16 0 6866 NULL false 1
NULL
+6857 "rname" "clob" 0 0 6866 NULL false 2 NULL
+6858 "pos" "int" 32 0 6866 NULL false 3 NULL
+6859 "mapq" "smallint" 16 0 6866 NULL false 4
NULL
+6860 "cigar" "clob" 0 0 6866 NULL false 5 NULL
+6861 "rnext" "clob" 0 0 6866 NULL false 6 NULL
+6862 "pnext" "int" 32 0 6866 NULL false 7 NULL
+6863 "tlen" "int" 32 0 6866 NULL false 8 NULL
+6864 "seq" "clob" 0 0 6866 NULL false 9 NULL
+6865 "qual" "clob" 0 0 6866 NULL false 10 NULL
+6936 "function_id" "int" 32 0 6937 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1640,16 +1640,16 @@ 6521 "netcdf_vars" 2000 NULL 0 true
0 0
6527 "netcdf_vardim" 2000 NULL 0 true 0 0
6535 "netcdf_attrs" 2000 NULL 0 true 0 0
6574 "storage" 2000 "create view sys.""storage"" as select * from
sys.""storage""();" 1 true 0 0
-6586 "storagemodelinput" 2000 NULL 0 true 0 0
-6634 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 0
-6644 "tablestoragemodel" 2000 "create view sys.tablestoragemodel\nas
select ""schema"",""table"",max(count) as ""count"",\n sum(columnsize) as
columnsize,\n sum(heapsize) as heapsize,\n sum(hashes) as hashes,\n
sum(imprints) as imprints,\n sum(case when sorted = false then 8 * count else 0
end) as auxiliary\nfrom sys.storagemodel() group by ""schema"",""table"";" 1
true 0 0
-6657 "statistics" 2000 NULL 0 true 0 0
-6755 "files" 6699 NULL 0 true 0 0
-6768 "sq" 6699 NULL 0 true 0 0
-6787 "rg" 6699 NULL 0 true 0 0
-6799 "pg" 6699 NULL 0 true 0 0
-6812 "export" 6699 NULL 0 true 0 0
-6883 "systemfunctions" 2000 NULL 0 true 0 0
+6640 "storagemodelinput" 2000 NULL 0 true 0 0
+6688 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 0
+6698 "tablestoragemodel" 2000 "create view sys.tablestoragemodel\nas
select ""schema"",""table"",max(count) as ""count"",\n sum(columnsize) as
columnsize,\n sum(heapsize) as heapsize,\n sum(hashes) as hashes,\n
sum(imprints) as imprints,\n sum(case when sorted = false then 8 * count else 0
end) as auxiliary\nfrom sys.storagemodel() group by ""schema"",""table"";" 1
true 0 0
+6711 "statistics" 2000 NULL 0 true 0 0
+6809 "files" 6753 NULL 0 true 0 0
+6822 "sq" 6753 NULL 0 true 0 0
+6841 "rg" 6753 NULL 0 true 0 0
+6853 "pg" 6753 NULL 0 true 0 0
+6866 "export" 6753 NULL 0 true 0 0
+6937 "systemfunctions" 2000 NULL 0 true 0 0
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."args" (
@@ -1662,7 +1662,7 @@ CREATE TABLE "sys"."args" (
"inout" TINYINT,
"number" INTEGER
);
-COPY 3805 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3853 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
@@ -5351,123 +5351,171 @@ 6555 6544 "hashes" "bigint" 64
0 0 10
6556 6544 "phash" "boolean" 1 0 0 11
6557 6544 "imprints" "bigint" 64 0 0 12
6558 6544 "sorted" "boolean" 1 0 0 13
-6591 6590 "result" "bigint" 64 0 0 0
-6592 6590 "nme" "clob" 0 0 1 1
-6593 6590 "i" "bigint" 64 0 1 2
-6594 6590 "d" "bigint" 64 0 1 3
-6597 6596 "result" "bigint" 64 0 0 0
-6598 6596 "tpe" "clob" 0 0 1 1
-6599 6596 "i" "bigint" 64 0 1 2
-6600 6596 "w" "int" 32 0 1 3
-6603 6602 "result" "bigint" 64 0 0 0
-6604 6602 "b" "boolean" 1 0 1 1
-6605 6602 "i" "bigint" 64 0 1 2
-6608 6607 "result" "bigint" 64 0 0 0
-6609 6607 "i" "bigint" 64 0 1 1
-6610 6607 "nme" "clob" 0 0 1 2
-6613 6612 "schema" "clob" 0 0 0 0
-6614 6612 "table" "clob" 0 0 0 1
-6615 6612 "column" "clob" 0 0 0 2
-6616 6612 "type" "clob" 0 0 0 3
-6617 6612 "count" "bigint" 64 0 0 4
-6618 6612 "columnsize" "bigint" 64 0 0 5
-6619 6612 "heapsize" "bigint" 64 0 0 6
-6620 6612 "hashes" "bigint" 64 0 0 7
-6621 6612 "imprints" "bigint" 64 0 0 8
-6622 6612 "sorted" "boolean" 1 0 0 9
-6660 6659 "MinMax" "int" 32 0 1 0
-6661 6659 "sample" "bigint" 64 0 1 1
-6664 6663 "MinMax" "int" 32 0 1 0
-6665 6663 "sample" "bigint" 64 0 1 1
-6666 6663 "sch" "clob" 0 0 1 2
-6669 6668 "MinMax" "int" 32 0 1 0
-6670 6668 "sample" "bigint" 64 0 1 1
-6671 6668 "sch" "clob" 0 0 1 2
-6672 6668 "tbl" "clob" 0 0 1 3
-6675 6674 "MinMax" "int" 32 0 1 0
-6676 6674 "sample" "bigint" 64 0 1 1
-6677 6674 "sch" "clob" 0 0 1 2
-6678 6674 "tbl" "clob" 0 0 1 3
-6679 6674 "col" "clob" 0 0 1 4
-6682 6681 "result" "clob" 0 0 0 0
-6683 6681 "src" "clob" 0 0 1 1
-6686 6685 "result" "smallint" 16 0 0 0
-6687 6685 "one" "tinyint" 8 0 1 1
-6688 6685 "two" "tinyint" 8 0 1 2
-6691 6690 "result" "int" 32 0 0 0
-6692 6690 "one" "smallint" 16 0 1 1
-6693 6690 "two" "smallint" 16 0 1 2
-6696 6695 "result" "bigint" 64 0 0 0
-6697 6695 "one" "int" 32 0 1 1
-6698 6695 "two" "int" 32 0 1 2
-6702 6701 "bam_repos" "clob" 0 0 1 0
-6703 6701 "dbschema" "smallint" 16 0 1 1
-6706 6705 "bam_files" "clob" 0 0 1 0
-6707 6705 "dbschema" "smallint" 16 0 1 1
-6710 6709 "bam_file" "clob" 0 0 1 0
-6711 6709 "dbschema" "smallint" 16 0 1 1
-6714 6713 "file_id" "bigint" 64 0 1 0
-6715 6713 "dbschema" "smallint" 16 0 1 1
-6718 6717 "result" "boolean" 1 0 0 0
-6719 6717 "flag" "smallint" 16 0 1 1
-6720 6717 "name" "clob" 0 0 1 2
-6723 6722 "result" "clob" 0 0 0 0
-6724 6722 "seq" "clob" 0 0 1 1
-6727 6726 "result" "clob" 0 0 0 0
-6728 6726 "qual" "clob" 0 0 1 1
-6731 6730 "result" "int" 32 0 0 0
-6732 6730 "cigar" "clob" 0 0 1 1
-6735 6734 "result" "char" 1 0 0 0
-6736 6734 "ref_pos" "int" 32 0 1 1
-6737 6734 "alg_seq" "clob" 0 0 1 2
-6738 6734 "alg_pos" "int" 32 0 1 3
-6739 6734 "alg_cigar" "clob" 0 0 1 4
-6742 6741 "output_path" "clob" 0 0 1 0
-6745 6744 "output_path" "clob" 0 0 1 0
-6815 6814 "value" "tinyint" 8 0 0 0
-6816 6814 "first" "tinyint" 8 0 1 1
-6817 6814 "last" "tinyint" 8 0 1 2
-6820 6819 "value" "tinyint" 8 0 0 0
-6821 6819 "first" "tinyint" 8 0 1 1
-6822 6819 "last" "tinyint" 8 0 1 2
-6823 6819 "stepsize" "tinyint" 8 0 1 3
-6826 6825 "value" "smallint" 16 0 0 0
-6827 6825 "first" "smallint" 16 0 1 1
-6828 6825 "last" "smallint" 16 0 1 2
-6831 6830 "value" "smallint" 16 0 0 0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
