Test check.SQL.py (id a65d4eb8731b) (err)
check.stable.out.FILTERED 2020-01-14 07:44:21.412945247 +0100check.test.out.FILTERED 2020-01-14 07:44:21.902967911 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb`: 1
2 5549 lines, 200274 words, 1316341 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5563 lines, 201270 words, 1323031 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5549 lines, 200274 words, 1316341 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5563 lines, 201270 words, 1323031 chars in lines not matching '^$|^(\| |)#` 3
4 # 5626 lines, 202588 words, 1332758 chars in all lines 4 ! 4 # 5639 lines, 203583 words, 1339434 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
42 \dn json 42 41 \dn json 41
+ 42 \dn logging 42
43 \dn profiler 43 43 \dn profiler 43
..................
# 10:17:18 >
375 SYSTEM SCHEMA json 375 375 SYSTEM SCHEMA json 375
+ 376 SYSTEM SCHEMA logging 376
376 SYSTEM SCHEMA profiler 376 377 SYSTEM SCHEMA profiler 377
..................
# 10:17:18 >
882 CREATE SCHEMA "json" AUTHORIZATION "monetdb"; 882 883 CREATE SCHEMA "json" AUTHORIZATION "monetdb"; 883
+ 884 CREATE SCHEMA "logging" AUTHORIZATION "monetdb"; 884
883 CREATE SCHEMA "profiler" AUTHORIZATION "monetdb"; 883 885 CREATE SCHEMA "profiler" AUTHORIZATION "monetdb"; 885
..................
#select name, authorization, owner, syst
1444 [ "json", 3, 3, true ] 1444 1446 [ "json", 3, 3, true ] 1446
+ 1447 [ "logging", 3, 3, true ] 1447
1445 [ "profiler", 3, 3, true ] 1445 1448 [ "profiler", 3, 3, true ] 1448
..................
#select s.name, f.name, case f.system wh
2239 [ "json", "valuearray", "SYSTEM", "create function json.valuearray(js json) returns json external name json.valuearray;", "json", "MAL", "Scalar function", false, false, false, "result", "json", 0, 0, "out", "js", "json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2239 2242 [ "json", "valuearray", "SYSTEM", "create function json.valuearray(js json) returns json external name json.valuearray;", "json", "MAL", "Scalar function", false, false, false, "result", "json", 0, 0, "out", "js", "json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2242
+ 2243 [ "logging", "flush", "SYSTEM", "create procedure logging.flush() external name logging.flush;", "logging", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2243
+ 2244 [ "logging", "resetadapter", "SYSTEM", "create procedure logging.resetadapter() external name logging.resetadapter;", "logging", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2244
+ 2245 [ "logging", "resetcomplevel", "SYSTEM", "create procedure logging.resetcomplevel(comp_id int) external name logging.resetcomplevel;", "logging", "MAL", "Procedure", true, false, false, "comp_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2245
+ 2246 [ "logging", "resetflushlevel", "SYSTEM", "create procedure logging.resetflushlevel() external name logging.resetflushlevel;", "logging", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2246
+ 2247 [ "logging", "resetlayerlevel", "SYSTEM", "create procedure logging.resetlayerlevel(layer_id int) external name logging.resetlayerlevel;", "logging", "MAL", "Procedure", true, false, false, "layer_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2247
+ 2248 [ "logging", "setadapter", "SYSTEM", "create procedure logging.setadapter(adapter_id int) external name logging.setadapter;", "logging", "MAL", "Procedure", true, false, false, "adapter_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2248
+ 2249 [ "logging", "setcomplevel", "SYSTEM", "create procedure logging.setcomplevel(comp_id int, lvl_id int) external name logging.setcomplevel;", "logging", "MAL", "Procedure", true, false, false, "comp_id", "int", 32, 0, "in", "lvl_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2249
+ 2250 [ "logging", "setflushlevel", "SYSTEM", "create procedure logging.setflushlevel(lvl_id int) external name logging.setflushlevel;", "logging", "MAL", "Procedure", true, false, false, "lvl_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2250
+ 2251 [ "logging", "setlayerlevel", "SYSTEM", "create procedure logging.setlayerlevel(layer_id int, lvl_id int) external name logging.setlayerlevel;", "logging", "MAL", "Procedure", true, false, false, "layer_id", "int", 32, 0, "in", "lvl_id", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2251
+ 2252 [ "logging", "showinfo", "SYSTEM", "create procedure logging.showinfo() external name logging.showinfo;", "logging", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2252
2240 [ "profiler", "getlimit", "SYSTEM", "create function profiler.getlimit() returns integer external name profiler.getlimit;", "profiler", "MAL", "Scalar function", true, false, false, "result", "int", 32, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2240 2253 [ "profiler", "getlimit", "SYSTEM", "create function profiler.getlimit() returns integer external name profiler.getlimit;", "profiler", "MAL", "Scalar function", true, false, false, "result", "int", 32, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2253