Changeset: 3a6ee3cc5780 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3a6ee3cc5780
Modified Files:
clients/Tests/SQL-dump.stable.out.int128
monetdb5/mal/Tests/tst275.stable.out
sql/test/leaks/Tests/check0.stable.out.int128
sql/test/leaks/Tests/check1.stable.out.int128
sql/test/leaks/Tests/check2.stable.out.int128
sql/test/leaks/Tests/check3.stable.out.int128
sql/test/leaks/Tests/check4.stable.out.int128
sql/test/leaks/Tests/check5.stable.out.int128
sql/test/leaks/Tests/drop3.stable.out.int128
sql/test/leaks/Tests/select1.stable.out.int128
sql/test/leaks/Tests/select2.stable.out.int128
sql/test/leaks/Tests/temp1.stable.out.int128
sql/test/leaks/Tests/temp2.stable.out.int128
sql/test/leaks/Tests/temp3.stable.out.int128
Branch: profiler
Log Message:
Merge with default
diffs (truncated from 5611 to 300 lines):
diff --git a/clients/Tests/SQL-dump.stable.out.int128
b/clients/Tests/SQL-dump.stable.out.int128
--- a/clients/Tests/SQL-dump.stable.out.int128
+++ b/clients/Tests/SQL-dump.stable.out.int128
@@ -484,7 +484,7 @@ create function area(g geometry) returns
create function astext(g geometry) returns string external name geom."AsText";
-- The BAT buffer pool overview
create function sys.bbp ()
- returns table (id int, name string, htype string,
+ returns table (id int, name string,
ttype string, count bigint, refcnt int, lrefcnt int,
location string, heat int, dirty string,
status string, kind string)
@@ -1625,142 +1625,142 @@ 6141 "def" "clob" 0 0 6143 NULL
true 1 N
6142 "status" "clob" 0 0 6143 NULL true 2
NULL
6149 "name" "clob" 0 0 6151 NULL true 0 NULL
6150 "value" "clob" 0 0 6151 NULL true 1 NULL
-6188 "qtag" "bigint" 64 0 6196 NULL true 0
NULL
-6189 "user" "clob" 0 0 6196 NULL true 1 NULL
-6190 "started" "timestamp" 7 0 6196 NULL true
2 NULL
-6191 "estimate" "timestamp" 7 0 6196 NULL true
3 NULL
-6192 "progress" "int" 32 0 6196 NULL true 4
NULL
-6193 "status" "clob" 0 0 6196 NULL true 5
NULL
-6194 "tag" "oid" 63 0 6196 NULL true 6 NULL
-6195 "query" "clob" 0 0 6196 NULL true 7 NULL
-6222 "rowid" "bigint" 64 0 6226 NULL true 0
NULL
-6223 "fldid" "int" 32 0 6226 NULL true 1 NULL
-6224 "message" "clob" 0 0 6226 NULL true 2
NULL
-6225 "input" "clob" 0 0 6226 NULL true 3 NULL
-6896 "keyword" "varchar" 40 0 6899 NULL false
0 NULL
-6901 "table_type_id" "smallint" 16 0 6907 NULL false
0 NULL
-6904 "table_type_name" "varchar" 25 0 6907 NULL
false 1 NULL
-6909 "dependency_type_id" "smallint" 16 0 6915 NULL
false 0 NULL
-6912 "dependency_type_name" "varchar" 15 0 6915 NULL
false 1 NULL
-6930 "file_id" "int" 32 0 6932 NULL true 0
NULL
-6931 "location" "char" 256 0 6932 NULL true 1
NULL
-6934 "dim_id" "int" 32 0 6938 NULL true 0
NULL
-6935 "file_id" "int" 32 0 6938 NULL true 1
NULL
-6936 "name" "varchar" 64 0 6938 NULL true 2
NULL
-6937 "length" "int" 32 0 6938 NULL true 3
NULL
-6940 "var_id" "int" 32 0 6946 NULL true 0
NULL
-6941 "file_id" "int" 32 0 6946 NULL true 1
NULL
-6942 "name" "varchar" 64 0 6946 NULL true 2
NULL
-6943 "vartype" "varchar" 64 0 6946 NULL true
3 NULL
-6944 "ndim" "int" 32 0 6946 NULL true 4 NULL
-6945 "coord_dim_id" "int" 32 0 6946 NULL true 5
NULL
-6948 "var_id" "int" 32 0 6952 NULL true 0
NULL
-6949 "dim_id" "int" 32 0 6952 NULL true 1
NULL
-6950 "file_id" "int" 32 0 6952 NULL true 2
NULL
-6951 "dimpos" "int" 32 0 6952 NULL true 3
NULL
-6954 "obj_name" "varchar" 256 0 6960 NULL true
0 NULL
-6955 "att_name" "varchar" 256 0 6960 NULL true
1 NULL
-6956 "att_type" "varchar" 64 0 6960 NULL true
2 NULL
-6957 "value" "clob" 0 0 6960 NULL true 3 NULL
-6958 "file_id" "int" 32 0 6960 NULL true 4
NULL
-6959 "gr_name" "varchar" 256 0 6960 NULL true
5 NULL
-6985 "schema" "clob" 0 0 6999 NULL true 0
NULL
-6986 "table" "clob" 0 0 6999 NULL true 1 NULL
-6987 "column" "clob" 0 0 6999 NULL true 2
NULL
-6988 "type" "clob" 0 0 6999 NULL true 3 NULL
-6989 "mode" "clob" 0 0 6999 NULL true 4 NULL
-6990 "location" "clob" 0 0 6999 NULL true 5
NULL
-6991 "count" "bigint" 64 0 6999 NULL true 6
NULL
-6992 "typewidth" "int" 32 0 6999 NULL true 7
NULL
-6993 "columnsize" "bigint" 64 0 6999 NULL true
8 NULL
-6994 "heapsize" "bigint" 64 0 6999 NULL true
9 NULL
-6995 "hashes" "bigint" 64 0 6999 NULL true
10 NULL
-6996 "phash" "boolean" 1 0 6999 NULL true 11
NULL
-6997 "imprints" "bigint" 64 0 6999 NULL true
12 NULL
-6998 "sorted" "boolean" 1 0 6999 NULL true
13 NULL
-7001 "schema" "clob" 0 0 7011 NULL true 0
NULL
-7002 "table" "clob" 0 0 7011 NULL true 1 NULL
-7003 "column" "clob" 0 0 7011 NULL true 2
NULL
-7004 "type" "clob" 0 0 7011 NULL true 3 NULL
-7005 "typewidth" "int" 32 0 7011 NULL true 4
NULL
-7006 "count" "bigint" 64 0 7011 NULL true 5
NULL
-7007 "distinct" "bigint" 64 0 7011 NULL true
6 NULL
-7008 "atomwidth" "int" 32 0 7011 NULL true 7
NULL
-7009 "reference" "boolean" 1 0 7011 NULL true
8 NULL
-7010 "sorted" "boolean" 1 0 7011 NULL true
9 NULL
-7049 "schema" "clob" 0 0 7059 NULL true 0
NULL
-7050 "table" "clob" 0 0 7059 NULL true 1 NULL
-7051 "column" "clob" 0 0 7059 NULL true 2
NULL
-7052 "type" "clob" 0 0 7059 NULL true 3 NULL
-7053 "count" "bigint" 64 0 7059 NULL true 4
NULL
-7054 "columnsize" "bigint" 64 0 7059 NULL true
5 NULL
-7055 "heapsize" "bigint" 64 0 7059 NULL true
6 NULL
-7056 "hashes" "bigint" 64 0 7059 NULL true
7 NULL
-7057 "imprints" "bigint" 64 0 7059 NULL true
8 NULL
-7058 "sorted" "boolean" 1 0 7059 NULL true
9 NULL
-7061 "schema" "clob" 0 0 7069 NULL true 0
NULL
-7062 "table" "clob" 0 0 7069 NULL true 1 NULL
-7063 "count" "bigint" 64 0 7069 NULL true 2
NULL
-7064 "columnsize" "hugeint" 128 0 7069 NULL true
3 NULL
-7065 "heapsize" "hugeint" 128 0 7069 NULL true
4 NULL
-7066 "hashes" "hugeint" 128 0 7069 NULL true
5 NULL
-7067 "imprints" "hugeint" 128 0 7069 NULL true
6 NULL
-7068 "auxiliary" "hugeint" 128 0 7069 NULL true
7 NULL
-7071 "column_id" "int" 32 0 7082 NULL true 0
NULL
-7072 "type" "clob" 0 0 7082 NULL true 1 NULL
-7073 "width" "int" 32 0 7082 NULL true 2 NULL
-7074 "stamp" "timestamp" 7 0 7082 NULL true 3
NULL
-7075 "sample" "bigint" 64 0 7082 NULL true
4 NULL
-7076 "count" "bigint" 64 0 7082 NULL true 5
NULL
-7077 "unique" "bigint" 64 0 7082 NULL true
6 NULL
-7078 "nils" "bigint" 64 0 7082 NULL true 7
NULL
-7079 "minval" "clob" 0 0 7082 NULL true 8
NULL
-7080 "maxval" "clob" 0 0 7082 NULL true 9
NULL
-7081 "sorted" "boolean" 1 0 7082 NULL true
10 NULL
-7172 "file_id" "bigint" 64 0 7180 NULL false
0 NULL
-7173 "file_location" "clob" 0 0 7180 NULL false 1
NULL
-7174 "dbschema" "smallint" 16 0 7180 NULL false
2 NULL
-7175 "format_version" "varchar" 7 0 7180 NULL
true 3 NULL
-7176 "sorting_order" "varchar" 10 0 7180 NULL true
4 NULL
-7177 "comments" "clob" 0 0 7180 NULL true 5
NULL
-7182 "sn" "clob" 0 0 7193 NULL false 0 NULL
-7183 "file_id" "bigint" 64 0 7193 NULL false
1 NULL
-7184 "ln" "int" 32 0 7193 NULL true 2 NULL
-7185 "as" "int" 32 0 7193 NULL true 3 NULL
-7186 "m5" "clob" 0 0 7193 NULL true 4 NULL
-7187 "sp" "clob" 0 0 7193 NULL true 5 NULL
-7188 "ur" "clob" 0 0 7193 NULL true 6 NULL
-7195 "id" "clob" 0 0 7212 NULL false 0 NULL
-7196 "file_id" "bigint" 64 0 7212 NULL false
1 NULL
-7197 "cn" "clob" 0 0 7212 NULL true 2 NULL
-7198 "ds" "clob" 0 0 7212 NULL true 3 NULL
-7199 "dt" "timestamp" 7 0 7212 NULL true 4
NULL
-7200 "fo" "clob" 0 0 7212 NULL true 5 NULL
-7201 "ks" "clob" 0 0 7212 NULL true 6 NULL
-7202 "lb" "clob" 0 0 7212 NULL true 7 NULL
-7203 "pg" "clob" 0 0 7212 NULL true 8 NULL
-7204 "pi" "int" 32 0 7212 NULL true 9 NULL
-7205 "pl" "clob" 0 0 7212 NULL true 10 NULL
-7206 "pu" "clob" 0 0 7212 NULL true 11 NULL
-7207 "sm" "clob" 0 0 7212 NULL true 12 NULL
-7214 "id" "clob" 0 0 7224 NULL false 0 NULL
-7215 "file_id" "bigint" 64 0 7224 NULL false
1 NULL
-7216 "pn" "clob" 0 0 7224 NULL true 2 NULL
-7217 "cl" "clob" 0 0 7224 NULL true 3 NULL
-7218 "pp" "clob" 0 0 7224 NULL true 4 NULL
-7219 "vn" "clob" 0 0 7224 NULL true 5 NULL
-7226 "qname" "clob" 0 0 7237 NULL false 0 NULL
-7227 "flag" "smallint" 16 0 7237 NULL false 1
NULL
-7228 "rname" "clob" 0 0 7237 NULL false 2 NULL
-7229 "pos" "int" 32 0 7237 NULL false 3 NULL
-7230 "mapq" "smallint" 16 0 7237 NULL false 4
NULL
-7231 "cigar" "clob" 0 0 7237 NULL false 5 NULL
-7232 "rnext" "clob" 0 0 7237 NULL false 6 NULL
-7233 "pnext" "int" 32 0 7237 NULL false 7 NULL
-7234 "tlen" "int" 32 0 7237 NULL false 8 NULL
-7235 "seq" "clob" 0 0 7237 NULL false 9 NULL
-7236 "qual" "clob" 0 0 7237 NULL false 10 NULL
-7318 "function_id" "int" 32 0 7319 NULL true 0
NULL
+6187 "qtag" "bigint" 64 0 6195 NULL true 0
NULL
+6188 "user" "clob" 0 0 6195 NULL true 1 NULL
+6189 "started" "timestamp" 7 0 6195 NULL true
2 NULL
+6190 "estimate" "timestamp" 7 0 6195 NULL true
3 NULL
+6191 "progress" "int" 32 0 6195 NULL true 4
NULL
+6192 "status" "clob" 0 0 6195 NULL true 5
NULL
+6193 "tag" "oid" 63 0 6195 NULL true 6 NULL
+6194 "query" "clob" 0 0 6195 NULL true 7 NULL
+6221 "rowid" "bigint" 64 0 6225 NULL true 0
NULL
+6222 "fldid" "int" 32 0 6225 NULL true 1 NULL
+6223 "message" "clob" 0 0 6225 NULL true 2
NULL
+6224 "input" "clob" 0 0 6225 NULL true 3 NULL
+6895 "keyword" "varchar" 40 0 6898 NULL false
0 NULL
+6900 "table_type_id" "smallint" 16 0 6906 NULL false
0 NULL
+6903 "table_type_name" "varchar" 25 0 6906 NULL
false 1 NULL
+6908 "dependency_type_id" "smallint" 16 0 6914 NULL
false 0 NULL
+6911 "dependency_type_name" "varchar" 15 0 6914 NULL
false 1 NULL
+6929 "file_id" "int" 32 0 6931 NULL true 0
NULL
+6930 "location" "char" 256 0 6931 NULL true 1
NULL
+6933 "dim_id" "int" 32 0 6937 NULL true 0
NULL
+6934 "file_id" "int" 32 0 6937 NULL true 1
NULL
+6935 "name" "varchar" 64 0 6937 NULL true 2
NULL
+6936 "length" "int" 32 0 6937 NULL true 3
NULL
+6939 "var_id" "int" 32 0 6945 NULL true 0
NULL
+6940 "file_id" "int" 32 0 6945 NULL true 1
NULL
+6941 "name" "varchar" 64 0 6945 NULL true 2
NULL
+6942 "vartype" "varchar" 64 0 6945 NULL true
3 NULL
+6943 "ndim" "int" 32 0 6945 NULL true 4 NULL
+6944 "coord_dim_id" "int" 32 0 6945 NULL true 5
NULL
+6947 "var_id" "int" 32 0 6951 NULL true 0
NULL
+6948 "dim_id" "int" 32 0 6951 NULL true 1
NULL
+6949 "file_id" "int" 32 0 6951 NULL true 2
NULL
+6950 "dimpos" "int" 32 0 6951 NULL true 3
NULL
+6953 "obj_name" "varchar" 256 0 6959 NULL true
0 NULL
+6954 "att_name" "varchar" 256 0 6959 NULL true
1 NULL
+6955 "att_type" "varchar" 64 0 6959 NULL true
2 NULL
+6956 "value" "clob" 0 0 6959 NULL true 3 NULL
+6957 "file_id" "int" 32 0 6959 NULL true 4
NULL
+6958 "gr_name" "varchar" 256 0 6959 NULL true
5 NULL
+6984 "schema" "clob" 0 0 6998 NULL true 0
NULL
+6985 "table" "clob" 0 0 6998 NULL true 1 NULL
+6986 "column" "clob" 0 0 6998 NULL true 2
NULL
+6987 "type" "clob" 0 0 6998 NULL true 3 NULL
+6988 "mode" "clob" 0 0 6998 NULL true 4 NULL
+6989 "location" "clob" 0 0 6998 NULL true 5
NULL
+6990 "count" "bigint" 64 0 6998 NULL true 6
NULL
+6991 "typewidth" "int" 32 0 6998 NULL true 7
NULL
+6992 "columnsize" "bigint" 64 0 6998 NULL true
8 NULL
+6993 "heapsize" "bigint" 64 0 6998 NULL true
9 NULL
+6994 "hashes" "bigint" 64 0 6998 NULL true
10 NULL
+6995 "phash" "boolean" 1 0 6998 NULL true 11
NULL
+6996 "imprints" "bigint" 64 0 6998 NULL true
12 NULL
+6997 "sorted" "boolean" 1 0 6998 NULL true
13 NULL
+7000 "schema" "clob" 0 0 7010 NULL true 0
NULL
+7001 "table" "clob" 0 0 7010 NULL true 1 NULL
+7002 "column" "clob" 0 0 7010 NULL true 2
NULL
+7003 "type" "clob" 0 0 7010 NULL true 3 NULL
+7004 "typewidth" "int" 32 0 7010 NULL true 4
NULL
+7005 "count" "bigint" 64 0 7010 NULL true 5
NULL
+7006 "distinct" "bigint" 64 0 7010 NULL true
6 NULL
+7007 "atomwidth" "int" 32 0 7010 NULL true 7
NULL
+7008 "reference" "boolean" 1 0 7010 NULL true
8 NULL
+7009 "sorted" "boolean" 1 0 7010 NULL true
9 NULL
+7048 "schema" "clob" 0 0 7058 NULL true 0
NULL
+7049 "table" "clob" 0 0 7058 NULL true 1 NULL
+7050 "column" "clob" 0 0 7058 NULL true 2
NULL
+7051 "type" "clob" 0 0 7058 NULL true 3 NULL
+7052 "count" "bigint" 64 0 7058 NULL true 4
NULL
+7053 "columnsize" "bigint" 64 0 7058 NULL true
5 NULL
+7054 "heapsize" "bigint" 64 0 7058 NULL true
6 NULL
+7055 "hashes" "bigint" 64 0 7058 NULL true
7 NULL
+7056 "imprints" "bigint" 64 0 7058 NULL true
8 NULL
+7057 "sorted" "boolean" 1 0 7058 NULL true
9 NULL
+7060 "schema" "clob" 0 0 7068 NULL true 0
NULL
+7061 "table" "clob" 0 0 7068 NULL true 1 NULL
+7062 "count" "bigint" 64 0 7068 NULL true 2
NULL
+7063 "columnsize" "hugeint" 128 0 7068 NULL true
3 NULL
+7064 "heapsize" "hugeint" 128 0 7068 NULL true
4 NULL
+7065 "hashes" "hugeint" 128 0 7068 NULL true
5 NULL
+7066 "imprints" "hugeint" 128 0 7068 NULL true
6 NULL
+7067 "auxiliary" "hugeint" 128 0 7068 NULL true
7 NULL
+7070 "column_id" "int" 32 0 7081 NULL true 0
NULL
+7071 "type" "clob" 0 0 7081 NULL true 1 NULL
+7072 "width" "int" 32 0 7081 NULL true 2 NULL
+7073 "stamp" "timestamp" 7 0 7081 NULL true 3
NULL
+7074 "sample" "bigint" 64 0 7081 NULL true
4 NULL
+7075 "count" "bigint" 64 0 7081 NULL true 5
NULL
+7076 "unique" "bigint" 64 0 7081 NULL true
6 NULL
+7077 "nils" "bigint" 64 0 7081 NULL true 7
NULL
+7078 "minval" "clob" 0 0 7081 NULL true 8
NULL
+7079 "maxval" "clob" 0 0 7081 NULL true 9
NULL
+7080 "sorted" "boolean" 1 0 7081 NULL true
10 NULL
+7171 "file_id" "bigint" 64 0 7179 NULL false
0 NULL
+7172 "file_location" "clob" 0 0 7179 NULL false 1
NULL
+7173 "dbschema" "smallint" 16 0 7179 NULL false
2 NULL
+7174 "format_version" "varchar" 7 0 7179 NULL
true 3 NULL
+7175 "sorting_order" "varchar" 10 0 7179 NULL true
4 NULL
+7176 "comments" "clob" 0 0 7179 NULL true 5
NULL
+7181 "sn" "clob" 0 0 7192 NULL false 0 NULL
+7182 "file_id" "bigint" 64 0 7192 NULL false
1 NULL
+7183 "ln" "int" 32 0 7192 NULL true 2 NULL
+7184 "as" "int" 32 0 7192 NULL true 3 NULL
+7185 "m5" "clob" 0 0 7192 NULL true 4 NULL
+7186 "sp" "clob" 0 0 7192 NULL true 5 NULL
+7187 "ur" "clob" 0 0 7192 NULL true 6 NULL
+7194 "id" "clob" 0 0 7211 NULL false 0 NULL
+7195 "file_id" "bigint" 64 0 7211 NULL false
1 NULL
+7196 "cn" "clob" 0 0 7211 NULL true 2 NULL
+7197 "ds" "clob" 0 0 7211 NULL true 3 NULL
+7198 "dt" "timestamp" 7 0 7211 NULL true 4
NULL
+7199 "fo" "clob" 0 0 7211 NULL true 5 NULL
+7200 "ks" "clob" 0 0 7211 NULL true 6 NULL
+7201 "lb" "clob" 0 0 7211 NULL true 7 NULL
+7202 "pg" "clob" 0 0 7211 NULL true 8 NULL
+7203 "pi" "int" 32 0 7211 NULL true 9 NULL
+7204 "pl" "clob" 0 0 7211 NULL true 10 NULL
+7205 "pu" "clob" 0 0 7211 NULL true 11 NULL
+7206 "sm" "clob" 0 0 7211 NULL true 12 NULL
+7213 "id" "clob" 0 0 7223 NULL false 0 NULL
+7214 "file_id" "bigint" 64 0 7223 NULL false
1 NULL
+7215 "pn" "clob" 0 0 7223 NULL true 2 NULL
+7216 "cl" "clob" 0 0 7223 NULL true 3 NULL
+7217 "pp" "clob" 0 0 7223 NULL true 4 NULL
+7218 "vn" "clob" 0 0 7223 NULL true 5 NULL
+7225 "qname" "clob" 0 0 7236 NULL false 0 NULL
+7226 "flag" "smallint" 16 0 7236 NULL false 1
NULL
+7227 "rname" "clob" 0 0 7236 NULL false 2 NULL
+7228 "pos" "int" 32 0 7236 NULL false 3 NULL
+7229 "mapq" "smallint" 16 0 7236 NULL false 4
NULL
+7230 "cigar" "clob" 0 0 7236 NULL false 5 NULL
+7231 "rnext" "clob" 0 0 7236 NULL false 6 NULL
+7232 "pnext" "int" 32 0 7236 NULL false 7 NULL
+7233 "tlen" "int" 32 0 7236 NULL false 8 NULL
+7234 "seq" "clob" 0 0 7236 NULL false 9 NULL
+7235 "qual" "clob" 0 0 7236 NULL false 10 NULL
+7317 "function_id" "int" 32 0 7318 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1807,27 +1807,27 @@ 5930 "tracelog" 2000 "create view sys.tr
6063 "sessions" 2000 "create view sys.sessions as select * from
sys.sessions();" 1 true 0 0
6143 "optimizers" 2000 "create view sys.optimizers as select * from
sys.optimizers();" 1 true 0 0
6151 "environment" 2000 "create view sys.environment as select * from
sys.environment();" 1 true 0 0
-6196 "queue" 2000 "create view sys.queue as select * from sys.queue();"
1 true 0 0
-6226 "rejects" 2000 "create view sys.rejects as select * from
sys.rejects();" 1 true 0 0
-6899 "keywords" 2000 NULL 0 true 0 0
-6907 "table_types" 2000 NULL 0 true 0 0
-6915 "dependency_types" 2000 NULL 0 true 0 0
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
