Changeset: 73ed1d46b4a2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=73ed1d46b4a2 Modified Files: clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out monetdb5/mal/Tests/tst025.stable.out monetdb5/mal/Tests/tst032.stable.out sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out Branch: profiler Log Message:
Approve output diffs (truncated from 2583 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 @@ -189,6 +189,7 @@ SYSTEM FUNCTION sys.like SYSTEM FUNCTION sys.linefromtext SYSTEM FUNCTION sys.listdir SYSTEM FUNCTION sys.listdirpat +SYSTEM FUNCTION sys.malfunctions SYSTEM FUNCTION sys.masklen SYSTEM FUNCTION sys.mbr SYSTEM FUNCTION sys.mbroverlaps @@ -1624,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 -6183 "qtag" "bigint" 64 0 6191 NULL true 0 NULL -6184 "user" "clob" 0 0 6191 NULL true 1 NULL -6185 "started" "timestamp" 7 0 6191 NULL true 2 NULL -6186 "estimate" "timestamp" 7 0 6191 NULL true 3 NULL -6187 "progress" "int" 32 0 6191 NULL true 4 NULL -6188 "status" "clob" 0 0 6191 NULL true 5 NULL -6189 "tag" "oid" 63 0 6191 NULL true 6 NULL -6190 "query" "clob" 0 0 6191 NULL true 7 NULL -6217 "rowid" "bigint" 64 0 6221 NULL true 0 NULL -6218 "fldid" "int" 32 0 6221 NULL true 1 NULL -6219 "message" "clob" 0 0 6221 NULL true 2 NULL -6220 "input" "clob" 0 0 6221 NULL true 3 NULL -6891 "keyword" "varchar" 40 0 6894 NULL false 0 NULL -6896 "table_type_id" "smallint" 16 0 6902 NULL false 0 NULL -6899 "table_type_name" "varchar" 25 0 6902 NULL false 1 NULL -6904 "dependency_type_id" "smallint" 16 0 6910 NULL false 0 NULL -6907 "dependency_type_name" "varchar" 15 0 6910 NULL false 1 NULL -6925 "file_id" "int" 32 0 6927 NULL true 0 NULL -6926 "location" "char" 256 0 6927 NULL true 1 NULL -6929 "dim_id" "int" 32 0 6933 NULL true 0 NULL -6930 "file_id" "int" 32 0 6933 NULL true 1 NULL -6931 "name" "varchar" 64 0 6933 NULL true 2 NULL -6932 "length" "int" 32 0 6933 NULL true 3 NULL -6935 "var_id" "int" 32 0 6941 NULL true 0 NULL -6936 "file_id" "int" 32 0 6941 NULL true 1 NULL -6937 "name" "varchar" 64 0 6941 NULL true 2 NULL -6938 "vartype" "varchar" 64 0 6941 NULL true 3 NULL -6939 "ndim" "int" 32 0 6941 NULL true 4 NULL -6940 "coord_dim_id" "int" 32 0 6941 NULL true 5 NULL -6943 "var_id" "int" 32 0 6947 NULL true 0 NULL -6944 "dim_id" "int" 32 0 6947 NULL true 1 NULL -6945 "file_id" "int" 32 0 6947 NULL true 2 NULL -6946 "dimpos" "int" 32 0 6947 NULL true 3 NULL -6949 "obj_name" "varchar" 256 0 6955 NULL true 0 NULL -6950 "att_name" "varchar" 256 0 6955 NULL true 1 NULL -6951 "att_type" "varchar" 64 0 6955 NULL true 2 NULL -6952 "value" "clob" 0 0 6955 NULL true 3 NULL -6953 "file_id" "int" 32 0 6955 NULL true 4 NULL -6954 "gr_name" "varchar" 256 0 6955 NULL true 5 NULL -6980 "schema" "clob" 0 0 6994 NULL true 0 NULL -6981 "table" "clob" 0 0 6994 NULL true 1 NULL -6982 "column" "clob" 0 0 6994 NULL true 2 NULL -6983 "type" "clob" 0 0 6994 NULL true 3 NULL -6984 "mode" "clob" 0 0 6994 NULL true 4 NULL -6985 "location" "clob" 0 0 6994 NULL true 5 NULL -6986 "count" "bigint" 64 0 6994 NULL true 6 NULL -6987 "typewidth" "int" 32 0 6994 NULL true 7 NULL -6988 "columnsize" "bigint" 64 0 6994 NULL true 8 NULL -6989 "heapsize" "bigint" 64 0 6994 NULL true 9 NULL -6990 "hashes" "bigint" 64 0 6994 NULL true 10 NULL -6991 "phash" "boolean" 1 0 6994 NULL true 11 NULL -6992 "imprints" "bigint" 64 0 6994 NULL true 12 NULL -6993 "sorted" "boolean" 1 0 6994 NULL true 13 NULL -6996 "schema" "clob" 0 0 7006 NULL true 0 NULL -6997 "table" "clob" 0 0 7006 NULL true 1 NULL -6998 "column" "clob" 0 0 7006 NULL true 2 NULL -6999 "type" "clob" 0 0 7006 NULL true 3 NULL -7000 "typewidth" "int" 32 0 7006 NULL true 4 NULL -7001 "count" "bigint" 64 0 7006 NULL true 5 NULL -7002 "distinct" "bigint" 64 0 7006 NULL true 6 NULL -7003 "atomwidth" "int" 32 0 7006 NULL true 7 NULL -7004 "reference" "boolean" 1 0 7006 NULL true 8 NULL -7005 "sorted" "boolean" 1 0 7006 NULL true 9 NULL -7044 "schema" "clob" 0 0 7054 NULL true 0 NULL -7045 "table" "clob" 0 0 7054 NULL true 1 NULL -7046 "column" "clob" 0 0 7054 NULL true 2 NULL -7047 "type" "clob" 0 0 7054 NULL true 3 NULL -7048 "count" "bigint" 64 0 7054 NULL true 4 NULL -7049 "columnsize" "bigint" 64 0 7054 NULL true 5 NULL -7050 "heapsize" "bigint" 64 0 7054 NULL true 6 NULL -7051 "hashes" "bigint" 64 0 7054 NULL true 7 NULL -7052 "imprints" "bigint" 64 0 7054 NULL true 8 NULL -7053 "sorted" "boolean" 1 0 7054 NULL true 9 NULL -7056 "schema" "clob" 0 0 7064 NULL true 0 NULL -7057 "table" "clob" 0 0 7064 NULL true 1 NULL -7058 "count" "bigint" 64 0 7064 NULL true 2 NULL -7059 "columnsize" "hugeint" 128 0 7064 NULL true 3 NULL -7060 "heapsize" "hugeint" 128 0 7064 NULL true 4 NULL -7061 "hashes" "hugeint" 128 0 7064 NULL true 5 NULL -7062 "imprints" "hugeint" 128 0 7064 NULL true 6 NULL -7063 "auxiliary" "hugeint" 128 0 7064 NULL true 7 NULL -7066 "column_id" "int" 32 0 7077 NULL true 0 NULL -7067 "type" "clob" 0 0 7077 NULL true 1 NULL -7068 "width" "int" 32 0 7077 NULL true 2 NULL -7069 "stamp" "timestamp" 7 0 7077 NULL true 3 NULL -7070 "sample" "bigint" 64 0 7077 NULL true 4 NULL -7071 "count" "bigint" 64 0 7077 NULL true 5 NULL -7072 "unique" "bigint" 64 0 7077 NULL true 6 NULL -7073 "nils" "bigint" 64 0 7077 NULL true 7 NULL -7074 "minval" "clob" 0 0 7077 NULL true 8 NULL -7075 "maxval" "clob" 0 0 7077 NULL true 9 NULL -7076 "sorted" "boolean" 1 0 7077 NULL true 10 NULL -7167 "file_id" "bigint" 64 0 7175 NULL false 0 NULL -7168 "file_location" "clob" 0 0 7175 NULL false 1 NULL -7169 "dbschema" "smallint" 16 0 7175 NULL false 2 NULL -7170 "format_version" "varchar" 7 0 7175 NULL true 3 NULL -7171 "sorting_order" "varchar" 10 0 7175 NULL true 4 NULL -7172 "comments" "clob" 0 0 7175 NULL true 5 NULL -7177 "sn" "clob" 0 0 7188 NULL false 0 NULL -7178 "file_id" "bigint" 64 0 7188 NULL false 1 NULL -7179 "ln" "int" 32 0 7188 NULL true 2 NULL -7180 "as" "int" 32 0 7188 NULL true 3 NULL -7181 "m5" "clob" 0 0 7188 NULL true 4 NULL -7182 "sp" "clob" 0 0 7188 NULL true 5 NULL -7183 "ur" "clob" 0 0 7188 NULL true 6 NULL -7190 "id" "clob" 0 0 7207 NULL false 0 NULL -7191 "file_id" "bigint" 64 0 7207 NULL false 1 NULL -7192 "cn" "clob" 0 0 7207 NULL true 2 NULL -7193 "ds" "clob" 0 0 7207 NULL true 3 NULL -7194 "dt" "timestamp" 7 0 7207 NULL true 4 NULL -7195 "fo" "clob" 0 0 7207 NULL true 5 NULL -7196 "ks" "clob" 0 0 7207 NULL true 6 NULL -7197 "lb" "clob" 0 0 7207 NULL true 7 NULL -7198 "pg" "clob" 0 0 7207 NULL true 8 NULL -7199 "pi" "int" 32 0 7207 NULL true 9 NULL -7200 "pl" "clob" 0 0 7207 NULL true 10 NULL -7201 "pu" "clob" 0 0 7207 NULL true 11 NULL -7202 "sm" "clob" 0 0 7207 NULL true 12 NULL -7209 "id" "clob" 0 0 7219 NULL false 0 NULL -7210 "file_id" "bigint" 64 0 7219 NULL false 1 NULL -7211 "pn" "clob" 0 0 7219 NULL true 2 NULL -7212 "cl" "clob" 0 0 7219 NULL true 3 NULL -7213 "pp" "clob" 0 0 7219 NULL true 4 NULL -7214 "vn" "clob" 0 0 7219 NULL true 5 NULL -7221 "qname" "clob" 0 0 7232 NULL false 0 NULL -7222 "flag" "smallint" 16 0 7232 NULL false 1 NULL -7223 "rname" "clob" 0 0 7232 NULL false 2 NULL -7224 "pos" "int" 32 0 7232 NULL false 3 NULL -7225 "mapq" "smallint" 16 0 7232 NULL false 4 NULL -7226 "cigar" "clob" 0 0 7232 NULL false 5 NULL -7227 "rnext" "clob" 0 0 7232 NULL false 6 NULL -7228 "pnext" "int" 32 0 7232 NULL false 7 NULL -7229 "tlen" "int" 32 0 7232 NULL false 8 NULL -7230 "seq" "clob" 0 0 7232 NULL false 9 NULL -7231 "qual" "clob" 0 0 7232 NULL false 10 NULL -7313 "function_id" "int" 32 0 7314 NULL true 0 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 COMMIT; START TRANSACTION; CREATE TABLE "sys"."_tables" ( @@ -1806,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 -6191 "queue" 2000 "create view sys.queue as select * from sys.queue();" 1 true 0 0 -6221 "rejects" 2000 "create view sys.rejects as select * from sys.rejects();" 1 true 0 0 -6894 "keywords" 2000 NULL 0 true 0 0 -6902 "table_types" 2000 NULL 0 true 0 0 -6910 "dependency_types" 2000 NULL 0 true 0 0 -6927 "netcdf_files" 2000 NULL 0 true 0 0 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
