Changeset: 2516a0088ce8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2516a0088ce8 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/backends/monet5/sql.c sql/backends/monet5/sql.h sql/backends/monet5/sql.mal sql/scripts/25_debug.sql sql/storage/sql_storage.h sql/storage/store.c 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 Branch: default Log Message:
implemented manual control over log flushing diffs (truncated from 2931 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -40707,6 +40707,10 @@ pattern sql.eval(cmd:str):void address SQLstatement; comment Compile and execute a single sql statement +command sql.flush_log():void +address SQLflush_log; +comment flush the log now + command sql.getVersion(clientid:int):lng address mvc_getVersion; comment Return the database version identifier for a client diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 --- a/clients/Tests/MAL-signatures.stable.out.int128 +++ b/clients/Tests/MAL-signatures.stable.out.int128 @@ -51646,6 +51646,10 @@ pattern sql.eval(cmd:str):void address SQLstatement; comment Compile and execute a single sql statement +command sql.flush_log():void +address SQLflush_log; +comment flush the log now + command sql.getVersion(clientid:int):lng address mvc_getVersion; comment Return the database version identifier for a client 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 @@ -151,6 +151,7 @@ SYSTEM FUNCTION sys.equals SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.fitsattach SYSTEM FUNCTION sys.fitsload +SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse SYSTEM FUNCTION sys.generate_series SYSTEM FUNCTION sys.geomcollectionfromtext 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 @@ -147,6 +147,7 @@ SYSTEM FUNCTION sys.equals SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.fitsattach SYSTEM FUNCTION sys.fitsload +SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse SYSTEM FUNCTION sys.generate_series SYSTEM FUNCTION sys.geomcollectionfromtext @@ -1620,142 +1621,142 @@ 6210 "def" "clob" 0 0 6212 NULL true 1 N 6211 "status" "clob" 0 0 6212 NULL true 2 NULL 6218 "name" "clob" 0 0 6220 NULL true 0 NULL 6219 "value" "clob" 0 0 6220 NULL true 1 NULL -6250 "qtag" "bigint" 64 0 6258 NULL true 0 NULL -6251 "user" "clob" 0 0 6258 NULL true 1 NULL -6252 "started" "timestamp" 7 0 6258 NULL true 2 NULL -6253 "estimate" "timestamp" 7 0 6258 NULL true 3 NULL -6254 "progress" "int" 32 0 6258 NULL true 4 NULL -6255 "status" "clob" 0 0 6258 NULL true 5 NULL -6256 "tag" "oid" 63 0 6258 NULL true 6 NULL -6257 "query" "clob" 0 0 6258 NULL true 7 NULL -6284 "rowid" "bigint" 64 0 6288 NULL true 0 NULL -6285 "fldid" "int" 32 0 6288 NULL true 1 NULL -6286 "message" "clob" 0 0 6288 NULL true 2 NULL -6287 "input" "clob" 0 0 6288 NULL true 3 NULL -6943 "keyword" "varchar" 40 0 6946 NULL false 0 NULL -6948 "table_type_id" "smallint" 16 0 6954 NULL false 0 NULL -6951 "table_type_name" "varchar" 25 0 6954 NULL false 1 NULL -6956 "dependency_type_id" "smallint" 16 0 6962 NULL false 0 NULL -6959 "dependency_type_name" "varchar" 15 0 6962 NULL false 1 NULL -6977 "file_id" "int" 32 0 6979 NULL true 0 NULL -6978 "location" "char" 256 0 6979 NULL true 1 NULL -6981 "dim_id" "int" 32 0 6985 NULL true 0 NULL -6982 "file_id" "int" 32 0 6985 NULL true 1 NULL -6983 "name" "varchar" 64 0 6985 NULL true 2 NULL -6984 "length" "int" 32 0 6985 NULL true 3 NULL -6987 "var_id" "int" 32 0 6993 NULL true 0 NULL -6988 "file_id" "int" 32 0 6993 NULL true 1 NULL -6989 "name" "varchar" 64 0 6993 NULL true 2 NULL -6990 "vartype" "varchar" 64 0 6993 NULL true 3 NULL -6991 "ndim" "int" 32 0 6993 NULL true 4 NULL -6992 "coord_dim_id" "int" 32 0 6993 NULL true 5 NULL -6995 "var_id" "int" 32 0 6999 NULL true 0 NULL -6996 "dim_id" "int" 32 0 6999 NULL true 1 NULL -6997 "file_id" "int" 32 0 6999 NULL true 2 NULL -6998 "dimpos" "int" 32 0 6999 NULL true 3 NULL -7001 "obj_name" "varchar" 256 0 7007 NULL true 0 NULL -7002 "att_name" "varchar" 256 0 7007 NULL true 1 NULL -7003 "att_type" "varchar" 64 0 7007 NULL true 2 NULL -7004 "value" "clob" 0 0 7007 NULL true 3 NULL -7005 "file_id" "int" 32 0 7007 NULL true 4 NULL -7006 "gr_name" "varchar" 256 0 7007 NULL true 5 NULL -7032 "schema" "clob" 0 0 7046 NULL true 0 NULL -7033 "table" "clob" 0 0 7046 NULL true 1 NULL -7034 "column" "clob" 0 0 7046 NULL true 2 NULL -7035 "type" "clob" 0 0 7046 NULL true 3 NULL -7036 "mode" "clob" 0 0 7046 NULL true 4 NULL -7037 "location" "clob" 0 0 7046 NULL true 5 NULL -7038 "count" "bigint" 64 0 7046 NULL true 6 NULL -7039 "typewidth" "int" 32 0 7046 NULL true 7 NULL -7040 "columnsize" "bigint" 64 0 7046 NULL true 8 NULL -7041 "heapsize" "bigint" 64 0 7046 NULL true 9 NULL -7042 "hashes" "bigint" 64 0 7046 NULL true 10 NULL -7043 "phash" "boolean" 1 0 7046 NULL true 11 NULL -7044 "imprints" "bigint" 64 0 7046 NULL true 12 NULL -7045 "sorted" "boolean" 1 0 7046 NULL true 13 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 "typewidth" "int" 32 0 7058 NULL true 4 NULL -7053 "count" "bigint" 64 0 7058 NULL true 5 NULL -7054 "distinct" "bigint" 64 0 7058 NULL true 6 NULL -7055 "atomwidth" "int" 32 0 7058 NULL true 7 NULL -7056 "reference" "boolean" 1 0 7058 NULL true 8 NULL -7057 "sorted" "boolean" 1 0 7058 NULL true 9 NULL -7096 "schema" "clob" 0 0 7106 NULL true 0 NULL -7097 "table" "clob" 0 0 7106 NULL true 1 NULL -7098 "column" "clob" 0 0 7106 NULL true 2 NULL -7099 "type" "clob" 0 0 7106 NULL true 3 NULL -7100 "count" "bigint" 64 0 7106 NULL true 4 NULL -7101 "columnsize" "bigint" 64 0 7106 NULL true 5 NULL -7102 "heapsize" "bigint" 64 0 7106 NULL true 6 NULL -7103 "hashes" "bigint" 64 0 7106 NULL true 7 NULL -7104 "imprints" "bigint" 64 0 7106 NULL true 8 NULL -7105 "sorted" "boolean" 1 0 7106 NULL true 9 NULL -7108 "schema" "clob" 0 0 7116 NULL true 0 NULL -7109 "table" "clob" 0 0 7116 NULL true 1 NULL -7110 "count" "bigint" 64 0 7116 NULL true 2 NULL -7111 "columnsize" "hugeint" 128 0 7116 NULL true 3 NULL -7112 "heapsize" "hugeint" 128 0 7116 NULL true 4 NULL -7113 "hashes" "hugeint" 128 0 7116 NULL true 5 NULL -7114 "imprints" "hugeint" 128 0 7116 NULL true 6 NULL -7115 "auxiliary" "hugeint" 128 0 7116 NULL true 7 NULL -7118 "column_id" "int" 32 0 7129 NULL true 0 NULL -7119 "type" "clob" 0 0 7129 NULL true 1 NULL -7120 "width" "int" 32 0 7129 NULL true 2 NULL -7121 "stamp" "timestamp" 7 0 7129 NULL true 3 NULL -7122 "sample" "bigint" 64 0 7129 NULL true 4 NULL -7123 "count" "bigint" 64 0 7129 NULL true 5 NULL -7124 "unique" "bigint" 64 0 7129 NULL true 6 NULL -7125 "nils" "bigint" 64 0 7129 NULL true 7 NULL -7126 "minval" "clob" 0 0 7129 NULL true 8 NULL -7127 "maxval" "clob" 0 0 7129 NULL true 9 NULL -7128 "sorted" "boolean" 1 0 7129 NULL true 10 NULL -7219 "file_id" "bigint" 64 0 7227 NULL false 0 NULL -7220 "file_location" "clob" 0 0 7227 NULL false 1 NULL -7221 "dbschema" "smallint" 16 0 7227 NULL false 2 NULL -7222 "format_version" "varchar" 7 0 7227 NULL true 3 NULL -7223 "sorting_order" "varchar" 10 0 7227 NULL true 4 NULL -7224 "comments" "clob" 0 0 7227 NULL true 5 NULL -7229 "sn" "clob" 0 0 7240 NULL false 0 NULL -7230 "file_id" "bigint" 64 0 7240 NULL false 1 NULL -7231 "ln" "int" 32 0 7240 NULL true 2 NULL -7232 "as" "int" 32 0 7240 NULL true 3 NULL -7233 "m5" "clob" 0 0 7240 NULL true 4 NULL -7234 "sp" "clob" 0 0 7240 NULL true 5 NULL -7235 "ur" "clob" 0 0 7240 NULL true 6 NULL -7242 "id" "clob" 0 0 7259 NULL false 0 NULL -7243 "file_id" "bigint" 64 0 7259 NULL false 1 NULL -7244 "cn" "clob" 0 0 7259 NULL true 2 NULL -7245 "ds" "clob" 0 0 7259 NULL true 3 NULL -7246 "dt" "timestamp" 7 0 7259 NULL true 4 NULL -7247 "fo" "clob" 0 0 7259 NULL true 5 NULL -7248 "ks" "clob" 0 0 7259 NULL true 6 NULL -7249 "lb" "clob" 0 0 7259 NULL true 7 NULL -7250 "pg" "clob" 0 0 7259 NULL true 8 NULL -7251 "pi" "int" 32 0 7259 NULL true 9 NULL -7252 "pl" "clob" 0 0 7259 NULL true 10 NULL -7253 "pu" "clob" 0 0 7259 NULL true 11 NULL -7254 "sm" "clob" 0 0 7259 NULL true 12 NULL -7261 "id" "clob" 0 0 7271 NULL false 0 NULL -7262 "file_id" "bigint" 64 0 7271 NULL false 1 NULL -7263 "pn" "clob" 0 0 7271 NULL true 2 NULL -7264 "cl" "clob" 0 0 7271 NULL true 3 NULL -7265 "pp" "clob" 0 0 7271 NULL true 4 NULL -7266 "vn" "clob" 0 0 7271 NULL true 5 NULL -7273 "qname" "clob" 0 0 7284 NULL false 0 NULL -7274 "flag" "smallint" 16 0 7284 NULL false 1 NULL -7275 "rname" "clob" 0 0 7284 NULL false 2 NULL -7276 "pos" "int" 32 0 7284 NULL false 3 NULL -7277 "mapq" "smallint" 16 0 7284 NULL false 4 NULL -7278 "cigar" "clob" 0 0 7284 NULL false 5 NULL -7279 "rnext" "clob" 0 0 7284 NULL false 6 NULL -7280 "pnext" "int" 32 0 7284 NULL false 7 NULL -7281 "tlen" "int" 32 0 7284 NULL false 8 NULL -7282 "seq" "clob" 0 0 7284 NULL false 9 NULL -7283 "qual" "clob" 0 0 7284 NULL false 10 NULL -7365 "function_id" "int" 32 0 7366 NULL true 0 NULL +6252 "qtag" "bigint" 64 0 6260 NULL true 0 NULL +6253 "user" "clob" 0 0 6260 NULL true 1 NULL +6254 "started" "timestamp" 7 0 6260 NULL true 2 NULL +6255 "estimate" "timestamp" 7 0 6260 NULL true 3 NULL +6256 "progress" "int" 32 0 6260 NULL true 4 NULL +6257 "status" "clob" 0 0 6260 NULL true 5 NULL +6258 "tag" "oid" 63 0 6260 NULL true 6 NULL +6259 "query" "clob" 0 0 6260 NULL true 7 NULL +6286 "rowid" "bigint" 64 0 6290 NULL true 0 NULL +6287 "fldid" "int" 32 0 6290 NULL true 1 NULL +6288 "message" "clob" 0 0 6290 NULL true 2 NULL +6289 "input" "clob" 0 0 6290 NULL true 3 NULL +6945 "keyword" "varchar" 40 0 6948 NULL false 0 NULL +6950 "table_type_id" "smallint" 16 0 6956 NULL false 0 NULL +6953 "table_type_name" "varchar" 25 0 6956 NULL false 1 NULL +6958 "dependency_type_id" "smallint" 16 0 6964 NULL false 0 NULL +6961 "dependency_type_name" "varchar" 15 0 6964 NULL false 1 NULL +6979 "file_id" "int" 32 0 6981 NULL true 0 NULL +6980 "location" "char" 256 0 6981 NULL true 1 NULL +6983 "dim_id" "int" 32 0 6987 NULL true 0 NULL +6984 "file_id" "int" 32 0 6987 NULL true 1 NULL +6985 "name" "varchar" 64 0 6987 NULL true 2 NULL +6986 "length" "int" 32 0 6987 NULL true 3 NULL +6989 "var_id" "int" 32 0 6995 NULL true 0 NULL +6990 "file_id" "int" 32 0 6995 NULL true 1 NULL +6991 "name" "varchar" 64 0 6995 NULL true 2 NULL +6992 "vartype" "varchar" 64 0 6995 NULL true 3 NULL +6993 "ndim" "int" 32 0 6995 NULL true 4 NULL +6994 "coord_dim_id" "int" 32 0 6995 NULL true 5 NULL +6997 "var_id" "int" 32 0 7001 NULL true 0 NULL +6998 "dim_id" "int" 32 0 7001 NULL true 1 NULL +6999 "file_id" "int" 32 0 7001 NULL true 2 NULL +7000 "dimpos" "int" 32 0 7001 NULL true 3 NULL +7003 "obj_name" "varchar" 256 0 7009 NULL true 0 NULL +7004 "att_name" "varchar" 256 0 7009 NULL true 1 NULL +7005 "att_type" "varchar" 64 0 7009 NULL true 2 NULL +7006 "value" "clob" 0 0 7009 NULL true 3 NULL +7007 "file_id" "int" 32 0 7009 NULL true 4 NULL +7008 "gr_name" "varchar" 256 0 7009 NULL true 5 NULL +7034 "schema" "clob" 0 0 7048 NULL true 0 NULL +7035 "table" "clob" 0 0 7048 NULL true 1 NULL +7036 "column" "clob" 0 0 7048 NULL true 2 NULL +7037 "type" "clob" 0 0 7048 NULL true 3 NULL +7038 "mode" "clob" 0 0 7048 NULL true 4 NULL +7039 "location" "clob" 0 0 7048 NULL true 5 NULL +7040 "count" "bigint" 64 0 7048 NULL true 6 NULL +7041 "typewidth" "int" 32 0 7048 NULL true 7 NULL +7042 "columnsize" "bigint" 64 0 7048 NULL true 8 NULL +7043 "heapsize" "bigint" 64 0 7048 NULL true 9 NULL +7044 "hashes" "bigint" 64 0 7048 NULL true 10 NULL +7045 "phash" "boolean" 1 0 7048 NULL true 11 NULL +7046 "imprints" "bigint" 64 0 7048 NULL true 12 NULL +7047 "sorted" "boolean" 1 0 7048 NULL true 13 NULL +7050 "schema" "clob" 0 0 7060 NULL true 0 NULL +7051 "table" "clob" 0 0 7060 NULL true 1 NULL +7052 "column" "clob" 0 0 7060 NULL true 2 NULL +7053 "type" "clob" 0 0 7060 NULL true 3 NULL +7054 "typewidth" "int" 32 0 7060 NULL true 4 NULL +7055 "count" "bigint" 64 0 7060 NULL true 5 NULL +7056 "distinct" "bigint" 64 0 7060 NULL true 6 NULL +7057 "atomwidth" "int" 32 0 7060 NULL true 7 NULL +7058 "reference" "boolean" 1 0 7060 NULL true 8 NULL +7059 "sorted" "boolean" 1 0 7060 NULL true 9 NULL +7098 "schema" "clob" 0 0 7108 NULL true 0 NULL +7099 "table" "clob" 0 0 7108 NULL true 1 NULL +7100 "column" "clob" 0 0 7108 NULL true 2 NULL +7101 "type" "clob" 0 0 7108 NULL true 3 NULL +7102 "count" "bigint" 64 0 7108 NULL true 4 NULL +7103 "columnsize" "bigint" 64 0 7108 NULL true 5 NULL +7104 "heapsize" "bigint" 64 0 7108 NULL true 6 NULL +7105 "hashes" "bigint" 64 0 7108 NULL true 7 NULL +7106 "imprints" "bigint" 64 0 7108 NULL true 8 NULL +7107 "sorted" "boolean" 1 0 7108 NULL true 9 NULL +7110 "schema" "clob" 0 0 7118 NULL true 0 NULL +7111 "table" "clob" 0 0 7118 NULL true 1 NULL +7112 "count" "bigint" 64 0 7118 NULL true 2 NULL +7113 "columnsize" "hugeint" 128 0 7118 NULL true 3 NULL +7114 "heapsize" "hugeint" 128 0 7118 NULL true 4 NULL +7115 "hashes" "hugeint" 128 0 7118 NULL true 5 NULL +7116 "imprints" "hugeint" 128 0 7118 NULL true 6 NULL +7117 "auxiliary" "hugeint" 128 0 7118 NULL true 7 NULL +7120 "column_id" "int" 32 0 7131 NULL true 0 NULL +7121 "type" "clob" 0 0 7131 NULL true 1 NULL +7122 "width" "int" 32 0 7131 NULL true 2 NULL +7123 "stamp" "timestamp" 7 0 7131 NULL true 3 NULL +7124 "sample" "bigint" 64 0 7131 NULL true 4 NULL +7125 "count" "bigint" 64 0 7131 NULL true 5 NULL +7126 "unique" "bigint" 64 0 7131 NULL true 6 NULL +7127 "nils" "bigint" 64 0 7131 NULL true 7 NULL +7128 "minval" "clob" 0 0 7131 NULL true 8 NULL +7129 "maxval" "clob" 0 0 7131 NULL true 9 NULL +7130 "sorted" "boolean" 1 0 7131 NULL true 10 NULL +7221 "file_id" "bigint" 64 0 7229 NULL false 0 NULL +7222 "file_location" "clob" 0 0 7229 NULL false 1 NULL +7223 "dbschema" "smallint" 16 0 7229 NULL false 2 NULL +7224 "format_version" "varchar" 7 0 7229 NULL true 3 NULL +7225 "sorting_order" "varchar" 10 0 7229 NULL true 4 NULL +7226 "comments" "clob" 0 0 7229 NULL true 5 NULL +7231 "sn" "clob" 0 0 7242 NULL false 0 NULL +7232 "file_id" "bigint" 64 0 7242 NULL false 1 NULL +7233 "ln" "int" 32 0 7242 NULL true 2 NULL +7234 "as" "int" 32 0 7242 NULL true 3 NULL +7235 "m5" "clob" 0 0 7242 NULL true 4 NULL +7236 "sp" "clob" 0 0 7242 NULL true 5 NULL +7237 "ur" "clob" 0 0 7242 NULL true 6 NULL +7244 "id" "clob" 0 0 7261 NULL false 0 NULL +7245 "file_id" "bigint" 64 0 7261 NULL false 1 NULL +7246 "cn" "clob" 0 0 7261 NULL true 2 NULL +7247 "ds" "clob" 0 0 7261 NULL true 3 NULL +7248 "dt" "timestamp" 7 0 7261 NULL true 4 NULL _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
