Changeset: 782a2f281b3e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=782a2f281b3e Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out gdk/gdk.h gdk/gdk_bat.c monetdb5/mal/Tests/tst201.stable.out monetdb5/mal/Tests/tst810.stable.out monetdb5/modules/kernel/algebra.c monetdb5/modules/kernel/algebra.mal monetdb5/modules/kernel/bat5.c monetdb5/modules/kernel/bat5.mal monetdb5/modules/mal/Tests/inspect05.stable.out.int128 monetdb5/modules/mal/Tests/tokenizer00.stable.out monetdb5/modules/mal/tokenizer.c sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: default Log Message:
Headless cleanup - handle deletes using oids. - approve output diffs (truncated from 2792 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 @@ -192,6 +192,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 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 @@ -188,6 +188,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 @@ -1625,142 +1626,142 @@ 6148 "def" "clob" 0 0 6150 NULL true 1 N 6149 "status" "clob" 0 0 6150 NULL true 2 NULL 6156 "name" "clob" 0 0 6158 NULL true 0 NULL 6157 "value" "clob" 0 0 6158 NULL true 1 NULL -6190 "qtag" "bigint" 64 0 6198 NULL true 0 NULL -6191 "user" "clob" 0 0 6198 NULL true 1 NULL -6192 "started" "timestamp" 7 0 6198 NULL true 2 NULL -6193 "estimate" "timestamp" 7 0 6198 NULL true 3 NULL -6194 "progress" "int" 32 0 6198 NULL true 4 NULL -6195 "status" "clob" 0 0 6198 NULL true 5 NULL -6196 "tag" "oid" 63 0 6198 NULL true 6 NULL -6197 "query" "clob" 0 0 6198 NULL true 7 NULL -6224 "rowid" "bigint" 64 0 6228 NULL true 0 NULL -6225 "fldid" "int" 32 0 6228 NULL true 1 NULL -6226 "message" "clob" 0 0 6228 NULL true 2 NULL -6227 "input" "clob" 0 0 6228 NULL true 3 NULL -6883 "keyword" "varchar" 40 0 6886 NULL false 0 NULL -6888 "table_type_id" "smallint" 16 0 6894 NULL false 0 NULL -6891 "table_type_name" "varchar" 25 0 6894 NULL false 1 NULL -6896 "dependency_type_id" "smallint" 16 0 6902 NULL false 0 NULL -6899 "dependency_type_name" "varchar" 15 0 6902 NULL false 1 NULL -6917 "file_id" "int" 32 0 6919 NULL true 0 NULL -6918 "location" "char" 256 0 6919 NULL true 1 NULL -6921 "dim_id" "int" 32 0 6925 NULL true 0 NULL -6922 "file_id" "int" 32 0 6925 NULL true 1 NULL -6923 "name" "varchar" 64 0 6925 NULL true 2 NULL -6924 "length" "int" 32 0 6925 NULL true 3 NULL -6927 "var_id" "int" 32 0 6933 NULL true 0 NULL -6928 "file_id" "int" 32 0 6933 NULL true 1 NULL -6929 "name" "varchar" 64 0 6933 NULL true 2 NULL -6930 "vartype" "varchar" 64 0 6933 NULL true 3 NULL -6931 "ndim" "int" 32 0 6933 NULL true 4 NULL -6932 "coord_dim_id" "int" 32 0 6933 NULL true 5 NULL -6935 "var_id" "int" 32 0 6939 NULL true 0 NULL -6936 "dim_id" "int" 32 0 6939 NULL true 1 NULL -6937 "file_id" "int" 32 0 6939 NULL true 2 NULL -6938 "dimpos" "int" 32 0 6939 NULL true 3 NULL -6941 "obj_name" "varchar" 256 0 6947 NULL true 0 NULL -6942 "att_name" "varchar" 256 0 6947 NULL true 1 NULL -6943 "att_type" "varchar" 64 0 6947 NULL true 2 NULL -6944 "value" "clob" 0 0 6947 NULL true 3 NULL -6945 "file_id" "int" 32 0 6947 NULL true 4 NULL -6946 "gr_name" "varchar" 256 0 6947 NULL true 5 NULL -6972 "schema" "clob" 0 0 6986 NULL true 0 NULL -6973 "table" "clob" 0 0 6986 NULL true 1 NULL -6974 "column" "clob" 0 0 6986 NULL true 2 NULL -6975 "type" "clob" 0 0 6986 NULL true 3 NULL -6976 "mode" "clob" 0 0 6986 NULL true 4 NULL -6977 "location" "clob" 0 0 6986 NULL true 5 NULL -6978 "count" "bigint" 64 0 6986 NULL true 6 NULL -6979 "typewidth" "int" 32 0 6986 NULL true 7 NULL -6980 "columnsize" "bigint" 64 0 6986 NULL true 8 NULL -6981 "heapsize" "bigint" 64 0 6986 NULL true 9 NULL -6982 "hashes" "bigint" 64 0 6986 NULL true 10 NULL -6983 "phash" "boolean" 1 0 6986 NULL true 11 NULL -6984 "imprints" "bigint" 64 0 6986 NULL true 12 NULL -6985 "sorted" "boolean" 1 0 6986 NULL true 13 NULL -6988 "schema" "clob" 0 0 6998 NULL true 0 NULL -6989 "table" "clob" 0 0 6998 NULL true 1 NULL -6990 "column" "clob" 0 0 6998 NULL true 2 NULL -6991 "type" "clob" 0 0 6998 NULL true 3 NULL -6992 "typewidth" "int" 32 0 6998 NULL true 4 NULL -6993 "count" "bigint" 64 0 6998 NULL true 5 NULL -6994 "distinct" "bigint" 64 0 6998 NULL true 6 NULL -6995 "atomwidth" "int" 32 0 6998 NULL true 7 NULL -6996 "reference" "boolean" 1 0 6998 NULL true 8 NULL -6997 "sorted" "boolean" 1 0 6998 NULL true 9 NULL -7036 "schema" "clob" 0 0 7046 NULL true 0 NULL -7037 "table" "clob" 0 0 7046 NULL true 1 NULL -7038 "column" "clob" 0 0 7046 NULL true 2 NULL -7039 "type" "clob" 0 0 7046 NULL true 3 NULL -7040 "count" "bigint" 64 0 7046 NULL true 4 NULL -7041 "columnsize" "bigint" 64 0 7046 NULL true 5 NULL -7042 "heapsize" "bigint" 64 0 7046 NULL true 6 NULL -7043 "hashes" "bigint" 64 0 7046 NULL true 7 NULL -7044 "imprints" "bigint" 64 0 7046 NULL true 8 NULL -7045 "sorted" "boolean" 1 0 7046 NULL true 9 NULL -7048 "schema" "clob" 0 0 7056 NULL true 0 NULL -7049 "table" "clob" 0 0 7056 NULL true 1 NULL -7050 "count" "bigint" 64 0 7056 NULL true 2 NULL -7051 "columnsize" "hugeint" 128 0 7056 NULL true 3 NULL -7052 "heapsize" "hugeint" 128 0 7056 NULL true 4 NULL -7053 "hashes" "hugeint" 128 0 7056 NULL true 5 NULL -7054 "imprints" "hugeint" 128 0 7056 NULL true 6 NULL -7055 "auxiliary" "hugeint" 128 0 7056 NULL true 7 NULL -7058 "column_id" "int" 32 0 7069 NULL true 0 NULL -7059 "type" "clob" 0 0 7069 NULL true 1 NULL -7060 "width" "int" 32 0 7069 NULL true 2 NULL -7061 "stamp" "timestamp" 7 0 7069 NULL true 3 NULL -7062 "sample" "bigint" 64 0 7069 NULL true 4 NULL -7063 "count" "bigint" 64 0 7069 NULL true 5 NULL -7064 "unique" "bigint" 64 0 7069 NULL true 6 NULL -7065 "nils" "bigint" 64 0 7069 NULL true 7 NULL -7066 "minval" "clob" 0 0 7069 NULL true 8 NULL -7067 "maxval" "clob" 0 0 7069 NULL true 9 NULL -7068 "sorted" "boolean" 1 0 7069 NULL true 10 NULL -7159 "file_id" "bigint" 64 0 7167 NULL false 0 NULL -7160 "file_location" "clob" 0 0 7167 NULL false 1 NULL -7161 "dbschema" "smallint" 16 0 7167 NULL false 2 NULL -7162 "format_version" "varchar" 7 0 7167 NULL true 3 NULL -7163 "sorting_order" "varchar" 10 0 7167 NULL true 4 NULL -7164 "comments" "clob" 0 0 7167 NULL true 5 NULL -7169 "sn" "clob" 0 0 7180 NULL false 0 NULL -7170 "file_id" "bigint" 64 0 7180 NULL false 1 NULL -7171 "ln" "int" 32 0 7180 NULL true 2 NULL -7172 "as" "int" 32 0 7180 NULL true 3 NULL -7173 "m5" "clob" 0 0 7180 NULL true 4 NULL -7174 "sp" "clob" 0 0 7180 NULL true 5 NULL -7175 "ur" "clob" 0 0 7180 NULL true 6 NULL -7182 "id" "clob" 0 0 7199 NULL false 0 NULL -7183 "file_id" "bigint" 64 0 7199 NULL false 1 NULL -7184 "cn" "clob" 0 0 7199 NULL true 2 NULL -7185 "ds" "clob" 0 0 7199 NULL true 3 NULL -7186 "dt" "timestamp" 7 0 7199 NULL true 4 NULL -7187 "fo" "clob" 0 0 7199 NULL true 5 NULL -7188 "ks" "clob" 0 0 7199 NULL true 6 NULL -7189 "lb" "clob" 0 0 7199 NULL true 7 NULL -7190 "pg" "clob" 0 0 7199 NULL true 8 NULL -7191 "pi" "int" 32 0 7199 NULL true 9 NULL -7192 "pl" "clob" 0 0 7199 NULL true 10 NULL -7193 "pu" "clob" 0 0 7199 NULL true 11 NULL -7194 "sm" "clob" 0 0 7199 NULL true 12 NULL -7201 "id" "clob" 0 0 7211 NULL false 0 NULL -7202 "file_id" "bigint" 64 0 7211 NULL false 1 NULL -7203 "pn" "clob" 0 0 7211 NULL true 2 NULL -7204 "cl" "clob" 0 0 7211 NULL true 3 NULL -7205 "pp" "clob" 0 0 7211 NULL true 4 NULL -7206 "vn" "clob" 0 0 7211 NULL true 5 NULL -7213 "qname" "clob" 0 0 7224 NULL false 0 NULL -7214 "flag" "smallint" 16 0 7224 NULL false 1 NULL -7215 "rname" "clob" 0 0 7224 NULL false 2 NULL -7216 "pos" "int" 32 0 7224 NULL false 3 NULL -7217 "mapq" "smallint" 16 0 7224 NULL false 4 NULL -7218 "cigar" "clob" 0 0 7224 NULL false 5 NULL -7219 "rnext" "clob" 0 0 7224 NULL false 6 NULL -7220 "pnext" "int" 32 0 7224 NULL false 7 NULL -7221 "tlen" "int" 32 0 7224 NULL false 8 NULL -7222 "seq" "clob" 0 0 7224 NULL false 9 NULL -7223 "qual" "clob" 0 0 7224 NULL false 10 NULL -7305 "function_id" "int" 32 0 7306 NULL true 0 NULL +6195 "qtag" "bigint" 64 0 6203 NULL true 0 NULL +6196 "user" "clob" 0 0 6203 NULL true 1 NULL +6197 "started" "timestamp" 7 0 6203 NULL true 2 NULL +6198 "estimate" "timestamp" 7 0 6203 NULL true 3 NULL +6199 "progress" "int" 32 0 6203 NULL true 4 NULL +6200 "status" "clob" 0 0 6203 NULL true 5 NULL +6201 "tag" "oid" 63 0 6203 NULL true 6 NULL +6202 "query" "clob" 0 0 6203 NULL true 7 NULL +6229 "rowid" "bigint" 64 0 6233 NULL true 0 NULL +6230 "fldid" "int" 32 0 6233 NULL true 1 NULL +6231 "message" "clob" 0 0 6233 NULL true 2 NULL +6232 "input" "clob" 0 0 6233 NULL true 3 NULL +6888 "keyword" "varchar" 40 0 6891 NULL false 0 NULL +6893 "table_type_id" "smallint" 16 0 6899 NULL false 0 NULL +6896 "table_type_name" "varchar" 25 0 6899 NULL false 1 NULL +6901 "dependency_type_id" "smallint" 16 0 6907 NULL false 0 NULL +6904 "dependency_type_name" "varchar" 15 0 6907 NULL false 1 NULL +6922 "file_id" "int" 32 0 6924 NULL true 0 NULL +6923 "location" "char" 256 0 6924 NULL true 1 NULL +6926 "dim_id" "int" 32 0 6930 NULL true 0 NULL +6927 "file_id" "int" 32 0 6930 NULL true 1 NULL +6928 "name" "varchar" 64 0 6930 NULL true 2 NULL +6929 "length" "int" 32 0 6930 NULL true 3 NULL +6932 "var_id" "int" 32 0 6938 NULL true 0 NULL +6933 "file_id" "int" 32 0 6938 NULL true 1 NULL +6934 "name" "varchar" 64 0 6938 NULL true 2 NULL +6935 "vartype" "varchar" 64 0 6938 NULL true 3 NULL +6936 "ndim" "int" 32 0 6938 NULL true 4 NULL +6937 "coord_dim_id" "int" 32 0 6938 NULL true 5 NULL +6940 "var_id" "int" 32 0 6944 NULL true 0 NULL +6941 "dim_id" "int" 32 0 6944 NULL true 1 NULL +6942 "file_id" "int" 32 0 6944 NULL true 2 NULL +6943 "dimpos" "int" 32 0 6944 NULL true 3 NULL +6946 "obj_name" "varchar" 256 0 6952 NULL true 0 NULL +6947 "att_name" "varchar" 256 0 6952 NULL true 1 NULL +6948 "att_type" "varchar" 64 0 6952 NULL true 2 NULL +6949 "value" "clob" 0 0 6952 NULL true 3 NULL +6950 "file_id" "int" 32 0 6952 NULL true 4 NULL +6951 "gr_name" "varchar" 256 0 6952 NULL true 5 NULL +6977 "schema" "clob" 0 0 6991 NULL true 0 NULL +6978 "table" "clob" 0 0 6991 NULL true 1 NULL +6979 "column" "clob" 0 0 6991 NULL true 2 NULL +6980 "type" "clob" 0 0 6991 NULL true 3 NULL +6981 "mode" "clob" 0 0 6991 NULL true 4 NULL +6982 "location" "clob" 0 0 6991 NULL true 5 NULL +6983 "count" "bigint" 64 0 6991 NULL true 6 NULL +6984 "typewidth" "int" 32 0 6991 NULL true 7 NULL +6985 "columnsize" "bigint" 64 0 6991 NULL true 8 NULL +6986 "heapsize" "bigint" 64 0 6991 NULL true 9 NULL +6987 "hashes" "bigint" 64 0 6991 NULL true 10 NULL +6988 "phash" "boolean" 1 0 6991 NULL true 11 NULL +6989 "imprints" "bigint" 64 0 6991 NULL true 12 NULL +6990 "sorted" "boolean" 1 0 6991 NULL true 13 NULL +6993 "schema" "clob" 0 0 7003 NULL true 0 NULL +6994 "table" "clob" 0 0 7003 NULL true 1 NULL +6995 "column" "clob" 0 0 7003 NULL true 2 NULL +6996 "type" "clob" 0 0 7003 NULL true 3 NULL +6997 "typewidth" "int" 32 0 7003 NULL true 4 NULL +6998 "count" "bigint" 64 0 7003 NULL true 5 NULL +6999 "distinct" "bigint" 64 0 7003 NULL true 6 NULL +7000 "atomwidth" "int" 32 0 7003 NULL true 7 NULL +7001 "reference" "boolean" 1 0 7003 NULL true 8 NULL +7002 "sorted" "boolean" 1 0 7003 NULL true 9 NULL +7041 "schema" "clob" 0 0 7051 NULL true 0 NULL +7042 "table" "clob" 0 0 7051 NULL true 1 NULL +7043 "column" "clob" 0 0 7051 NULL true 2 NULL +7044 "type" "clob" 0 0 7051 NULL true 3 NULL +7045 "count" "bigint" 64 0 7051 NULL true 4 NULL +7046 "columnsize" "bigint" 64 0 7051 NULL true 5 NULL +7047 "heapsize" "bigint" 64 0 7051 NULL true 6 NULL +7048 "hashes" "bigint" 64 0 7051 NULL true 7 NULL +7049 "imprints" "bigint" 64 0 7051 NULL true 8 NULL +7050 "sorted" "boolean" 1 0 7051 NULL true 9 NULL +7053 "schema" "clob" 0 0 7061 NULL true 0 NULL +7054 "table" "clob" 0 0 7061 NULL true 1 NULL +7055 "count" "bigint" 64 0 7061 NULL true 2 NULL +7056 "columnsize" "hugeint" 128 0 7061 NULL true 3 NULL +7057 "heapsize" "hugeint" 128 0 7061 NULL true 4 NULL +7058 "hashes" "hugeint" 128 0 7061 NULL true 5 NULL +7059 "imprints" "hugeint" 128 0 7061 NULL true 6 NULL +7060 "auxiliary" "hugeint" 128 0 7061 NULL true 7 NULL +7063 "column_id" "int" 32 0 7074 NULL true 0 NULL +7064 "type" "clob" 0 0 7074 NULL true 1 NULL +7065 "width" "int" 32 0 7074 NULL true 2 NULL +7066 "stamp" "timestamp" 7 0 7074 NULL true 3 NULL +7067 "sample" "bigint" 64 0 7074 NULL true 4 NULL +7068 "count" "bigint" 64 0 7074 NULL true 5 NULL +7069 "unique" "bigint" 64 0 7074 NULL true 6 NULL +7070 "nils" "bigint" 64 0 7074 NULL true 7 NULL +7071 "minval" "clob" 0 0 7074 NULL true 8 NULL +7072 "maxval" "clob" 0 0 7074 NULL true 9 NULL +7073 "sorted" "boolean" 1 0 7074 NULL true 10 NULL +7164 "file_id" "bigint" 64 0 7172 NULL false 0 NULL +7165 "file_location" "clob" 0 0 7172 NULL false 1 NULL +7166 "dbschema" "smallint" 16 0 7172 NULL false 2 NULL +7167 "format_version" "varchar" 7 0 7172 NULL true 3 NULL +7168 "sorting_order" "varchar" 10 0 7172 NULL true 4 NULL +7169 "comments" "clob" 0 0 7172 NULL true 5 NULL +7174 "sn" "clob" 0 0 7185 NULL false 0 NULL +7175 "file_id" "bigint" 64 0 7185 NULL false 1 NULL +7176 "ln" "int" 32 0 7185 NULL true 2 NULL +7177 "as" "int" 32 0 7185 NULL true 3 NULL +7178 "m5" "clob" 0 0 7185 NULL true 4 NULL +7179 "sp" "clob" 0 0 7185 NULL true 5 NULL +7180 "ur" "clob" 0 0 7185 NULL true 6 NULL +7187 "id" "clob" 0 0 7204 NULL false 0 NULL +7188 "file_id" "bigint" 64 0 7204 NULL false 1 NULL +7189 "cn" "clob" 0 0 7204 NULL true 2 NULL +7190 "ds" "clob" 0 0 7204 NULL true 3 NULL +7191 "dt" "timestamp" 7 0 7204 NULL true 4 NULL +7192 "fo" "clob" 0 0 7204 NULL true 5 NULL +7193 "ks" "clob" 0 0 7204 NULL true 6 NULL +7194 "lb" "clob" 0 0 7204 NULL true 7 NULL +7195 "pg" "clob" 0 0 7204 NULL true 8 NULL +7196 "pi" "int" 32 0 7204 NULL true 9 NULL +7197 "pl" "clob" 0 0 7204 NULL true 10 NULL +7198 "pu" "clob" 0 0 7204 NULL true 11 NULL +7199 "sm" "clob" 0 0 7204 NULL true 12 NULL +7206 "id" "clob" 0 0 7216 NULL false 0 NULL +7207 "file_id" "bigint" 64 0 7216 NULL false 1 NULL +7208 "pn" "clob" 0 0 7216 NULL true 2 NULL +7209 "cl" "clob" 0 0 7216 NULL true 3 NULL +7210 "pp" "clob" 0 0 7216 NULL true 4 NULL +7211 "vn" "clob" 0 0 7216 NULL true 5 NULL +7218 "qname" "clob" 0 0 7229 NULL false 0 NULL +7219 "flag" "smallint" 16 0 7229 NULL false 1 NULL +7220 "rname" "clob" 0 0 7229 NULL false 2 NULL +7221 "pos" "int" 32 0 7229 NULL false 3 NULL +7222 "mapq" "smallint" 16 0 7229 NULL false 4 NULL +7223 "cigar" "clob" 0 0 7229 NULL false 5 NULL +7224 "rnext" "clob" 0 0 7229 NULL false 6 NULL +7225 "pnext" "int" 32 0 7229 NULL false 7 NULL +7226 "tlen" "int" 32 0 7229 NULL false 8 NULL +7227 "seq" "clob" 0 0 7229 NULL false 9 NULL +7228 "qual" "clob" 0 0 7229 NULL false 10 NULL +7310 "function_id" "int" 32 0 7311 NULL true 0 NULL COMMIT; START TRANSACTION; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
