# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugDay_2005-10-06_2.8', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 11.667 GiB available main-memory of which we use 9.509 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:45033/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2519134/.s.monetdb.45033
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select null
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select null as v
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: create table t (i integer)
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: insert into t values (null)
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: select * from t where i is null
#2025-04-05 01:02:12: client0015: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:12: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create table allnewtriples (
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index allnewtriples_subject_idx on allnewtriples (subject);
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index allnewtriples_predicate_idx on allnewtriples (predicate);
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index allnewtriples_object_idx on allnewtriples (object);
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create table "foreign" (
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create table "triples" (
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_object_idx" on "triples" ("object");
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_predicate_idx" on "triples" ("predicate");
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_predicate_object_idx" on "triples" ("predicate", "object");
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_subject_idx" on "triples" ("subject");
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_subject_object_idx" on "triples" ("subject", "object");
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: create index "triples_subject_predicate_idx" on "triples" ("subject", "predicate");
#2025-04-05 01:02:13: client0017: SQLrun: INFO: Executing: commit;
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(1, 1, 1, 1, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(2, 1, 1, 2, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(3, 1, 2, 1, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(4, 2, 1, 1, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(5, 1, 2, 2, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(6, 2, 2, 1, false);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into allnewtriples values(7, 2, 2, 2, false);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(1, 1, 1, 1);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(2, 2, 2, 2);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(3, 1, 2, 2);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(4, 2, 2, 1);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(5, 2, 1, 1);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(6, 1, 2, 1);
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: insert into "foreign" values(7, 1, 1, 2);
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: select * from allnewtriples;
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: select * from "foreign";
#2025-04-05 01:02:13: client0018: SQLrun: INFO: Executing: commit;
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select id from sys._columns where table_id = (select id from sys._tables where name = 'db_user_info' and schema_id = 2000) and name = 'max_memory'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select id from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select current_schema
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select name from sys.auths where name not in (select name from sys.db_user_info) and grantor <> 0 order by name
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_384:bat[:str] := mal.multiplex("sql":str, "password":str, X_352:bat[:str]);	#[192] (0)  384 <- 200 201 352 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_385:bat[:str] := mal.multiplex("sql":str, "password":str, X_353:bat[:str]);	#[193] (0)  385 <- 200 201 353 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_386:bat[:str] := mal.multiplex("sql":str, "password":str, X_354:bat[:str]);	#[194] (0)  386 <- 200 201 354 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_387:bat[:str] := mal.multiplex("sql":str, "password":str, X_355:bat[:str]);	#[195] (0)  387 <- 200 201 355 
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select s.name, a.name, rem.remark from sys.schemas s left outer join sys.comments rem on s.id = rem.id, sys.auths a where s."authorization" = a.id and s.system = false order by s.name
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_385:bat[:str] := mal.multiplex("sql":str, "password":str, X_353:bat[:str]);	#[192] (0)  385 <- 200 201 353 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_386:bat[:str] := mal.multiplex("sql":str, "password":str, X_354:bat[:str]);	#[193] (0)  386 <- 200 201 354 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_387:bat[:str] := mal.multiplex("sql":str, "password":str, X_355:bat[:str]);	#[194] (0)  387 <- 200 201 355 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_388:bat[:str] := mal.multiplex("sql":str, "password":str, X_356:bat[:str]);	#[195] (0)  388 <- 200 201 356 
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#remapped: batcalc.!=
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur, sys.db_user_info ui where a1.id = ur.login_id and a2.id = ur.role_id and a1.name = ui.name and a2.id <> ui.default_role order by a1.name, a2.name
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select a.name, pc.grnt, g.name, go.opt from sys.privileges p, sys.auths a, sys.auths g, (values (0, 'COPY INTO'), (1, 'COPY FROM')) as pc (id, grnt), (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = 0 and p.auth_id = a.id and p.grantor = g.id and p.privileges = pc.id and p.grantable = go.id order by a.name, g.name, go.opt
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select s.name, t.systemname, t.sqlname from sys.types t left join sys.schemas s on s.id = t.schema_id where t.eclass = 18 and (t.schema_id <> 2000 or (t.schema_id = 2000 and t.sqlname not in ('geometrya','mbr','url','inet','json','uuid')))order by s.name, t.sqlname
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select sch.name, seq.name, rem.remark from sys.schemas sch, sys.sequences seq left outer join sys.comments rem on seq.id = rem.id where sch.id = seq.schema_id order by sch.name, seq.name
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.id as id, s.name as sname, t.name as name, t.type as type from sys.schemas s, sys._tables t where t.type in (0, 3, 4, 5, 6) and t.system = false and s.id = t.schema_id order by id
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'allnewtriples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'allnewtriples' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'allnewtriples' order by kc.id, kc.nr
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select id from sys.functions where schema_id = 2000 and name = 'check_constraint'
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_450:bat[:str] := mal.multiplex("sql":str, "check":str, X_414:bat[:str], X_422:bat[:str]);	#[202] (0)  450 <- 181 182 414 422 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_451:bat[:str] := mal.multiplex("sql":str, "check":str, X_415:bat[:str], X_423:bat[:str]);	#[203] (0)  451 <- 181 182 415 423 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_452:bat[:str] := mal.multiplex("sql":str, "check":str, X_416:bat[:str], X_424:bat[:str]);	#[204] (0)  452 <- 181 182 416 424 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_453:bat[:str] := mal.multiplex("sql":str, "check":str, X_417:bat[:str], X_425:bat[:str]);	#[205] (0)  453 <- 181 182 417 425 
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'allnewtriples' order by kc.id, kc.nr
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'allnewtriples') order by i.name
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'allnewtriples') order by col.number
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'allnewtriples' and schema_id = (select id from sys.schemas where name = 'sys'))
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'allnewtriples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select * from "sys"."allnewtriples"
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'allnewtriples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'foreign'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'foreign' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'foreign' order by kc.id, kc.nr
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_450:bat[:str] := mal.multiplex("sql":str, "check":str, X_414:bat[:str], X_422:bat[:str]);	#[202] (0)  450 <- 181 182 414 422 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_451:bat[:str] := mal.multiplex("sql":str, "check":str, X_415:bat[:str], X_423:bat[:str]);	#[203] (0)  451 <- 181 182 415 423 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_452:bat[:str] := mal.multiplex("sql":str, "check":str, X_416:bat[:str], X_424:bat[:str]);	#[204] (0)  452 <- 181 182 416 424 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_453:bat[:str] := mal.multiplex("sql":str, "check":str, X_417:bat[:str], X_425:bat[:str]);	#[205] (0)  453 <- 181 182 417 425 
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'foreign' order by kc.id, kc.nr
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'foreign') order by i.name
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'foreign') order by col.number
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'foreign' and schema_id = (select id from sys.schemas where name = 'sys'))
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'foreign'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select * from "sys"."foreign"
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'foreign'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'triples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'triples' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'triples' order by kc.id, kc.nr
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_450:bat[:str] := mal.multiplex("sql":str, "check":str, X_414:bat[:str], X_422:bat[:str]);	#[202] (0)  450 <- 181 182 414 422 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_451:bat[:str] := mal.multiplex("sql":str, "check":str, X_415:bat[:str], X_423:bat[:str]);	#[203] (0)  451 <- 181 182 415 423 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_452:bat[:str] := mal.multiplex("sql":str, "check":str, X_416:bat[:str], X_424:bat[:str]);	#[204] (0)  452 <- 181 182 416 424 
#2025-04-05 01:02:13: client0019: OPTexpandMultiplex: WARNING: To speedup sql.check a bulk operator implementation is needed for     X_453:bat[:str] := mal.multiplex("sql":str, "check":str, X_417:bat[:str], X_425:bat[:str]);	#[205] (0)  453 <- 181 182 417 425 
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'triples' order by kc.id, kc.nr
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'triples') order by i.name
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'triples') order by col.number
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'triples' and schema_id = (select id from sys.schemas where name = 'sys'))
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'triples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select * from "sys"."triples"
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'triples'
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: with vft (sname, name, id, query, remark) as (select s.name as sname, t.name as name, t.id as id, t.query as query, rem.remark as remark from sys.schemas s, sys._tables t left outer join sys.comments rem on t.id = rem.id where t.type = 1 and t.system = false and s.id = t.schema_id and s.name <> 'tmp' union all select s.name as sname, f.name as name, f.id as id, nu
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select s.name, t.name, c.name, c."default" from sys._columns c, sys._tables t, sys.schemas s where c."default" is not null and c.table_id = t.id and t.schema_id = s.id and not t.system
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select ps.name, pkt.name, pkkc.name, fkkc.name, fkkc.nr, fkk.name, fkk."action", fs.name, fkt.name from sys._tables fkt, sys.objects fkkc, sys.keys fkk, sys._tables pkt, sys.objects pkkc, sys.keys pkk, sys.schemas ps, sys.schemas fs where fkt.id = fkk.table_id and pkt.id = pkk.table_id and fkk.id = fkkc.id and pkk.id = pkkc.id and fkk.rkey = pkk.id and fkkc.nr = p
#remapped: batsql.get_value
#remapped: batcalc.==
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.==
#remapped: batcalc.and
#remapped: batcalc.==
#remapped: batcalc.<
#remapped: batcalc.and
#remapped: batcalc.==
#remapped: batcalc.and
#remapped: batcalc.==
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.<
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.<
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.>
#remapped: batcalc.==
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select * from sys.describe_sequences order by sch, seq
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select subq.s1name, subq.t1name, subq.s2name, subq.t2name, table_partitions.type from (select t1.id, t1.type, s1.name as s1name, t1.name as t1name, s2.name as s2name, t2.name as t2name from sys.schemas s1, sys._tables t1, sys.dependencies d, sys.schemas s2, sys._tables t2 where t1.type in (3, 6) and t1.schema_id = s1.id and s1.name <> 'tmp' and t1.system = false a
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.+
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select s.name, t.name, a.name, sum(p.privileges), g.name, go.opt from sys.schemas s, sys.tables t, sys.auths a, sys.privileges p, sys.auths g, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false and p.grantor = g.id and p.grantable = go.id group by s.name, t.name, a.name
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.+
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select s.name, t.name, c.name, a.name, pc.privilege_code_name, g.name, go.opt from sys.schemas s, sys.tables t, sys.columns c, sys.auths a, sys.privileges p, sys.auths g, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = c.id and c.table_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false an
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: select f.id, s.name, f.name, a.type, a.type_digits, a.type_scale, a.inout, a.number, au.name, pc.privilege_code_name, go.opt, ft.function_type_keyword from sys.schemas s, sys.functions f left outer join sys.args a on f.id = a.func_id, sys.auths au, sys.privileges p, sys.auths g, sys.function_types ft, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTIO
#2025-04-05 01:02:13: client0019: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: drop table "sys"."allnewtriples" cascade
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: drop table "sys"."foreign" cascade
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: drop table "sys"."triples" cascade
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: commit
#2025-04-05 01:02:13: client0020: SQLrun: INFO: Executing: commit
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select 'a'+1
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select 1-'a'
#2025-04-05 01:02:13: client0021: SQLrun: INFO: Executing: select true+1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: create table tmp(i int)
#2025-04-05 01:02:13: client0022: SQLrun: INFO: Executing: select i from tmp union select i from tmp
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: drop table "sys"."tmp" cascade
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: create table t(i int, s varchar(10))
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: create table s(j int)
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: select * from t cross join s
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: drop table t
#2025-04-05 01:02:13: client0023: SQLrun: INFO: Executing: drop table s
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: create table t(i int)
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: insert into t values(null)
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: select * from t
#2025-04-05 01:02:13: client0024: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select 'a' 'a'
#2025-04-05 01:02:13: client0025: SQLrun: INFO: Executing: select 'a''a'
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: create table z(w varchar(1))
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: insert into z values('wrong')
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: select * from z
#2025-04-05 01:02:13: client0026: SQLrun: INFO: Executing: drop table z
#SIGUSR1 info start
#Virtual memory allocated: 12625424, of which 9741840 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 10209923584
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 638120224
#Virtual size: 3034914816, anonymous RSS: 88428544, shared RSS: 46923776 (together: 135352320)
#BATs:
#fix, dirty, persistent, loaded, hot: 6 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 1146 bats, 26416 virtual, 26416 malloc
#no fix, dirty, persistent, loaded, hot: 117 bats, 355840 virtual, 355840 malloc
#no fix, dirty, transient, loaded, hot: 53 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 131 bats, 4187931 virtual, 1304347 malloc
#1540 bats total, 1453 in use, 64 free bats in common shared list
#Threads:
#client0026, tid 26, Thread 0x7fd1e08286c0, LWP 2521773, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x7fd1e0a296c0, LWP 2521740, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x7fd1e03e96c0, LWP 2521739, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x7fd1d92606c0, LWP 2521737, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x7fd1e0c2a6c0, LWP 2521734, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fd1e0e2b6c0, LWP 2521733, 8 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7fd1d8e2b6c0, LWP 2521732, 9 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7fd1e102c6c0, LWP 2521731, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fd1e122d6c0, LWP 2521730, 4 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fd26afff6c0, LWP 2521729, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fd26d6ac740, LWP 2521728, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 244
#logger sql:
#current log file 9, last handled log file 8
#current transaction id 9, saved transaction id 4
#number of flushers: 0
#number of catalog entries 252, of which 0 deleted
#pending range 9: drops 0, last_ts 244, flushed_ts 244, refcount 1, file size 1574 (current)
#SIGUSR1 info end
# mserver5 exiting