Changeset: ce86607b01c7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce86607b01c7 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out sql/scripts/25_debug.sql sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.sql sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.out sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: default Log Message:
add ability to set gdk_debug, ie much faster long_insert test diffs (truncated from 2562 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 @@ -126,6 +126,7 @@ SYSTEM FUNCTION sys.corr SYSTEM FUNCTION sys.crosses SYSTEM FUNCTION sys.date_to_str SYSTEM FUNCTION sys.db_users +SYSTEM FUNCTION sys.debug SYSTEM FUNCTION sys.degrees SYSTEM FUNCTION sys.dependencies_columns_on_functions SYSTEM FUNCTION sys.dependencies_columns_on_indexes 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 @@ -122,6 +122,7 @@ SYSTEM FUNCTION sys.corr SYSTEM FUNCTION sys.crosses SYSTEM FUNCTION sys.date_to_str SYSTEM FUNCTION sys.db_users +SYSTEM FUNCTION sys.debug SYSTEM FUNCTION sys.degrees SYSTEM FUNCTION sys.dependencies_columns_on_functions SYSTEM FUNCTION sys.dependencies_columns_on_indexes @@ -1691,142 +1692,142 @@ 6231 "def" "clob" 0 0 6233 NULL true 1 N 6232 "status" "clob" 0 0 6233 NULL true 2 NULL 6239 "name" "clob" 0 0 6241 NULL true 0 NULL 6240 "value" "clob" 0 0 6241 NULL true 1 NULL -6277 "qtag" "bigint" 64 0 6285 NULL true 0 NULL -6278 "user" "clob" 0 0 6285 NULL true 1 NULL -6279 "started" "timestamp" 7 0 6285 NULL true 2 NULL -6280 "estimate" "timestamp" 7 0 6285 NULL true 3 NULL -6281 "progress" "int" 32 0 6285 NULL true 4 NULL -6282 "status" "clob" 0 0 6285 NULL true 5 NULL -6283 "tag" "oid" 63 0 6285 NULL true 6 NULL -6284 "query" "clob" 0 0 6285 NULL true 7 NULL -6311 "rowid" "bigint" 64 0 6315 NULL true 0 NULL -6312 "fldid" "int" 32 0 6315 NULL true 1 NULL -6313 "message" "clob" 0 0 6315 NULL true 2 NULL -6314 "input" "clob" 0 0 6315 NULL true 3 NULL -6985 "keyword" "varchar" 40 0 6988 NULL false 0 NULL -6990 "table_type_id" "smallint" 16 0 6996 NULL false 0 NULL -6993 "table_type_name" "varchar" 25 0 6996 NULL false 1 NULL -6998 "dependency_type_id" "smallint" 16 0 7004 NULL false 0 NULL -7001 "dependency_type_name" "varchar" 15 0 7004 NULL false 1 NULL -7019 "file_id" "int" 32 0 7021 NULL true 0 NULL -7020 "location" "char" 256 0 7021 NULL true 1 NULL -7023 "dim_id" "int" 32 0 7027 NULL true 0 NULL -7024 "file_id" "int" 32 0 7027 NULL true 1 NULL -7025 "name" "varchar" 64 0 7027 NULL true 2 NULL -7026 "length" "int" 32 0 7027 NULL true 3 NULL -7029 "var_id" "int" 32 0 7035 NULL true 0 NULL -7030 "file_id" "int" 32 0 7035 NULL true 1 NULL -7031 "name" "varchar" 64 0 7035 NULL true 2 NULL -7032 "vartype" "varchar" 64 0 7035 NULL true 3 NULL -7033 "ndim" "int" 32 0 7035 NULL true 4 NULL -7034 "coord_dim_id" "int" 32 0 7035 NULL true 5 NULL -7037 "var_id" "int" 32 0 7041 NULL true 0 NULL -7038 "dim_id" "int" 32 0 7041 NULL true 1 NULL -7039 "file_id" "int" 32 0 7041 NULL true 2 NULL -7040 "dimpos" "int" 32 0 7041 NULL true 3 NULL -7043 "obj_name" "varchar" 256 0 7049 NULL true 0 NULL -7044 "att_name" "varchar" 256 0 7049 NULL true 1 NULL -7045 "att_type" "varchar" 64 0 7049 NULL true 2 NULL -7046 "value" "clob" 0 0 7049 NULL true 3 NULL -7047 "file_id" "int" 32 0 7049 NULL true 4 NULL -7048 "gr_name" "varchar" 256 0 7049 NULL true 5 NULL -7074 "schema" "clob" 0 0 7088 NULL true 0 NULL -7075 "table" "clob" 0 0 7088 NULL true 1 NULL -7076 "column" "clob" 0 0 7088 NULL true 2 NULL -7077 "type" "clob" 0 0 7088 NULL true 3 NULL -7078 "mode" "clob" 0 0 7088 NULL true 4 NULL -7079 "location" "clob" 0 0 7088 NULL true 5 NULL -7080 "count" "bigint" 64 0 7088 NULL true 6 NULL -7081 "typewidth" "int" 32 0 7088 NULL true 7 NULL -7082 "columnsize" "bigint" 64 0 7088 NULL true 8 NULL -7083 "heapsize" "bigint" 64 0 7088 NULL true 9 NULL -7084 "hashes" "bigint" 64 0 7088 NULL true 10 NULL -7085 "phash" "boolean" 1 0 7088 NULL true 11 NULL -7086 "imprints" "bigint" 64 0 7088 NULL true 12 NULL -7087 "sorted" "boolean" 1 0 7088 NULL true 13 NULL -7090 "schema" "clob" 0 0 7100 NULL true 0 NULL -7091 "table" "clob" 0 0 7100 NULL true 1 NULL -7092 "column" "clob" 0 0 7100 NULL true 2 NULL -7093 "type" "clob" 0 0 7100 NULL true 3 NULL -7094 "typewidth" "int" 32 0 7100 NULL true 4 NULL -7095 "count" "bigint" 64 0 7100 NULL true 5 NULL -7096 "distinct" "bigint" 64 0 7100 NULL true 6 NULL -7097 "atomwidth" "int" 32 0 7100 NULL true 7 NULL -7098 "reference" "boolean" 1 0 7100 NULL true 8 NULL -7099 "sorted" "boolean" 1 0 7100 NULL true 9 NULL -7138 "schema" "clob" 0 0 7148 NULL true 0 NULL -7139 "table" "clob" 0 0 7148 NULL true 1 NULL -7140 "column" "clob" 0 0 7148 NULL true 2 NULL -7141 "type" "clob" 0 0 7148 NULL true 3 NULL -7142 "count" "bigint" 64 0 7148 NULL true 4 NULL -7143 "columnsize" "bigint" 64 0 7148 NULL true 5 NULL -7144 "heapsize" "bigint" 64 0 7148 NULL true 6 NULL -7145 "hashes" "bigint" 64 0 7148 NULL true 7 NULL -7146 "imprints" "bigint" 64 0 7148 NULL true 8 NULL -7147 "sorted" "boolean" 1 0 7148 NULL true 9 NULL -7150 "schema" "clob" 0 0 7158 NULL true 0 NULL -7151 "table" "clob" 0 0 7158 NULL true 1 NULL -7152 "count" "bigint" 64 0 7158 NULL true 2 NULL -7153 "columnsize" "hugeint" 128 0 7158 NULL true 3 NULL -7154 "heapsize" "hugeint" 128 0 7158 NULL true 4 NULL -7155 "hashes" "hugeint" 128 0 7158 NULL true 5 NULL -7156 "imprints" "hugeint" 128 0 7158 NULL true 6 NULL -7157 "auxiliary" "hugeint" 128 0 7158 NULL true 7 NULL -7160 "column_id" "int" 32 0 7171 NULL true 0 NULL -7161 "type" "clob" 0 0 7171 NULL true 1 NULL -7162 "width" "int" 32 0 7171 NULL true 2 NULL -7163 "stamp" "timestamp" 7 0 7171 NULL true 3 NULL -7164 "sample" "bigint" 64 0 7171 NULL true 4 NULL -7165 "count" "bigint" 64 0 7171 NULL true 5 NULL -7166 "unique" "bigint" 64 0 7171 NULL true 6 NULL -7167 "nils" "bigint" 64 0 7171 NULL true 7 NULL -7168 "minval" "clob" 0 0 7171 NULL true 8 NULL -7169 "maxval" "clob" 0 0 7171 NULL true 9 NULL -7170 "sorted" "boolean" 1 0 7171 NULL true 10 NULL -7266 "file_id" "bigint" 64 0 7274 NULL false 0 NULL -7267 "file_location" "clob" 0 0 7274 NULL false 1 NULL -7268 "dbschema" "smallint" 16 0 7274 NULL false 2 NULL -7269 "format_version" "varchar" 7 0 7274 NULL true 3 NULL -7270 "sorting_order" "varchar" 10 0 7274 NULL true 4 NULL -7271 "comments" "clob" 0 0 7274 NULL true 5 NULL -7276 "sn" "clob" 0 0 7287 NULL false 0 NULL -7277 "file_id" "bigint" 64 0 7287 NULL false 1 NULL -7278 "ln" "int" 32 0 7287 NULL true 2 NULL -7279 "as" "int" 32 0 7287 NULL true 3 NULL -7280 "m5" "clob" 0 0 7287 NULL true 4 NULL -7281 "sp" "clob" 0 0 7287 NULL true 5 NULL -7282 "ur" "clob" 0 0 7287 NULL true 6 NULL -7289 "id" "clob" 0 0 7306 NULL false 0 NULL -7290 "file_id" "bigint" 64 0 7306 NULL false 1 NULL -7291 "cn" "clob" 0 0 7306 NULL true 2 NULL -7292 "ds" "clob" 0 0 7306 NULL true 3 NULL -7293 "dt" "timestamp" 7 0 7306 NULL true 4 NULL -7294 "fo" "clob" 0 0 7306 NULL true 5 NULL -7295 "ks" "clob" 0 0 7306 NULL true 6 NULL -7296 "lb" "clob" 0 0 7306 NULL true 7 NULL -7297 "pg" "clob" 0 0 7306 NULL true 8 NULL -7298 "pi" "int" 32 0 7306 NULL true 9 NULL -7299 "pl" "clob" 0 0 7306 NULL true 10 NULL -7300 "pu" "clob" 0 0 7306 NULL true 11 NULL -7301 "sm" "clob" 0 0 7306 NULL true 12 NULL -7308 "id" "clob" 0 0 7318 NULL false 0 NULL -7309 "file_id" "bigint" 64 0 7318 NULL false 1 NULL -7310 "pn" "clob" 0 0 7318 NULL true 2 NULL -7311 "cl" "clob" 0 0 7318 NULL true 3 NULL -7312 "pp" "clob" 0 0 7318 NULL true 4 NULL -7313 "vn" "clob" 0 0 7318 NULL true 5 NULL -7320 "qname" "clob" 0 0 7331 NULL false 0 NULL -7321 "flag" "smallint" 16 0 7331 NULL false 1 NULL -7322 "rname" "clob" 0 0 7331 NULL false 2 NULL -7323 "pos" "int" 32 0 7331 NULL false 3 NULL -7324 "mapq" "smallint" 16 0 7331 NULL false 4 NULL -7325 "cigar" "clob" 0 0 7331 NULL false 5 NULL -7326 "rnext" "clob" 0 0 7331 NULL false 6 NULL -7327 "pnext" "int" 32 0 7331 NULL false 7 NULL -7328 "tlen" "int" 32 0 7331 NULL false 8 NULL -7329 "seq" "clob" 0 0 7331 NULL false 9 NULL -7330 "qual" "clob" 0 0 7331 NULL false 10 NULL -7412 "function_id" "int" 32 0 7413 NULL true 0 NULL +6281 "qtag" "bigint" 64 0 6289 NULL true 0 NULL +6282 "user" "clob" 0 0 6289 NULL true 1 NULL +6283 "started" "timestamp" 7 0 6289 NULL true 2 NULL +6284 "estimate" "timestamp" 7 0 6289 NULL true 3 NULL +6285 "progress" "int" 32 0 6289 NULL true 4 NULL +6286 "status" "clob" 0 0 6289 NULL true 5 NULL +6287 "tag" "oid" 63 0 6289 NULL true 6 NULL +6288 "query" "clob" 0 0 6289 NULL true 7 NULL +6315 "rowid" "bigint" 64 0 6319 NULL true 0 NULL +6316 "fldid" "int" 32 0 6319 NULL true 1 NULL +6317 "message" "clob" 0 0 6319 NULL true 2 NULL +6318 "input" "clob" 0 0 6319 NULL true 3 NULL +6989 "keyword" "varchar" 40 0 6992 NULL false 0 NULL +6994 "table_type_id" "smallint" 16 0 7000 NULL false 0 NULL +6997 "table_type_name" "varchar" 25 0 7000 NULL false 1 NULL +7002 "dependency_type_id" "smallint" 16 0 7008 NULL false 0 NULL +7005 "dependency_type_name" "varchar" 15 0 7008 NULL false 1 NULL +7023 "file_id" "int" 32 0 7025 NULL true 0 NULL +7024 "location" "char" 256 0 7025 NULL true 1 NULL +7027 "dim_id" "int" 32 0 7031 NULL true 0 NULL +7028 "file_id" "int" 32 0 7031 NULL true 1 NULL +7029 "name" "varchar" 64 0 7031 NULL true 2 NULL +7030 "length" "int" 32 0 7031 NULL true 3 NULL +7033 "var_id" "int" 32 0 7039 NULL true 0 NULL +7034 "file_id" "int" 32 0 7039 NULL true 1 NULL +7035 "name" "varchar" 64 0 7039 NULL true 2 NULL +7036 "vartype" "varchar" 64 0 7039 NULL true 3 NULL +7037 "ndim" "int" 32 0 7039 NULL true 4 NULL +7038 "coord_dim_id" "int" 32 0 7039 NULL true 5 NULL +7041 "var_id" "int" 32 0 7045 NULL true 0 NULL +7042 "dim_id" "int" 32 0 7045 NULL true 1 NULL +7043 "file_id" "int" 32 0 7045 NULL true 2 NULL +7044 "dimpos" "int" 32 0 7045 NULL true 3 NULL +7047 "obj_name" "varchar" 256 0 7053 NULL true 0 NULL +7048 "att_name" "varchar" 256 0 7053 NULL true 1 NULL +7049 "att_type" "varchar" 64 0 7053 NULL true 2 NULL +7050 "value" "clob" 0 0 7053 NULL true 3 NULL +7051 "file_id" "int" 32 0 7053 NULL true 4 NULL +7052 "gr_name" "varchar" 256 0 7053 NULL true 5 NULL +7078 "schema" "clob" 0 0 7092 NULL true 0 NULL +7079 "table" "clob" 0 0 7092 NULL true 1 NULL +7080 "column" "clob" 0 0 7092 NULL true 2 NULL +7081 "type" "clob" 0 0 7092 NULL true 3 NULL +7082 "mode" "clob" 0 0 7092 NULL true 4 NULL +7083 "location" "clob" 0 0 7092 NULL true 5 NULL +7084 "count" "bigint" 64 0 7092 NULL true 6 NULL +7085 "typewidth" "int" 32 0 7092 NULL true 7 NULL +7086 "columnsize" "bigint" 64 0 7092 NULL true 8 NULL +7087 "heapsize" "bigint" 64 0 7092 NULL true 9 NULL +7088 "hashes" "bigint" 64 0 7092 NULL true 10 NULL +7089 "phash" "boolean" 1 0 7092 NULL true 11 NULL +7090 "imprints" "bigint" 64 0 7092 NULL true 12 NULL +7091 "sorted" "boolean" 1 0 7092 NULL true 13 NULL +7094 "schema" "clob" 0 0 7104 NULL true 0 NULL +7095 "table" "clob" 0 0 7104 NULL true 1 NULL +7096 "column" "clob" 0 0 7104 NULL true 2 NULL +7097 "type" "clob" 0 0 7104 NULL true 3 NULL +7098 "typewidth" "int" 32 0 7104 NULL true 4 NULL +7099 "count" "bigint" 64 0 7104 NULL true 5 NULL +7100 "distinct" "bigint" 64 0 7104 NULL true 6 NULL +7101 "atomwidth" "int" 32 0 7104 NULL true 7 NULL +7102 "reference" "boolean" 1 0 7104 NULL true 8 NULL +7103 "sorted" "boolean" 1 0 7104 NULL true 9 NULL +7142 "schema" "clob" 0 0 7152 NULL true 0 NULL +7143 "table" "clob" 0 0 7152 NULL true 1 NULL +7144 "column" "clob" 0 0 7152 NULL true 2 NULL +7145 "type" "clob" 0 0 7152 NULL true 3 NULL +7146 "count" "bigint" 64 0 7152 NULL true 4 NULL +7147 "columnsize" "bigint" 64 0 7152 NULL true 5 NULL +7148 "heapsize" "bigint" 64 0 7152 NULL true 6 NULL +7149 "hashes" "bigint" 64 0 7152 NULL true 7 NULL +7150 "imprints" "bigint" 64 0 7152 NULL true 8 NULL +7151 "sorted" "boolean" 1 0 7152 NULL true 9 NULL +7154 "schema" "clob" 0 0 7162 NULL true 0 NULL +7155 "table" "clob" 0 0 7162 NULL true 1 NULL +7156 "count" "bigint" 64 0 7162 NULL true 2 NULL +7157 "columnsize" "hugeint" 128 0 7162 NULL true 3 NULL +7158 "heapsize" "hugeint" 128 0 7162 NULL true 4 NULL +7159 "hashes" "hugeint" 128 0 7162 NULL true 5 NULL +7160 "imprints" "hugeint" 128 0 7162 NULL true 6 NULL +7161 "auxiliary" "hugeint" 128 0 7162 NULL true 7 NULL +7164 "column_id" "int" 32 0 7175 NULL true 0 NULL +7165 "type" "clob" 0 0 7175 NULL true 1 NULL +7166 "width" "int" 32 0 7175 NULL true 2 NULL +7167 "stamp" "timestamp" 7 0 7175 NULL true 3 NULL +7168 "sample" "bigint" 64 0 7175 NULL true 4 NULL +7169 "count" "bigint" 64 0 7175 NULL true 5 NULL +7170 "unique" "bigint" 64 0 7175 NULL true 6 NULL +7171 "nils" "bigint" 64 0 7175 NULL true 7 NULL +7172 "minval" "clob" 0 0 7175 NULL true 8 NULL +7173 "maxval" "clob" 0 0 7175 NULL true 9 NULL +7174 "sorted" "boolean" 1 0 7175 NULL true 10 NULL +7270 "file_id" "bigint" 64 0 7278 NULL false 0 NULL +7271 "file_location" "clob" 0 0 7278 NULL false 1 NULL +7272 "dbschema" "smallint" 16 0 7278 NULL false 2 NULL +7273 "format_version" "varchar" 7 0 7278 NULL true 3 NULL +7274 "sorting_order" "varchar" 10 0 7278 NULL true 4 NULL +7275 "comments" "clob" 0 0 7278 NULL true 5 NULL +7280 "sn" "clob" 0 0 7291 NULL false 0 NULL +7281 "file_id" "bigint" 64 0 7291 NULL false 1 NULL +7282 "ln" "int" 32 0 7291 NULL true 2 NULL +7283 "as" "int" 32 0 7291 NULL true 3 NULL +7284 "m5" "clob" 0 0 7291 NULL true 4 NULL +7285 "sp" "clob" 0 0 7291 NULL true 5 NULL +7286 "ur" "clob" 0 0 7291 NULL true 6 NULL +7293 "id" "clob" 0 0 7310 NULL false 0 NULL +7294 "file_id" "bigint" 64 0 7310 NULL false 1 NULL +7295 "cn" "clob" 0 0 7310 NULL true 2 NULL +7296 "ds" "clob" 0 0 7310 NULL true 3 NULL +7297 "dt" "timestamp" 7 0 7310 NULL true 4 NULL +7298 "fo" "clob" 0 0 7310 NULL true 5 NULL +7299 "ks" "clob" 0 0 7310 NULL true 6 NULL +7300 "lb" "clob" 0 0 7310 NULL true 7 NULL +7301 "pg" "clob" 0 0 7310 NULL true 8 NULL +7302 "pi" "int" 32 0 7310 NULL true 9 NULL +7303 "pl" "clob" 0 0 7310 NULL true 10 NULL +7304 "pu" "clob" 0 0 7310 NULL true 11 NULL +7305 "sm" "clob" 0 0 7310 NULL true 12 NULL +7312 "id" "clob" 0 0 7322 NULL false 0 NULL +7313 "file_id" "bigint" 64 0 7322 NULL false 1 NULL +7314 "pn" "clob" 0 0 7322 NULL true 2 NULL +7315 "cl" "clob" 0 0 7322 NULL true 3 NULL +7316 "pp" "clob" 0 0 7322 NULL true 4 NULL +7317 "vn" "clob" 0 0 7322 NULL true 5 NULL +7324 "qname" "clob" 0 0 7335 NULL false 0 NULL +7325 "flag" "smallint" 16 0 7335 NULL false 1 NULL +7326 "rname" "clob" 0 0 7335 NULL false 2 NULL +7327 "pos" "int" 32 0 7335 NULL false 3 NULL +7328 "mapq" "smallint" 16 0 7335 NULL false 4 NULL +7329 "cigar" "clob" 0 0 7335 NULL false 5 NULL +7330 "rnext" "clob" 0 0 7335 NULL false 6 NULL +7331 "pnext" "int" 32 0 7335 NULL false 7 NULL +7332 "tlen" "int" 32 0 7335 NULL false 8 NULL +7333 "seq" "clob" 0 0 7335 NULL false 9 NULL +7334 "qual" "clob" 0 0 7335 NULL false 10 NULL +7416 "function_id" "int" 32 0 7417 NULL true 0 NULL COMMIT; START TRANSACTION; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
